You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Raj Hadoop <ha...@yahoo.com> on 2013/07/05 19:00:33 UTC
Loading a flat file + one additional field to a Hive table
Hi,
Can any one please suggest the best way to do the following in Hive?
Load 'todays date stamp' + << ALL FIELDS C1,C2,C3,C4 IN A FILE F1 >> to a Hive table T1 ( D1,C1,C2,C3,C4)
Can the following command be modified in some way to acheive the above
hive > load data local inpath '/software/home/hadoop/dat_files/' into table T1;
My requirement is to append a date stamp to a Web log file and then load it to Hive table.
Thanks,
Raj