hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel,Wu" <hadoop...@163.com>
Subject how to load data to partitioned table
Date Fri, 12 Aug 2011 06:30:04 GMT
  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.

Mime
View raw message