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

rahul_gaikwad — Fri, 16 Sep 2022 14:14:06 GMT

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?

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

saini saab — Mon, 18 Mar 2019 05:09:27 GMT

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

question Re: Does Cloudera Hive supports Insert,Update,Delete,Joins on Table for Batch Analytics processing? in Support Questions

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

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