Update and Delete are not working in Hive ? [ Edited ]

[csguna]

@AlexMulti

Deletes can only be performed on tables that support ACID. More over your tables's file format should be ORC

Below are the properties that needs to be set .

hive.support.concurrency	true (default is false)
hive.enforce.bucketing	true (default is false) (Not required as of Hive 2.0)
hive.exec.dynamic.partition.mode	nonstrict (default is strict)

Also i would suggest you to take look into  kudu. 

Reference https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-NewConfiguration...

[AlexMulti]

@csgunaThank you for the reply!

I am using Parquet and you are right, it is not supported for UPDATE and DELETE operations. Only ORC is supported.

@syamsriI suggest the last post from csguna should be marked as the correct answer.

[UjjwalRana]

Oh ok syam i got. I did the installation part manually.

[David M.]

The CDH distribution of Hive does not support transactions (HIVE-5317). Currently, transaction support in Hive is an experimental feature that only works with the ORC file format. Cloudera recommends using the Parquet file format, which works across many tools. Merge updates in Hive tables using existing functionality, including statements such as INSERT, INSERT OVERWRITE, and CREATE TABLE AS SELECT.

https://www.cloudera.com/documentation/enterprise/latest/topics/hive_ingesting_and_querying_data.htm...

If you require these features, please inquire about Apache Kudu.

Kudu is storage for fast analytics on fast data—providing a combination of fast inserts and updates alongside efficient columnar scans to enable multiple real-time analytic workloads across a single storage layer.

https://www.cloudera.com/products/open-source/apache-hadoop/apache-kudu.html

[Jagadesh]

Please check the link https://hortonworks.com/blog/update-hive-tables-easy-way/ hope this helps.