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.

Why Hive supports ACID properties in ORC File Format only(before 0.14 version) ?

Solved Go to solution

Why Hive supports ACID properties in ORC File Format only(before 0.14 version) ?

New Contributor

Hi,

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Why Hive supports ACID properties in ORC File Format only(before 0.14 version) ?

Rising Star
@AnjiReddy Anumolu

Hive transactions are supported starting hive 0.13. However, the integration was completely done for ORC file format for the first release. Look below from the wiki:

Only ORC file format is supported in this first release.  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.

Source:

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

2 REPLIES 2
Highlighted

Re: Why Hive supports ACID properties in ORC File Format only(before 0.14 version) ?

Rising Star
@AnjiReddy Anumolu

Hive transactions are supported starting hive 0.13. However, the integration was completely done for ORC file format for the first release. Look below from the wiki:

Only ORC file format is supported in this first release.  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.

Source:

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

Re: Why Hive supports ACID properties in ORC File Format only(before 0.14 version) ?

@Hari Rongali

This is a current limitation with ACID transactions supported only in ORC format.

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