Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22253 General task tracking improvements for materialized views
  3. HIVE-22254

Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 4.0.0
    • Component/s: CBO, Materialized views
    • Labels:
      None

      Description

      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;

        Attachments

        1. ojoin_full.sql
          1 kB
          Steve Carlin

          Issue Links

            Activity

              People

              • Assignee:
                vgarg Vineet Garg
                Reporter:
                scarlin Steve Carlin
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: