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