taohu18 opened a new issue, #8996: URL: https://github.com/apache/pinot/issues/8996
Here is an example query SELECT DISTINCTCOUNT(name) count, CASE WHEN age < 2 THEN '0-2' WHEN age < 4 THEN '2-4' ELSE '4+' END age_range FROM SAMPLE_TABLE WHERE age >= 0 GROUP BY age_range LIMIT 10 In the table, 3 people has age between 0 and 2, 2 people has age between 2-4, and 4 people has age above 4. But the result of the above query shows 0-2 has 0 people, 2-4 has 5 people and 4+ has 4 people. It adds up the count of first two case when and store the result in the case when before ELSE. Above query is just a simple example, my production query has 7 CASE WHENs and the result adds up the count of all CASE WHENs and store the total in the last CASE WHEN group before ELSE This bug only occurs in 0.10.0, in 0.9.3 it works as expected. -- 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
