[HIVE-6905] Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Component/s: Database/Schema
• Assignee: Unassigned
• Reporter: Pardeep Kumar
• Created: 14/Apr/14 19:18
• Updated: 16/Feb/18 00:19

Description

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 step for Hive enhancement to take it closer to a very wide mainstream adoption..

Issue Links

• relates to: HIVE-13061 Advance Hybrid Cloud Architecture (AHA) - Advance Hive (Umbrella) JIRA -- Enhanced Updates & others
• relates to: HIVE-5317 Implement insert, update, and delete in Hive with full ACID support
• relates to: HIVE-16575 Support for 'UNIQUE' and 'NOT NULL' constraints
• relates to: HIVE-16605 Enforce NOT NULL constraints
• relates to: HIVE-18726 Implement DEFAULT constraint
• relates to: HIVE-13076 Implement FK/PK "rely novalidate" constraints for better CBO