[HIVE-22254] Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO, Materialized views
• Assignee: Vineet Garg
• Reporter: Steve Carlin
• Created: 27/Sep/19 20:46
• Updated: 27/Feb/24 22:23
• Resolved: 24/Jun/21 14:34

Description

A Mappings.NoElementException happens on an edge condition for a query using a materialized view.

The query contains a "group by" clause which contains fields from both sides of a join.  There is no real reason to group by this same field twice, but there is also no reason that this shouldn't succeed.

Attached is a script which causes this failure.  The query causing the problem looks like this:

explain extended select sum(1)

from fact inner join dim1

on fact.f1 = dim1.pk1

group by f1, pk1;

Issue Links

• Is contained by: HIVE-23456 Upgrade Calcite version to 1.25.0
• relates to: CALCITE-3848 Rewriting for materialized view consisting of group by on join keys fails with Mappings$NoElementException
• relates to: CALCITE-3862 Materialized view rewriting algorithm throws IndexOutOfBoundsException