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-13350) Support Alter commands for Rely/NoRely novalidate for PK/FK constraints
Date Tue, 10 May 2016 22:49:13 GMT

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

Hari Sankar Sivarama Subramaniyan updated HIVE-13350:
-----------------------------------------------------
    Description: 
Support commands like :
ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate;
ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY ( x ) REFERENCES table2(a)  DISABLE NOVALIDATE
RELY;
ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY ( y ) REFERENCES table1(a)  DISABLE NOVALIDATE;

  was:
Support commands like :
ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate;
ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a)  DISABLE NOVALIDATE
RELY;
ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a)  DISABLE NOVALIDATE;


> Support Alter commands for Rely/NoRely  novalidate for PK/FK constraints
> ------------------------------------------------------------------------
>
>                 Key: HIVE-13350
>                 URL: https://issues.apache.org/jira/browse/HIVE-13350
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO, Logical Optimizer
>            Reporter: Hari Sankar Sivarama Subramaniyan
>            Assignee: Hari Sankar Sivarama Subramaniyan
>
> Support commands like :
> ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate;
> ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY ( x ) REFERENCES table2(a)  DISABLE
NOVALIDATE RELY;
> ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY ( y ) REFERENCES table1(a)  DISABLE
NOVALIDATE;



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

Mime
View raw message