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>>
