john-bodley opened a new issue #7207: Druid SQL filtered aggregate fails with 
WHERE clause containing three or more conditions 
URL: https://github.com/apache/incubator-druid/issues/7207
 
 
   ### Affected Version
   
   0.12.2.1.
   
   ### Description
   
   When running a query containing a filtered aggregate where the `WHERE` 
clause contains three (or more) conditions, i.e., 
   ```
   SELECT SUM(x) FILTER (WHERE a AND b AND c)
   ```
   
   it fails with the following (sanitized) error, 
   ```
   Unknown exception (java.lang.RuntimeException): Error while applying rule 
DruidQueryRule:SELECT_PROJECT, args 
[rel#19421869:LogicalProject.NONE.[](input=rel#19421867:Subset#6.NONE.[],__timestamp=...]
   ```
   
   Note if you remove any one of the conditions in the `WHERE` clause the query 
successfully executes.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to