-
Type:
New Feature
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2.3.0
-
Component/s: Materialized views, Parser
-
Labels:
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.
- incorporates
-
HIVE-14485 Create 'materialized view' table type
-
- Resolved
-
-
HIVE-14486 Add CREATE MATERIALIZED VIEW statement
-
- Resolved
-
-
HIVE-14488 Add DROP MATERIALIZED VIEW statement
-
- Resolved
-
-
HIVE-14489 Add tests for DESCRIBE [EXTENDED|FORMATTED] statement on materialized views
-
- Resolved
-
-
HIVE-14490 Block ACID for materialized views
-
- Resolved
-
-
HIVE-14491 Implement access control for materialized views
-
- Resolved
-
-
HIVE-14492 Optimize query in CREATE MATERIALIZED VIEW statement in Calcite
-
- Resolved
-
- is part of
-
HIVE-10459 Add materialized views to Hive
-
- Resolved
-
- is related to
-
HIVE-14484 Extensions for initial materialized views implementation
-
- Resolved
-
- links to