[
https://issues.apache.org/jira/browse/HIVE-22254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17029304#comment-17029304
]
Jesus Camacho Rodriguez commented on HIVE-22254:
------------------------------------------------
[~vgarg], is the materialized view hit? If this is not reproducible anymore,
can we add the test attached to the JIRA and close this issue? Thanks
> 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)
