Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19114

MV rewriting not being triggered for last query in materialized_view_rewrite_4.q

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 3.0.0
    • None
    • Materialized views
    • None

    Description

      create materialized view mv1 enable rewrite as
      select dependents.empid, emps.deptno, count(distinct salary) as s
      from emps
      join dependents on (emps.empid = dependents.empid)
      group by dependents.empid, emps.deptno;
      
      select emps.deptno, count(distinct salary) as s
      from emps
      join dependents on (emps.empid = dependents.empid)
      group by dependents.empid, emps.deptno;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jcamachorodriguez Jesus Camacho Rodriguez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: