12-07-2017 09:33 PM - edited 12-07-2017 09:37 PM
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.
12-08-2017 07:52 AM
01-09-2018 09:29 AM
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.
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.