[HIVE-14249] Add simple materialized views with manual rebuilds

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Materialized views, Parser
• Labels: TODOC2.3
• Assignee: Jesús Camacho Rodríguez Assign to me
• Reporter: Alan Gates
• Created: 15/Jul/16 17:30
• Updated: 27/Feb/24 22:23
• Resolved: 15/Sep/16 14:20

Description

‎此修补程序是从实现简单视图开始的。它没有足够的测试（例如，没有阴性测试）。我知道它在分区的情况下失败了。我怀疑像安全和锁定这样的事情也无法正常工作。但我把它作为一个起点发布。‎

‎在这个初始补丁中，我只是通过手动重新生成来处理简单的实例化视图。在以后的JIRA中，我们可以添加一些功能，例如允许优化程序重写查询以使用实例化视图而不是查询中命名的表，从而使优化程序能够确定实例化视图何时过时等。‎

‎另外，在从 svn->git 迁移后，我没有针对主干重新调整此修补程序的基础，因此它可能无法完全应用。‎

Issue Links

• incorporates: HIVE-14485 Create 'materialized view' table type
• incorporates: HIVE-14486 Add CREATE MATERIALIZED VIEW statement
• incorporates: HIVE-14488 Add DROP MATERIALIZED VIEW statement
• incorporates: HIVE-14489 Add tests for DESCRIBE [EXTENDED|FORMATTED] statement on materialized views
• incorporates: HIVE-14490 Block ACID for materialized views
• incorporates: HIVE-14491 Implement access control for materialized views
• incorporates: HIVE-14492 Optimize query in CREATE MATERIALIZED VIEW statement in Calcite
• is part of: HIVE-10459 Add materialized views to Hive
• is related to: HIVE-14484 Extensions for initial materialized views implementation
• links to: GitHub Pull Request #91

Sub-Tasks

• Create 'materialized view' table type: Resolved
• Add CREATE MATERIALIZED VIEW statement: Resolved
• Add DROP MATERIALIZED VIEW statement: Resolved
• Add tests for DESCRIBE [EXTENDED|FORMATTED] statement on materialized views: Resolved
• Block ACID for materialized views: Resolved
• Implement access control for materialized views: Resolved
• Optimize query in CREATE MATERIALIZED VIEW statement in Calcite: Resolved