q icon indicating copy to clipboard operation
q copied to clipboard

Published 20 hours ago • verified publisher icon harelba

Can't run nested subquery

Open aghasemi opened this issue 8 years ago • 3 comments

Hi,

Running a query like this:

SELECT c1 FROM (SELECT c1,sum(c2) FROM result.txt GROUP BY c1)

results in this error:

No files matching '(SELECT' have been found

Any solution?

aghasemi avatar Feb 23 '17 09:02 aghasemi

@aghasemi Please see also #102. It may helps you.

serima avatar Feb 27 '17 01:02 serima

Hi @aghasemi . Sorry, selecting from subqueries is not supported. As @serima noted (thanks!), the other issue might help.

I'm considering adding support for this capability in the upcoming version.

harelba avatar Feb 27 '17 22:02 harelba

@harelba that'd be great !

cscetbon avatar Mar 16 '17 03:03 cscetbon