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…. Bob Robert Gause Senior Systems Engineer ZyQuest, Inc. bob.ga...@zyquest.com<mailto:bob.ga...@zyquest.com> 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 <bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>> wrote: 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 https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-InsertingdataintoHiveTablesfromqueries Updates are not supported by hive directly. Regards, Bejoy KS ________________________________ From: Sandeep Reddy P <sandeepreddy.3...@gmail.com<mailto:sandeepreddy.3...@gmail.com>> To: u...@hadoop.apache.org<mailto:u...@hadoop.apache.org> Cc: user@hive.apache.org<mailto:user@hive.apache.org>; cdh-u...@cloudera.org<mailto:cdh-u...@cloudera.org> Sent: Thursday, August 9, 2012 7:56 PM Subject: Hive append support Hi, 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? -- Thanks, sandeep -- Thanks, sandeep
