It is not supported yet but I am working on it (see jira hive-936) Thanks, Ning ------ Sent from my blackberry
________________________________ From: Ryan LeCompte <[email protected]> To: [email protected] <[email protected]> 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
