Jesus Camacho Rodriguez created HIVE-20820: ----------------------------------------------
Summary: 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 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)