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

Incremental rebuild of MV having aggregate in presence of delete operation

    XMLWordPrintableJSON

    Details

    • Target Version/s:

      Description

      Extension of HIVE-24854: handle cases when the Materialized view definition has aggregation like

      CREATE MATERIALIZED VIEW cmv_mat_view_n5 DISABLE REWRITE TBLPROPERTIES ('transactional'='true') AS
        SELECT cmv_basetable_n5.a, cmv_basetable_2_n2.c, sum(cmv_basetable_2_n2.d)
        FROM cmv_basetable_n5 JOIN cmv_basetable_2_n2 ON (cmv_basetable_n5.a = cmv_basetable_2_n2.a)
        WHERE cmv_basetable_2_n2.c > 10.0
        GROUP BY cmv_basetable_n5.a, cmv_basetable_2_n2.c;
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kkasa Krisztian Kasa
                Reporter:
                kkasa Krisztian Kasa
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m