This is not the recommended way to load large data volumes into Hive. Check the
external table feature, scoop, and the Orc/parquet formats
> On 08 Jun 2016, at 14:03, raj hive wrote:
>
> Hi Friends,
>
> I have to insert the data into hive table from Java program. Insert query
> will work in
Hi Friends,
I have to insert the data into hive table from Java program. Insert query
will work in Hive directly? like below sql command
insert into tablename values(value1,value2)
Thanks
Raj
O as it is a cleaner way in hql perspective.
>> Regards
>> Bejoy K S
>>
>> From handheld, Please excuse typos.
>> --
>> *From: * Bhavesh Shah
>> *Date: *Wed, 15 Feb 2012 15:03:07 +0530
>> *To: *;
>> *ReplyTo: * user@hive.apache.org
>> *Subject: *
t;
> Go with INSERT INTO as it is a cleaner way in hql perspective.
> Regards
> Bejoy K S
>
> From handheld, Please excuse typos.
> --
> *From: * Bhavesh Shah
> *Date: *Wed, 15 Feb 2012 15:03:07 +0530
> *To: *;
> *ReplyTo: * user@hive.ap
ld, Please excuse typos.
-Original Message-
From: Bhavesh Shah
Date: Wed, 15 Feb 2012 15:03:07
To: ;
Reply-To: user@hive.apache.org
Subject: Re: Doubt in INSERT query in Hive?
Hi Bejoy K S,
Thanks for your reply.
The overhead is, in select query I have near about 85 columns. Writing t
--
> *From: * Bhavesh Shah
> *Date: *Wed, 15 Feb 2012 14:33:29 +0530
> *To: *;
> *ReplyTo: * user@hive.apache.org
> *Subject: *Doubt in INSERT query in Hive?
>
> Hello,
> Whenever we want to insert into table we use:
> INSERT OVERWRITE TABLE TBL_NAME
> (SEL
Feb 2012 14:33:29
To: ;
Reply-To: user@hive.apache.org
Subject: Doubt in INSERT query in Hive?
Hello,
Whenever we want to insert into table we use:
INSERT OVERWRITE TABLE TBL_NAME
(SELECT )
Due to this, table gets overwrites everytime.
I don't want to overwrite table, I want appe
Hello,
Whenever we want to insert into table we use:
INSERT OVERWRITE TABLE TBL_NAME
(SELECT )
Due to this, table gets overwrites everytime.
I don't want to overwrite table, I want append it everytime.
I thought about LOAD TABLE , but writing the file may take more time and I
don't think so th
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
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 should I do in such case so that I append the data in table?
--
Thanks and Regards,
Bhavesh
14 matches
Mail list logo