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