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

Add simple materialized views with manual rebuilds

          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

                    • Assignee:
                      jcamachorodriguez Jesus Camacho Rodriguez
                      Reporter:
                      alangates Alan Gates
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      14 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: