[HIVE-13290] Support primary keys/foreign keys constraint as part of create table command in Hive

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: CBO, Logical Optimizer
• Labels: TODOC2.1
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Hari Sankar Sivarama Subramaniyan
• Created: 15/Mar/16 18:17
• Updated: 01/Oct/19 22:07
• Resolved: 25/Apr/16 20:59

Description

SUPPORT for the following statements

CREATE TABLE product 
  ( 
     product_id        INTEGER, 
     product_vendor_id INTEGER, 
     PRIMARY KEY (product_id)  DISABLE NOVALIDATE, 
     CONSTRAINT product_fk_1 FOREIGN KEY (product_vendor_id) REFERENCES vendor(vendor_id)  DISABLE NOVALIDATE
  ); 

CREATE TABLE vendor 
  ( 
     vendor_id INTEGER, 
     PRIMARY KEY (vendor_id)  DISABLE NOVALIDATE RELY
  ); 

In the above syntax, [CONSTRAINT constraint-Name] is optional. If this is not specified by the user, we will use system generated constraint name. For the purpose of simplicity, we will allow CONSTRAINT option for foreign keys and not primary key since there is only one primary key per table. The RELY/NORELY keyword is also optional.

Issue Links

• relates to: HIVE-13598 Describe extended table should show the primary keys/foreign keys associated with the table
• relates to: HIVE-13608 We should provide better error message while constraints with duplicate names are created
• links to: Reviewboard