You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (Jira)" <ji...@apache.org> on 2020/02/03 18:43:00 UTC
[jira] [Commented] (HIVE-22254) Mappings.NoElementException: no
target in mapping, in `MaterializedViewAggregateRule
[ https://issues.apache.org/jira/browse/HIVE-22254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17029178#comment-17029178 ]
Vineet Garg commented on HIVE-22254:
------------------------------------
[~scarlin] I am unable to reproduce this on upstream using the attached repro. Is this still an issue?
> 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)