h ‘/foo/write/bar.txt’ OVERWRITE into table tblname; (in
> case the input file to be loaded is not in HDFS but it is present in the
> local system)
>
> Regards,
> Krishnan
>
> From: Aniket Mokashi [mailto:aniket...@gmail.com]
> Sent: Wednesday, January 18, 2012 10:56 AM
&
From: Aniket Mokashi [mailto:aniket...@gmail.com]
Sent: Wednesday, January 18, 2012 10:56 AM
To: user@hive.apache.org
Subject: Re: Related to INSERT QUERY in Hive
how about Load data inpath?
On Tue, Jan 17, 2012 at 9:00 PM, Bhavesh Shah
mailto:bhavesh25s...@gmail.com>> wrote:
Hello,
I am using Hi
Load data inpath will append data into Hive table .. this feature is also
supported in Hive-0.7.*.
Ex: load data local inpath './examples/files/kv1.txt' into table test1;
This commad will append data into test1 table.
On Wed, Jan 18, 2012 at 10:55 AM, Aniket Mokashi wrote:
> how about Load dat
how about Load data inpath?
On Tue, Jan 17, 2012 at 9:00 PM, Bhavesh Shah wrote:
> Hello,
> I am using Hive-0.7.1. I want to append the data in table.
> Is hive-0.7.1 support appending feature or just support OVERWRITE feature?
> When I tried for the appending, the query is not working.
>
> What
Hello Bhavesh Shah:
Appending feature (insert into ) not supported in hive-0.7.*
three ways :
1:hadoop fs -put localfile hdfs:/.../.../table_dir/partiton_dir/
2:use hive-0.8
3: patch your hive with https://issues.apache.org/jira/browse/HIVE-306
2012/1/18 Bhavesh Shah
> Hello,
> I am using