HI, Can we consider using HBASE for the same? On Thu, Aug 9, 2012 at 1:19 PM, Sandeep Reddy P <[email protected] > wrote:
> 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 > > -- Thanks, sandeep
