hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Gause <>
Subject Re: Hive append support
Date Thu, 09 Aug 2012 16:30:43 GMT
Hive has no update & delete statements.

You can drop a table, and that is as closes to a delete as you get.

The only "update" you get is to append more data to a table. There is INSERT OVERWRITE &
INSERT. The first will create the first set of rows in the table, the second will append more
data to the table.

Coming from another database, you will have to modify your way of thinking and doing things.
You will have to stretch some of your operations out into intermediate temp tables. We have
a lot more tables in our Hive process than we had in our MySQL/Postgres process.

Hope this helps….

Robert Gause
Senior Systems Engineer
ZyQuest, Inc.<>

On Aug 9, 2012, at 10:49 AM, Sandeep Reddy P wrote:

Hi Bejoy,
Thanks for the link. When you say updates are not supported directly is there any other way
we can update data in HDFS/Hive?

On Thu, Aug 9, 2012 at 10:30 AM, Bejoy Ks <<>>
Hi Sandeep

If you are looking at inserting more data into existing tables that has data, the yes it is
supported in hive from 0.8 (i guess). You can see the INSERT INTO documentation here

Updates are not supported by hive directly.

Bejoy KS

From: Sandeep Reddy P <<>>
Sent: Thursday, August 9, 2012 7:56 PM
Subject: Hive append support

Is there any version of Hive for append operations (Insert or Update) via HiveQL? If so please
point me at any HiveQL documentation that explains how the append operations work?



View raw message