Re: Related to INSERT QUERY in Hive

2012-01-18 Thread alo alt
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 &

RE: Related to INSERT QUERY in Hive

2012-01-17 Thread Krishnan Krishnamoorthy
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

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Ankit Jain
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

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Aniket Mokashi
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

Re: Related to INSERT QUERY in Hive

2012-01-17 Thread Able C
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