If key is unique, you might overwrite values by using hbase handler.
2014-02-18 22:05 GMT+09:00 yogesh dhari <yogeshh...@gmail.com>: > Yes, Hive does not provide update statement, I am just looking for the > work arround it, how to implement it > > > > > > On Tue, Feb 18, 2014 at 6:27 PM, Peter Marron < > peter.mar...@trilliumsoftware.com> wrote: > >> From https://cwiki.apache.org/confluence/display/Hive/Home >> >> >> >> "Hive is not designed for OLTP workloads and does not offer real-time >> queries or row-level updates." >> >> >> >> As far as I am aware "UPDATE" isn't even in the Hive DML. >> >> >> >> Z >> >> *Peter Marron* >> Senior Developer >> Trillium Software, A Harte Hanks Company >> >> Theale Court, 1st Floor, 11-13 High Street >> Theale >> RG7 5AH >> >> +44 (0) 118 940 7609 office >> +44 (0) 118 940 7699 fax >> >> [image: >> https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/trillium.png]<http://www.trilliumsoftware.com/> >> >> trilliumsoftware.com <http://www.trilliumsoftware.com/> / >> linkedin<http://www.linkedin.com/company/17710> >> / twitter <https://twitter.com/trilliumsw> / >> facebook<http://www.facebook.com/HarteHanks> >> >> >> >> *From:* yogesh dhari [mailto:yogeshh...@gmail.com] >> *Sent:* 18 February 2014 12:39 >> *To:* user@hive.apache.org >> *Subject:* Hive Query :: Implementing case statement >> >> >> >> Hello All, >> >> >> >> I have a use case where a table say TABLE_SQL is geting updated like. >> >> >> >> >> >> 1st Update Command >> >> >> >> update TABLE_SQL a >> >> set BALANCE = b.prev >> >> from TABLE_SQL_2 b >> >> where a.key = b.key and a.code = "1" >> >> >> >> >> >> 2nd Update Command >> >> >> >> update TABLE_SQL a >> >> set BALANCE = b.prev >> >> from TABLE_SQL_3 b >> >> where a.key = b.key and a.code = "2" >> >> >> >> >> >> same column is getting update twice in sql table, >> >> >> >> I have a Table in Hive say TABLE_HIVE. >> >> >> >> How to perform this kind operatation in HIVE, >> >> >> >> Pls Help, >> >> >> >> Thanks in Advance >> >> Yogesh Kumar >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >
<<inline: image001.png>>
