[ https://issues.apache.org/jira/browse/HIVE-14249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15495402#comment-15495402 ]
Lefty Leverenz edited comment on HIVE-14249 at 9/16/16 11:53 PM: ----------------------------------------------------------------- Doc note: See HIVE-14486 and HIVE-14488 for new DDL syntax. HIVE-14490 (Block ACID for materialized views) should also be documented, as well as the new configuration parameters *hive.materializedview.fileformat* and *hive.materializedview.serde*. Added a TODOC2.2 label. Here's where the docs belong: * [DDL (new section for CREATE/DROP MATERIALIZED VIEW, perhaps adding ALTER later on) | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] * [DDL -- Describe Table/View/Column | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable/View/Column] * Edit: no, don't document anything here because this isn't a "limitation" it's just common sense -- [Hive Transactions -- Limitations (???) | https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations] -- although the restriction could be mentioned in the DDL doc * [Configuration Properties -- Query and DDL Execution | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryandDDLExecution] was (Author: le...@hortonworks.com): Doc note: See HIVE-14486 and HIVE-14488 for new DDL syntax. HIVE-14490 (Block ACID for materialized views) should also be documented, as well as the new configuration parameters *hive.materializedview.fileformat* and *hive.materializedview.serde*. Added a TODOC2.2 label. Here's where the docs belong: * [DDL (new section for CREATE/DROP MATERIALIZED VIEW, perhaps adding ALTER later on) | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] * [DDL -- Describe Table/View/Column | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable/View/Column] * [Hive Transactions -- Limitations (???) | https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations] * [Configuration Properties -- Query and DDL Execution | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryandDDLExecution] > Add simple materialized views with manual rebuilds > -------------------------------------------------- > > Key: HIVE-14249 > URL: https://issues.apache.org/jira/browse/HIVE-14249 > Project: Hive > Issue Type: New Feature > Components: Materialized views, Parser > Reporter: Alan Gates > Assignee: Jesus Camacho Rodriguez > Labels: TODOC2.2 > Fix For: 2.2.0 > > Attachments: HIVE-10459.2.patch, HIVE-14249.05.patch, > HIVE-14249.06.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)