Thank you all for the info. On Thu, Aug 9, 2012 at 12:30 PM, Bob Gause <[email protected]> wrote:
> 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. > [email protected] > > 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 <[email protected]> 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 <[email protected]> >> *To:* [email protected] >> *Cc:* [email protected]; [email protected] >> *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 > > > -- Thanks, sandeep
