hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sankar Sivarama Subramaniyan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13290) Support primary keys/foreign keys constraint as part of create table command in Hive
Date Wed, 20 Apr 2016 00:20:25 GMT

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

Hari Sankar Sivarama Subramaniyan updated HIVE-13290:
-----------------------------------------------------
    Attachment: HIVE-13290.6.patch

cc-ing [~ashutoshc] for review. Will add unit tests soon.

> Support primary keys/foreign keys constraint as part of create table command in Hive
> ------------------------------------------------------------------------------------
>
>                 Key: HIVE-13290
>                 URL: https://issues.apache.org/jira/browse/HIVE-13290
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO, Logical Optimizer
>            Reporter: Hari Sankar Sivarama Subramaniyan
>            Assignee: Hari Sankar Sivarama Subramaniyan
>         Attachments: HIVE-13290.1.patch, HIVE-13290.2.patch, HIVE-13290.3.patch, HIVE-13290.4.patch,
HIVE-13290.5.patch, HIVE-13290.6.patch
>
>
> SUPPORT for the following statements
> {code}
> CREATE TABLE product 
>   ( 
>      product_id        INTEGER, 
>      product_vendor_id INTEGER, 
>      PRIMARY KEY (product_id), 
>      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
>   ); 
> {code}
> 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.



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

Mime
View raw message