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

Add simple materialized views with manual rebuilds

    XMLWordPrintableJSON

Details

    Description

      This patch is a start at implementing simple views. It doesn't have enough testing yet (e.g. there's no negative testing). And I know it fails in the partitioned case. I suspect things like security and locking don't work properly yet either. But I'm posting it as a starting point.

      In this initial patch I'm just handling simple materialized views with manual rebuilds. In later JIRAs we can add features such as allowing the optimizer to rewrite queries to use materialized views rather than tables named in the queries, giving the optimizer the ability to determine when a materialized view is stale, etc.

      Also, I didn't rebase this patch against trunk after the migration from svn->git so it may not apply cleanly.

      Attachments

        1. HIVE-14249.06.patch
          182 kB
          Jesus Camacho Rodriguez
        2. HIVE-14249.05.patch
          198 kB
          Jesus Camacho Rodriguez
        3. HIVE-10459.2.patch
          123 kB
          Jesus Camacho Rodriguez

        Issue Links

          incorporates

          Sub-task - The sub-task of the issue HIVE-14485 Create 'materialized view' table type

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14486 Add CREATE MATERIALIZED VIEW statement

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14488 Add DROP MATERIALIZED VIEW statement

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14489 Add tests for DESCRIBE [EXTENDED|FORMATTED] statement on materialized views

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14490 Block ACID for materialized views

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14491 Implement access control for materialized views

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-14492 Optimize query in CREATE MATERIALIZED VIEW statement in Calcite

          • Major - Major loss of function.
          • Resolved
          is part of

          New Feature - A new feature of the product, which has yet to be developed. HIVE-10459 Add materialized views to Hive

          • Major - Major loss of function.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-14484 Extensions for initial materialized views implementation

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #91

          Activity

            People

              jcamachorodriguez Jesus Camacho Rodriguez
              gates Alan Gates
              Votes:
              0 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: