[
https://issues.apache.org/jira/browse/HIVE-13350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15337581#comment-15337581
]
Lefty Leverenz commented on HIVE-13350:
---------------------------------------
Doc note: See the PDF doc attached to HIVE-13076.
*
https://issues.apache.org/jira/secure/attachment/12803522/AddingPKFKconstraints.pdf
> 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
> Labels: TODOC2.1
> Fix For: 2.1.0
>
> Attachments: HIVE-13350.1.patch, HIVE-13350.2.patch,
> HIVE-13350.final.patch
>
>
> 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)
