https://community.cloudera.com/t5/Support-Questions/Error-creating-partitioned-external-table-using-AvroSerDe/m-p/200407#M162428 <P>Have an issue creating a table using the below DDL, please help!</P><P>DDL:</P><PRE>DROP TABLE IF EXISTS cm3rm1_test; CREATE EXTERNAL TABLE cm3rm1_test PARTITIONED BY (process_date string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED as INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' LOCATION 'hdfs://xyz/cm3rm1' TBLPROPERTIES ('avro.schema.url'='hdfs:///abc/AutoGeneratedSchema.avsc'); </PRE><P>trying to create the table using the above is resulting in an error. but works fine without partitioning. <A rel="user" href="https://community.cloudera.com/users/1486/smanjee.html" nodeid="1486">@smanjee</A> <A rel="user" href="https://community.cloudera.com/users/12513/jknulst.html" nodeid="12513">@Jasper</A> took this <A href="https://community.hortonworks.com/questions/22135/is-there-a-way-to-create-hive-table-based-on-avro.html" target="_blank">https://community.hortonworks.com/questions/22135/is-there-a-way-to-create-hive-table-based-on-avro.html</A> as a reference doesn't seem working for me. any suggestions, how to get this working? </P><P>Thanks</P><PRE>Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Partition column name process_date conflicts with table columns. (state=08S01,code=1) </PRE> Tue, 22 May 2018 09:58:42 GMT adithya3838 2018-05-22T09:58:42Z