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

1 reply
2461 views
Translate All

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?

Apache Hive

saini saabAnswer

Gold ⭐️

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.html#hive_transaction_support
[2] https://www.cloudera.com/documentation/enterprise/5-14-x/topics/kudu_impala.html

Thanks

Manpreet Singh