https://community.cloudera.com/t5/Support-Questions/Hive-Dynamic-partition-issue/m-p/189640#M151733 <P>I have 2 tables as below.</P><PRE><CODE>CREATE EXTERNAL TABLE IF NOT EXISTS TEMP_tab(id int,mytime STRING,age int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 'hdfs://xxx'; CREATE TABLE IF NOT EXISTS main_TAB(id int,age int) PARTITIONED BY (mytime STRING) STORED AS ORC tblproperties ("orc.compress"="ZLIB"); FROM TEMP_TAB INSERT OVERWRITE TABLE main_TAB PARTITION (mytime) SELECT *,substr(mytime,0,10) as mytime; </CODE></PRE><P>but the strange thing is Insert does not work. It has following error message</P><BLOCKQUOTE> <P>Error: org.apache.spark.sql.AnalysisException: Cannot insert into table <CODE>m16</CODE>.<CODE>main_TAB</CODE> because the number of columns are different: need 2 columns, but query has 3 columns.; (state=,code=0)</P></BLOCKQUOTE><P>I have already set these 2 as well</P><PRE><CODE>SET hive.exec.dynamic.partition = true </CODE></PRE><P>SET hive.exec.dynamic.partition.mode = nonstrict</P> Mon, 06 Nov 2017 15:03:55 GMT learnsqoop 2017-11-06T15:03:55Z