Hi Sanjeev - Did you try to change your query to explicitly specify par.*
create table sample_table AS select par.* from parquet_table par inner join parquet_table_counter ptc ON ptc.user_id=par.user_id; Thanks. From: Sanjeev Verma <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Monday, October 12, 2015 at 2:07 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: hive create table error I am creating a table from the two parquet partioned tables and getting the error duplicate column. any idea whats going wrong here. create table sample_table AS select * from parquet_table par inner join parquet_table_counter ptc ON ptc.user_di=par.user_id; FAILED: SemanticException [Error 10036]: Duplicate column name: user_id
