Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to update and delete a row in hive


Copy link to this message
-
RE: How to update and delete a row in hive
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:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2012 9:08 AM
To: [EMAIL PROTECTED]
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