You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Alan Gates (JIRA)" <ji...@apache.org> on 2016/03/11 17:33:07 UTC

[jira] [Resolved] (HIVE-13266) HIVE ACIDINPUTFORMAT WITH PRIMARY KEY

     [ https://issues.apache.org/jira/browse/HIVE-13266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alan Gates resolved HIVE-13266.
-------------------------------
    Resolution: Invalid

JIRA is intended for reporting bugs or recording tasks that developers are working on.  Questions should be asked on the user or dev list.  This one looks like it belongs on the user list.

Currently Hive doesn't support the concept of a primary key.  ORC actually has a primary key when being used with ACID, but it isn't exposed out to the user.  There's some work to do to make that happen and allow the user to choose which column(s) form the primary key.  If we did this it would not include the constraint that guarantees there's no duplicates with this key, since enforcing that would be very expensive without an in memory index to check all new records against.

> HIVE ACIDINPUTFORMAT WITH PRIMARY KEY
> -------------------------------------
>
>                 Key: HIVE-13266
>                 URL: https://issues.apache.org/jira/browse/HIVE-13266
>             Project: Hive
>          Issue Type: Task
>          Components: Hive
>            Reporter: Marco barbieri
>
> HI,
> I want to know if there is a way to use primary key with acidInputFormat as Parquet or ORC (HIVE).
> Thank you.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)