Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB