Reply
Highlighted
Explorer
Posts: 7
Registered: ‎09-12-2017
Accepted Solution

Does Hive 1.1.0 on CDH 5.12 support delete and update?

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?

Expert Contributor
Posts: 127
Registered: ‎01-08-2018

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

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.

 

 

Explorer
Posts: 7
Registered: ‎09-12-2017

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

Thanks for the reply. Yes I meant deleting a record in a table stored as orc or parquet.
Champion
Posts: 735
Registered: ‎05-16-2016

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

[ Edited ]

@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

Explorer
Posts: 7
Registered: ‎09-12-2017

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

Does it support on Cloudera 5.12 which does not have hive 5317.? Could you
please confirm it.
Champion
Posts: 735
Registered: ‎05-16-2016

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

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. 

Expert Contributor
Posts: 127
Registered: ‎01-08-2018

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

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

Expert Contributor
Posts: 127
Registered: ‎01-08-2018

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

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.

Champion
Posts: 735
Registered: ‎05-16-2016

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

@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 :) 

 

 

Announcements