Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Re: Loading a flat file + one additional field to a Hive table


+
manishbhoge@...) 2013-07-05, 17:39
+
Sanjay Subramanian 2013-07-05, 20:32
+
Raj Hadoop 2013-07-05, 22:27
+
Sanjay Subramanian 2013-07-06, 07:51
Copy link to this message
-
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