Jackie-Jiang commented on issue #6724: URL: https://github.com/apache/incubator-pinot/issues/6724#issuecomment-809683795
@kishoreg We can do automatic query rewrite for queries without ordering, but it won't work for the following scenarios: - User wants different ordering, e.g. `select ... having col > 10 order by col asc` - Nested having clause, e.g. `select ... having col1 > 10 and col2 > 5` - Having clause asks for a range, e.g. `select ... having col between 5 and 10 To give accurate result, we need to gather all groups (like common SQL databases), but that would be super expensive. @dongxiaoman @yupeng9 We can keep this issue open, but currently I don't see a good solution yet. Currently `having` should only be used to simplify the client code of filtering on the group-by results. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
