Suresh Thalamati created SPARK-21784:
----------------------------------------
Summary: Add ALTER TABLE ADD CONSTRANT DDL to support defining
primary key and foreign keys
Key: SPARK-21784
URL: https://issues.apache.org/jira/browse/SPARK-21784
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Suresh Thalamati
Currently Spark SQL does not have DDL support to define primary key , and
foreign key constraints. This Jira is to add DDL support to define primary key
and foreign key informational constraint using ALTER TABLE syntax. These
constraints will be used in query optimization and you can find more details
about this in the spec in SPARK-19842
*Syntax :*
{code}
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]
{code}
Examples :
{code:sql}
ALTER TABLE employee _ADD CONSTRANT pk_ PRIMARY KEY(empno) VALIDATE RELY
ALTER TABLE department _ADD CONSTRAINT emp_fk_ FOREIGN KEY (mgrno) REFERENCES
employee(empno) NOVALIDATE NORELY
{code}
*Constraint name generated by the system:*
{code:sql}
ALTER TABLE department ADD PRIMARY KEY(deptno) VALIDATE RELY
ALTER TABLE employee ADD FOREIGN KEY (workdept) REFERENCES department(deptno)
VALIDATE RELY;
{code}
--
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
