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

Incremental rebuild of materialized view having aggregate and stored by iceberg

    XMLWordPrintableJSON

Details

    Description

      Currently incremental rebuild of materialized view stored by iceberg which definition query contains aggregate operator is transformed to an insert overwrite statement which contains a union operator if the source tables contains insert operations only. One branch of the union scans the view the other produces the delta.

      This can be improved further: transform the statement to a multi insert statement representing a merge statement to insert new aggregations and update existing.

      Attachments

        Activity

          People

            kkasa Krisztian Kasa
            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 - 5h 40m
                5h 40m