Jackie-Jiang opened a new pull request, #13784: URL: https://github.com/apache/pinot/pull/13784
Fix #13749 For filtered aggregate group-by queries, when there are mixed same aggregate with and without filter, and the ordering is applied to the aggregate without filter, we might get wrong result because we read the index of the aggregate from a map without filter info. E.g. for this query: `SELECT DestCityName, COUNT(*) AS c1, COUNT(*) FILTER (WHERE AirTime = 0) AS c2 FROM mytable GROUP BY DestCityName ORDER BY c1 DESC LIMIT 10`, it might end up mistakenly ordering on `c2` column. The fix is to remove the map of aggregate index without the filter info and always use the one with filter info. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
