03-01-2018 02:44 AM
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?
03-01-2018 05:38 AM
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.
03-02-2018 05:45 PM - edited 03-02-2018 05:46 PM
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
Only rows that match the WHERE clause will be updated. Partitioning columns and Bucketing cannot be updated.
Hive Transcation - Reference
03-03-2018 12:28 AM
@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.
03-03-2018 12:37 AM
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.
03-04-2018 09:57 AM
@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 :)