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 Hive 1.1.0 on CDH 5.12 support delete and update?

Solved Go to solution

Does Hive 1.1.0 on CDH 5.12 support delete and update?

Explorer

Does Hive 1.1.0 on CDH 5.12 support delete and update? If not can we apply the backport patches ? Where can one find the required patched for those functionality?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Expert Contributor

What do you mean delete?

If you mean to delete a record, this is only supported if you have Kudu as storage and only through Impala, as (at least as far as I know) Hive cannot operate on kudu tables.

 

 

8 REPLIES 8

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Expert Contributor

What do you mean delete?

If you mean to delete a record, this is only supported if you have Kudu as storage and only through Impala, as (at least as far as I know) Hive cannot operate on kudu tables.

 

 

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Explorer
Thanks for the reply. Yes I meant deleting a record in a table stored as orc or parquet.

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Champion

@praveenms91 @GeKas

 

From Hive 0.14 version it  supports UPDATE and Delete operations 

 

Update statement can only be fired against   table only if  that  supports Transcation ACID  

(Pre-requistes ) 

 

Limitations 

 

Only rows that match the WHERE clause will be updated.
Partitioning columns and Bucketing  cannot be updated.

 

Hive Transcation - Reference 

https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Explorer
Does it support on Cloudera 5.12 which does not have hive 5317.? Could you
please confirm it.

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Champion

You should be runining the below version of HIVE  since you had mentioned cdh 5.12 

hive-1.1.0+cdh5.12.2+1218

yes it should work. 

Highlighted

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Expert Contributor

@csgunaYou are correct, but we are talking about CDH.

I have not tried it, but according to documentation, is not supported even on CDH5.14. It is clearly mentioned in the link below.

https://www.cloudera.com/documentation/enterprise/latest/topics/hive_ingesting_and_querying_data.htm...

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Champion

@GeKas  I had tried delete but the limitation is it only supports on ORC file format . (Cloudera says its not production ready) . But in one of our lower enviroment we are using without any issue until now. 

Should have mentioned about the limitation that comes with. appreciate your pointer :) 

 

 

Re: Does Hive 1.1.0 on CDH 5.12 support delete and update?

Expert Contributor

Just to add on that. I don't believe Cloudera will add this patch. The most probable is to wait for Hive to support Kudu, eg. the https://issues.apache.org/jira/browse/HIVE-12971 was a try, but seems abandoned for long period.