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.
