[GitHub] [druid] NOmri opened a new issue #11612: Union queries with group by clause failure

[GitBox <gi...@apache.org>]

NOmri opened a new issue #11612:
URL: https://github.com/apache/druid/issues/11612


   ### Affected Version
   0.21.1
   
   ### Description
   This query is working in version  0.19.0
   SELECT count(*) as cnt
   0 as a
   0 as b
   0 as c
   FROM "datasource"
   WHERE FLOOR(__time TO HOUR) >= '2021-08-15 00:00:00' AND FLOOR(__time TO HOUR) <= '2021-08-15 23:00:00'
   GROUP BY item_id
   UNION ALL
   SELECT 0 as cnt
   sum(a) as a
   sum(b) as b
   sum(c) as c
   FROM "datasource"
   WHERE FLOOR(__time TO HOUR) >= '2021-08-15 00:00:00' AND FLOOR(__time TO HOUR) <= '2021-08-15 23:00:00'
   
   but in later version we're getting the following error:
   Error: Unknown exception
   Error while applying rule DruidQueryRule(AGGREGATE_PROJECT), args [rel#170209:LogicalProject.NONE.[
   
   Tested in various clusters from 1 data node up to 6 data nodes
   
   Thanks


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



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