druid-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] egor-ryashin opened a new issue #6293: Cannot select columns from group by subquery
Date Mon, 03 Sep 2018 20:20:16 GMT
egor-ryashin opened a new issue #6293: Cannot select columns from group by subquery
URL: https://github.com/apache/incubator-druid/issues/6293
 
 
   Query like this fails:
   ```sql
   select cn from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01
13:00:00' group by cn limit 10)
   ```
   ```
   {"error":"Unknown exception","errorMessage":"Cannot build plan for query: select cn from
(select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group by
cn limit 10)
   ```
   
   While `*` works:
   ```sql
   select * from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP '2018-09-01
13:00:00' group by cn limit 10)
   ```
   
   Removal of `count(*)` also works:
   ```sql
   select cn from (select cn from dt WHERE __time > TIMESTAMP '2018-09-01 13:00:00' group
by cn limit 10)
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Mime
View raw message