[ https://issues.apache.org/jira/browse/HIVE-18842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-18842: ------------------------------------------- Status: Patch Available (was: In Progress) > 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 > Attachments: HIVE-18842.patch > > > 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)