Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Does Hive 1.1.0 on CDH 5.12 support delete and update?

avatar
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

avatar
Super Collaborator

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.

 

 

View solution in original post

8 REPLIES 8

avatar
Super Collaborator

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.

 

 

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

avatar
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

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

avatar
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. 

avatar
Super Collaborator

@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...

avatar
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 🙂 

 

 

avatar
Super Collaborator

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.