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

Degenerate case where mv not being used: computing aggregate on group by field

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.2
    • Fix Version/s: None
    • Component/s: CBO, Materialized views
    • Labels:
      None

      Description

      This is a degenerate case, but still should work.  There is no reason to do a min(userid) when grouping by userid (should just use "userid" directly), but it should rewrite regardless

      Script is attached.

      Example:

      create materialized view view1 stored as orc as select userid, sum(sales_amt) from base group by 1;

      explain extended select min(userid) from base group by userid;

        Attachments

        1. compensable.sql
          0.8 kB
          Steve Carlin

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              scarlin Steve Carlin
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: