[ 
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)

Reply via email to