[GitHub] [incubator-pinot] Jackie-Jiang commented on issue #6724: Query do not return enough results with filter of "group by , having"

[GitBox <gi...@apache.org>]

Jackie-Jiang commented on issue #6724:
URL: https://github.com/apache/incubator-pinot/issues/6724#issuecomment-809572378


   This is a known limitation for `HAVING` clause because the having is computed on broker side only. We don't transfer results from all the groups from servers to broker for performance concern, so in order to get the correct result, you should sort the groups: `SELECT transaction_id, count(*) as cnt FROM point_transaction where created_at >=1616760000 and created_at < 1616846400 group by transaction_id order by cnt desc having cnt > 1 limit 400`


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org