[
https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13970544#comment-13970544
]
Damien Carol commented on HIVE-6905:
------------------------------------
[~codebunker] sequence table already exists in current metastore implementation
(Since at least version 0.11)
|| Column || Type || NULL ? ||
| SEQUENCE_NAME | character varying(255) | NOT NULL |
| NEXT_VAL | bigint | NOT NULL |
I propose to add this columns :
|| Column || Type || NULL ? ||
| INCREMENT | bigint | NOT NULL |
| MINVALUE | bigint | NOT NULL |
| MAXVALUE | bigint | NOT NULL |
| START | bigint | NOT NULL |
| CACHE | bigint | NOT NULL |
Anyway we NEED a design document to describe all details of sequence
implementation.
> Implement Auto increment, primary-foreign Key, not null constraints and
> default value in Hive Table columns
> ------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-6905
> URL: https://issues.apache.org/jira/browse/HIVE-6905
> Project: Hive
> Issue Type: New Feature
> Components: Database/Schema
> Affects Versions: 0.14.0
> Reporter: Pardeep Kumar
>
> For Hive to replace a modern datawarehouse based on RDBMS, it must have
> support for keys, constraints, auto-increment values, surrogate keys and not
> null features etc. Many customers do not move their EDW to Hive due to these
> reasons as these have been challenging to maintain in Hive.
> This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317
> for Updates, Deletes and Inserts are done in Hive. This should be next stop
> for Hive enhancement to take it closer to a very wide mainstream adoption..
--
This message was sent by Atlassian JIRA
(v6.2#6252)
