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

MV rewriting for distinct and count(distinct) not being triggered

    XMLWordPrintableJSON

    Details

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

      Description

      Count distinct issues with materialized views.  Two scripts attached

      1) 

      create materialized view base_aview stored as orc as select distinct c1 c1, c2 c2 from base;

      explain extended select count(distinct c1) from base group by c2 ;

      2)

      create materialized view base_aview stored as orc as SELECT c1 c1, c2 c2, sum(c2) FROM base group by 1,2;

      explain extended select count(distinct c1) from base group by c2;

        Attachments

        1. count-distinct.sql
          0.7 kB
          Steve Carlin
        2. count-distinct2.sql
          0.7 kB
          Steve Carlin
        3. HIVE-22263.patch
          9 kB
          Jesus Camacho Rodriguez

          Activity

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez
              Reporter:
              scarlin Steve Carlin
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: