hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ryan LeCompte <lecom...@gmail.com>
Subject Loading data into Hive with the partition column defined in the data
Date Tue, 02 Mar 2010 20:56:53 GMT
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

Mime
View raw message