[
https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13968986#comment-13968986
]
Damien Carol commented on HIVE-6905:
------------------------------------
The sequence based approach to generate auto increment IDs is a must have
feature (part of [SQL:2003|http://www.wiscorp.com/SQL2003Features.pdf]).
{code}
CREATE SEQUENCE <sequence name> [AS <data type>]
[START WITH <num>] [INCREMENT BY <num>]
[MINVALUE <num>] [MAXVALUE <num>]
[CYCLE | NO CYCLE]
{code}
> 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
> 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)
