Steve Carlin created HIVE-22254: ----------------------------------- Summary: Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule Key: HIVE-22254 URL: https://issues.apache.org/jira/browse/HIVE-22254 Project: Hive Issue Type: Sub-task Components: CBO Affects Versions: 3.1.2 Reporter: Steve Carlin Attachments: ojoin_full.sql
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; -- This message was sent by Atlassian Jira (v8.3.4#803005)