You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2019/09/27 20:47:00 UTC

[jira] [Created] (HIVE-22254) Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule

Steve Carlin created HIVE-22254:
-----------------------------------

             Summary: 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
    Affects Versions: 3.1.2
            Reporter: Steve Carlin
         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)