r@hive.apache.org>"
mailto:user@hive.apache.org>>
Subject: Re: Loading a flat file + one additional field to a Hive table
Thanks Sanjay. I will look into this.
Also - one more question.
When I am trying to load log file to Hive and comparing the counts like this
select count(*) fro
? Any
tips please.
From: Sanjay Subramanian
To: "user@hive.apache.org" ; Raj Hadoop
Sent: Saturday, July 6, 2013 4:32 AM
Subject: Re: Loading a flat file + one additional field to a Hive table
How about this ?
Assume you have a log file called
oompaloompa.log
TIMESTAM
hive.apache.org>>
Date: Friday, July 5, 2013 10:39 AM
To: Raj Hadoop mailto:hadoop...@yahoo.com>>, Hive
mailto:user@hive.apache.org>>
Subject: Re: Loading a flat file + one additional field to a Hive table
Raj,
You should dump the data in a temp table first and then move the dat
t;Raj Hadoop"
To: "Hive"
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 F
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 '/
