spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiao Li (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SPARK-14177) Parse DDL command: "DESCRIBE DATABASE" and "ALTER DATABASE SET DBPROPERTIES"
Date Sat, 26 Mar 2016 06:38:25 GMT
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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message