Closes src-d#56 This PR adds support for the HAVING SQL clause, that allows filtering rows and has support for aggregation functions. For this, the following changes have been made: - New `Having` node, which is essentially a Filter, but it is a different node for the purpose of differentiating between the two of them during the analysis phase. - Having is now parsed. - A new rule for resolving the Having node has been added. Because of the way aggregations are executed (only inside a GroupBy node) it is not possible to execute them in any other node that's not a GroupBy. For this reason, this rule pushes down any aggregation on a Having node to its child, which is the GroupBy node. If the same aggregation is already done on the GroupBy, nothing will be added and the aggregation on the Having node will be replaced with a reference to the result of the aggregation in the GroupBy. Because pushing new aggregations to the GroupBy changes the resulting schema, a Project node is added wrapping the Having node projecting only the columns the GroupBy was initially projecting. Signed-off-by: Miguel Molina <miguel@erizocosmi.co>

TPC-H: unsupported feature: HAVING #56

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions