[HIVE-24232] Incorrect translation of rollup expression from Calcite

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 06/Oct/20 03:29
• Updated: 27/Feb/24 22:23
• Resolved: 07/Oct/20 22:08

Description

In Calcite, it is not necessary that the columns in the group set are in the same order as the rollup. For instance, this is the Calcite representation of a rollup for a given query:

    HiveAggregate(group=[{1, 6, 7}], groups=[[{1, 6, 7}, {1, 7}, {1}, {}]], agg#0=[sum($12)], agg#1=[count($12)], agg#2=[sum($4)], agg#3=[count($4)], agg#4=[sum($15)], agg#5=[count($15)])

When we generate the Hive plan from the Calcite operator, we make such assumption incorrectly.

Issue Links

• links to: GitHub Pull Request #1554