Does Cloudera Hive supports Insert,Update,Delete,Joins on Table for Batch Analytics processing?

[#1]

Does Cloudera Hive supports for Insert ,Update and Delete on Table?
Which is best option for Analytics Batch processing which supports UPDATES and JOINS on tables?

[#2 · Accepted solution]

Hello Rahul

Our Hive documentation [1] states currently "Hive in CDH does not support transactions (HIVE-5317)", so you can't use the Insert ,Update and Delete statements in Hive.

Based on the requirements you may want to consider using Kudu storage through Impala [2]

Please let me know if you have any more questions or concerns.

[1] https://www.cloudera.com/documentation/enterprise/5-14-x/topics/hive_ingesting_and_querying_data.htm...
[2] https://www.cloudera.com/documentation/enterprise/5-14-x/topics/kudu_impala.html

Thanks

Manpreet Singh