Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive insert into

Copy link to this message
Re: Hive insert into
Bejoy is right. To add to the remark, "insert into" doesn't work on bucketed tables as of now. For non-bucketed tables, it should work if you are using Hive version 0.8 or higher.

More details on this thread:
http://mail-archives.apache.org/mod_mbox/hive-user/201206.mbox/%[EMAIL PROTECTED]%3E

If your create table statement contained "CLUSTERED BY" clause, then your table is bucketed; otherwise it's not.


----- Original Message -----
From: "Bejoy KS" <[EMAIL PROTECTED]>
Sent: Wednesday, July 4, 2012 1:35:48 AM
Subject: Re: Hive insert into

Hi Abhi

When you say INSERT INTO in hive it needn't be a file append. In hive the data corresponding to a table/partition is in a directory, data is stored as one or more files within those.

AFAIK when you do insert into, a new file is created in the directory along with old files. So hdfs file append needn't come to picture here.
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: abhiTowson cal <[EMAIL PROTECTED]>
Date: Wed, 4 Jul 2012 00:40:03
Subject: Re: Hive insert into

hi youngwoo

Thanks for your reply.Can you justify your answer hdfs doesnot support
append, so how hive does it?


On Tue, Jul 3, 2012 at 11:56 PM, 김영우 <[EMAIL PROTECTED]> wrote:
> Abhi,
> Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries
> - Youngwoo
> On Wed, Jul 4, 2012 at 11:19 AM, Abhishek <[EMAIL PROTECTED]> wrote:
>> Hi all,
>> Will hive support INSERT INTO ? and It is nothing but, appending new data
>> to the existing data.Can any one please tell me how does it happen and which
>> version of hive supports this?
>> Regards
>> Abhi
>> Sent from my iPhone