[CALCITE-3123] In RelBuilder, eliminate duplicate aggregate calls

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 07/Jun/19 21:14
• Updated: 03/Jul/19 19:02
• Resolved: 03/Jul/19 19:02

Description

In RelBuilder, eliminate duplicate aggregate calls. For example, if you call RelBuilder.aggregate with sum($1), sum($2), count($1), sum($1) then it would create an Aggregate with 3 aggregate calls (because sum($1) occurs twice), then add a Project [$1, $2, $3, $1]. The Project is necessary so that you get the number of output fields that you are expecting.

Issue Links

• relates to: CALCITE-3145 RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions
• links to: Dev branch