You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2021/06/24 14:35:00 UTC
[jira] [Resolved] (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:all-tabpanel ]
Jesus Camacho Rodriguez resolved HIVE-22254.
--------------------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
> 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
> Assignee: Vineet Garg
> Priority: Minor
> Fix For: 4.0.0
>
> 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)