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.

​I just want to know why hive supports insert,update,delete in ORC file format only

Solved Go to solution
Highlighted

​I just want to know why hive supports insert,update,delete in ORC file format only

New Contributor

I just want to know why hive supports insert,update,delete in ORC file format only .I am using hive 1.4 version .i want to know how it is accepting ACID properties with ORC file only.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ​I just want to know why hive supports insert,update,delete in ORC file format only

@kishore sanchina

Timing only, no special technical reasons. The feature has been built such that transactions can be used by any storage format that can determine how updates or deletes apply to base records (basically, that has an explicit or implicit row id), but so far the integration work has only been done for ORC.

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

If this is what you were looking for, please vote and accept this as the best answer.

1 REPLY 1

Re: ​I just want to know why hive supports insert,update,delete in ORC file format only

@kishore sanchina

Timing only, no special technical reasons. The feature has been built such that transactions can be used by any storage format that can determine how updates or deletes apply to base records (basically, that has an explicit or implicit row id), but so far the integration work has only been done for ORC.

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

If this is what you were looking for, please vote and accept this as the best answer.

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