[ https://issues.apache.org/jira/browse/HIVE-22254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17029315#comment-17029315 ]
Vineet Garg commented on HIVE-22254: ------------------------------------ [~jcamachorodriguez] No mv is not being hit, but I am curious should it have? > 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, Materialized views > Affects Versions: 3.1.2 > Reporter: Steve Carlin > Priority: Minor > 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)