kmozaid opened a new issue, #13982: URL: https://github.com/apache/pinot/issues/13982
`select AirlineId, count(*) filter (where OriginStateName = 'xyz') from airlineStats group by AirlineId limit 10` - This query does not produce any result. `select AirlineId, count(*) filter (where OriginStateName = 'xyz'), count(*) from airlineStats group by AirlineId limit 10` - Here added one more aggregation, now it will produce the result, and "aggregation with filter" column will have value as 0 in all rows. `select AirlineId, count(*) filter (where OriginStateName = 'xyz') from airlineStats group by AirlineId limit 10` and `select AirlineId, count(*) from airlineStats where where OriginStateName = 'xyz' group by AirlineId limit 10` queries are behaving same, although user expect all matching group keys to return with value as 0 -- 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-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
