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/26 07:39:25 UTC
[jira] [Updated] (SPARK-14177) Parse DDL command: "DESCRIBE
DATABASE" and "ALTER DATABASE SET DBPROPERTIES"
[ https://issues.apache.org/jira/browse/SPARK-14177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-14177:
----------------------------
Description:
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
was:
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
> 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