Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

New Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Cloudera Employee

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

1 REPLY 1

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

Cloudera Employee

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

Don't have an account?
Coming from Hortonworks? Activate your account here