Xiao Li created SPARK-14182:
-------------------------------

             Summary: Parse DDL command: Alter View
                 Key: SPARK-14182
                 URL: https://issues.apache.org/jira/browse/SPARK-14182
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.0.0
            Reporter: Xiao Li


Based on the Hive DDL document 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
and 
https://cwiki.apache.org/confluence/display/Hive/PartitionedViews

The syntax of DDL command for {{ALTER VIEW}} include
{code}
ALTER VIEW view_name AS select_statement
ALTER VIEW view_name RENAME TO new_view_name
ALTER VIEW view_name SET TBLPROPERTIES ('comment' = new_comment);
ALTER VIEW view_name UNSET TBLPROPERTIES [IF EXISTS] ('comment', 'key')
ALTER VIEW view_name ADD [IF NOT EXISTS] PARTITION spec1[, PARTITION spec2, ...]
ALTER VIEW view_name DROP [IF EXISTS] PARTITION spec1[, PARTITION spec2, ...]
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to