Support Questions

Find answers, ask questions, and share your expertise

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

avatar

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

avatar
Super Guru

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

View solution in original post

1 REPLY 1

avatar
Super Guru

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