[Hive-user] Loading data into Hive with the partition column defined in the data

It is not supported yet but I am working on it (see jira hive-936)

Thanks,
Ning
------
Sent from my blackberry

________________________________
From: Ryan LeCompte <lecompte@gmail.com>
To: hive-user@hadoop.apache.org <hive-user@hadoop.apache.org>
Sent: Tue Mar 02 12:56:53 2010
Subject: Loading data into Hive with the partition column defined in the data

Hello all,

I know that you can load data into Hive via:

LOAD DATA LOCAL INPATH '/my/path/to/data.csv' OVERWRITE INTO TABLE my_table PARTITION(dt='XYZ');

... where dt=XYZ is the partition where the data should be stored.

However, what if data.csv actually had the dt column specified? Is there a way to get Hive to correctly insert each line of data.csv into my_table under the right partition with one LOAD command?

Thanks,
Ryan

Thanks!