[ 
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)

Reply via email to