https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML
2011/8/12 Daniel,Wu <hadoop...@163.com> > suppose the table is partitioned by period_key, and the csv file also has > a column named as period_key. The csv file contains multiple days of data, > how can we load it in the the table? > > I think of an workaround by first load the data into a non-partition table, > and then insert the data from non-partition table to the partition table. > > hive> INSERT OVERWRITE TABLE sales SELECT * FROM sales_temp; > FAILED: Error in semantic analysis: need to specify partition columns > because the destination table is partitioned. > > > However it doesn't work also. please help. > > >
