Raj, You should dump the data in a temp table first and then move the data into final table with select query. Select date(), c1,c2..... From temp table. Reason: we should avoid custom operation in load unless it is necessary.
Sent via Rocket from my HTC ----- Reply message ----- From: "Raj Hadoop" <[email protected]> To: "Hive" <[email protected]> Subject: Loading a flat file + one additional field to a Hive table Date: Fri, Jul 5, 2013 10:30 PM 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
