[jira] [Created] (SPARK-21824) DROP TABLE should automatically drop any dependent referential constraints or raise error.

["Suresh Thalamati (JIRA)" <ji...@apache.org>]

Suresh Thalamati created SPARK-21824:
----------------------------------------

             Summary: DROP TABLE should  automatically  drop any dependent referential constraints or raise error.
                 Key: SPARK-21824
                 URL: https://issues.apache.org/jira/browse/SPARK-21824
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Suresh Thalamati


DROP TABLE should  raise error if there are any  dependent referential constraints  unless user specifies CASCADE CONSTRAINTS

Syntax :
{code:sql}
DROP TABLE <name> [CASCADE CONSTRAINTS]
{code}

Hive drops the referential constraints automatically. Oracle requires user specify _CASCADE CONSTRAINTS_ clause to automatically drop the referential constraints, otherwise raises the error. Should we stick to the *Hive behavior* ?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org