[ https://issues.apache.org/jira/browse/HIVE-20820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-20820: ------------------------------------------- Description: It should obey the following syntax as per https://cwiki.apache.org/confluence/display/Hive/Materialized+views : {code} CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name [DISABLE REWRITE] [COMMENT materialized_view_comment] [PARTITIONED ON (col_name, ...)] [ [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 <query>; {code} Currently it is positioned just before TBLPROPERTIES. was: It should obey the following syntax as per https://cwiki.apache.org/confluence/display/Hive/Materialized+views: {code} CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name [DISABLE REWRITE] [COMMENT materialized_view_comment] [PARTITIONED ON (col_name, ...)] [ [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 <query>; {code} Currently it is positioned just before TBLPROPERTIES. > MV partition on clause position > ------------------------------- > > Key: HIVE-20820 > URL: https://issues.apache.org/jira/browse/HIVE-20820 > Project: Hive > Issue Type: Bug > Components: Materialized views > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Minor > Fix For: 4.0.0, 3.2.0 > > Attachments: HIVE-20820.patch > > > It should obey the following syntax as per > https://cwiki.apache.org/confluence/display/Hive/Materialized+views : > {code} > CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name > [DISABLE REWRITE] > [COMMENT materialized_view_comment] > [PARTITIONED ON (col_name, ...)] > [ > [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 > <query>; > {code} > Currently it is positioned just before TBLPROPERTIES. -- This message was sent by Atlassian JIRA (v7.6.3#76005)