Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> how to load data to partitioned table

Copy link to this message
Re: how to load data to partitioned table

2011/8/12 Daniel,Wu <[EMAIL PROTECTED]>

>   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.