[ https://issues.apache.org/jira/browse/HIVE-18842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16880849#comment-16880849 ]
Jesus Camacho Rodriguez commented on HIVE-18842: ------------------------------------------------ Had to regenerate a few q files in latest patch due to HIVE-21947. > CLUSTERED ON/DISTRIBUTED ON+SORTED ON support for materialized views > -------------------------------------------------------------------- > > Key: HIVE-18842 > URL: https://issues.apache.org/jira/browse/HIVE-18842 > Project: Hive > Issue Type: New Feature > Components: Materialized views > Affects Versions: 3.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > Labels: pull-request-available, todoc4.0 > Attachments: HIVE-18842.01.patch, HIVE-18842.01.patch, > HIVE-18842.02.patch, HIVE-18842.03.patch, HIVE-18842.03.patch, > HIVE-18842.04.patch, HIVE-18842.patch > > Time Spent: 1.5h > Remaining Estimate: 0h > > We should support defining a {{CLUSTERED ON/DISTRIBUTED ON+SORTED ON}} > specification for materialized views. > The syntax should be extended as follows: > {code:sql} > CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name > [COMMENT materialized_view_comment] > [PARTITIONED ON (col_name, ...)] > [CLUSTERED ON (col_name, ...) | DISTRIBUTED ON (col_name, ...) SORTED ON > (col_name, ...)] -- NEW! > [ > [ROW FORMAT row_format] > [STORED AS file_format] > | STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)] > ] > [LOCATION hdfs_path] > [TBLPROPERTIES (property_name=property_value, ...)] > AS select_statement; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)