You can't delete individual rows from Hive over HDFS. You can delete
full partitions.
If you want to delete individual rows then a work around would be to
create a new table with the rows deleted, swap table names, then delete
old table.
Or, use Hive over HBase, which allows for deleting rows (also
updates/inserts), see:
http://bit.ly/9W1zV3
-- amr
On 6/14/2010 1:27 AM, jaydeep vishwakarma wrote:
Hi,
How to delete specific rows from hive tables?
Regards,
Jaydeep
The information contained in this communication is intended solely for
the use of the individual or entity to whom it is addressed and others
authorized to receive it. It may contain confidential or legally
privileged information. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution or taking
any action in reliance on the contents of this information is strictly
prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by responding to
this email and then delete it from your system. The firm is neither
liable for the proper and complete transmission of the information
contained in this communication nor for any delay in its receipt.
