Hive does not support row-level (or field-level) updates. It is designed as a WORM (write once read many) data warehouse.
You can of course code your own row updates by reading an entire Hive file, modifying a row, then writing the file back to Hive.
Nuance R&D Data Team
From: Ramasubramanian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2012 9:08 AM
To: [EMAIL PROTECTED]
Subject: How to update and delete a row in hive
What is the command to update/delete a row from hive? If not directly possible what is the work around for that?