[ https://issues.apache.org/jira/browse/HIVE-18842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-18842: ------------------------------------------- Description: 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} was: We should support defining a {{CLUSTER BY/DISTRIBUTE BY/SORT BY}} 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] [CLUSTER BY (col_name, ...) | ( [DISTRIBUTE BY (col_name, ...)] [SORT BY (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} > 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 > > 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)