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. Chuck Connell Nuance R&D Data Team Burlington, MA -----Original Message----- From: Ramasubramanian [mailto:ramasubramanian.naraya...@gmail.com] Sent: Tuesday, September 11, 2012 9:08 AM To: user@hive.apache.org Subject: How to update and delete a row in hive Hi, What is the command to update/delete a row from hive? If not directly possible what is the work around for that? Regards, Rams