You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2016/03/27 09:29:25 UTC

[jira] [Created] (SPARK-14182) Parse DDL command: Alter View

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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org