Xiao Li created SPARK-14177:
-------------------------------

             Summary: Parse DDL command: "DESCRIBE DATABASE" and "ALTER 
DATABASE SET DBPROPERTIES"
                 Key: SPARK-14177
                 URL: https://issues.apache.org/jira/browse/SPARK-14177
             Project: Spark
          Issue Type: Improvement
          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

The syntax of DDL command for ALTER DATABASE is
{code}
ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES 
(property_name=property_value, ...)
{code}
{{ALTER DATABASE}} is to add new (key, value) pairs into DBPROPERTIES

The syntax of DDL command for DESCRIBE DATABASE is
{code}
DESCRIBE DATABASE [EXTENDED] db_name
{code}
{{DESCRIBE DATABASE}} shows the name of the database, its comment (if one has 
been set), and its root location on the filesystem. When extended is true, it 
also shows the database's properties





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

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

Reply via email to