-Re: Hive insert into
Bejoy KS 2012-07-04, 05:35
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.
Sent from handheld, please excuse typos.
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
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:
> Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See
> - 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?
>> Sent from my iPhone