Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Abhishek 2012-07-04, 02:19
+
김영우 2012-07-04, 03:56
+
abhiTowson cal 2012-07-04, 04:40
Copy link to this message
-
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.
Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: abhiTowson cal <[EMAIL PROTECTED]>
Date: Wed, 4 Jul 2012 00:40:03
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
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?

Regards
Abhi

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
>
>
+
Mark Grover 2012-07-06, 03:35
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB