I've submitted a PR to remove the code for HAVING clause handling because it is not properly done and the result is not accurate: https://github.com/apache/incubator-pinot/pull/5570