[ 
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)

Reply via email to