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

Optimize MV: Materialized views should not rebuild when tables are not modified

    XMLWordPrintableJSON

    Details

      Description

      e.g

      create materialized view c_c_address as 
      select c_customer_sk from customer c, customer_address ca where c_current_addr_sk = ca.ca_address_id;
      
      ALTER MATERIALIZED VIEW c_c_address REBUILD; <-- This shouldn't trigger rebuild, when source tables are not modified
      
       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kkasa Krisztian Kasa
                Reporter:
                rajesh.balamohan Rajesh Balamohan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 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 - 2.5h
                  2.5h