Sunitha Kambhampati created SPARK-22064:
-------------------------------------------
Summary: Add support for VALIDATE option to ALTER TABLE ADD
CONSTRAINT command
Key: SPARK-22064
URL: https://issues.apache.org/jira/browse/SPARK-22064
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Sunitha Kambhampati
As part of the Informational Referential Integrity constraints feature, in
SPARK-21784, the ALTER TABLE ADD CONSTRAINT DDL is added.
{quote}ALTER TABLE [db_name.]table_name ADD [CONSTRAINT constraintName]
(PRIMARY KEY (col_names) |
FOREIGN KEY (col_names) REFERENCES [db_name.]table_name [(col_names)])
[VALIDATE | NOVALIDATE] [RELY | NORELY]
{quote}
In this JIRA, we will add support to add a constraint with the VALIDATE option
and perform the validation for the constraint. We will validate the constraint
by running specific internal SQL statements to check if the data conforms to
the constraint.
E.g {quote}ALTER TABLE employee ADD CONSTRAINT pk1 PRIMARY KEY (empno)
VALIDATE RELY{quote}
The high level details are in the [^InformationalRIConstraints.doc] in Section
4.2.3 and Section 4.5
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
