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

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 3.1.2
    • 4.0.0
    • CBO, Materialized views
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jcamachorodriguez Jesus Camacho Rodriguez Assign to me
            scarlin Steve Carlin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment