Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB