[CALCITE-751] Push aggregate with aggregate functions through join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 04/Jun/15 22:10
• Updated: 19/Aug/23 00:23
• Resolved: 24/Jul/15 09:18

Description

AggregateJoinTransposeRule currently only fires if the Aggregate has no aggregate functions. We need to lift that limitation.

Aggregate functions should be split, e.g. COUNT becomes SUM of COUNT. Some aggregate functions cannot be split, e.g. distinct-count.

Add a new interface to SqlAggFunction to allow it to declare the split policy.

Issue Links

• depends upon: CALCITE-794 Detect cycles when computing statistics
• is related to: CALCITE-366 Support Aggregate push down in bushy joins
• relates to: CALCITE-896 Remove Aggregate if grouping columns are unique and all functions are splittable
• relates to: DRILL-3840 Add support for in UDF two-phased aggregate merging for UDAFs