[
https://issues.apache.org/jira/browse/HIVE-2292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13068052#comment-13068052
]
Carl Steinbach commented on HIVE-2292:
--------------------------------------
HIVE-1537 added an optional LOCATION clause to the CREATE DATABASE statement,
but the ordering of the COMMENT and LOCATION clauses is not consistent with the
CREATE TABLE and CREATE VIEW statements:
{code}
CREATE DATABASE [IF NOT EXISTS] db_name
[LOCATION hdfs_path]
[COMMENT comment]
...
CREATE TABLE [IF NOT EXISTS] tb_name
[COMMENT comment]
...
[LOCATION hdfs_path]
CREATE VIEW [IF NOT EXISTS] vw_name
[COMMENT]
...
{code}
The syntax of the CREATE DATABASE statement should be modified so that the
COMMENT clause immediately follows the db_name field.
> Comment clause should immediately follow identifier field in CREATE DATABASE
> statement
> --------------------------------------------------------------------------------------
>
> Key: HIVE-2292
> URL: https://issues.apache.org/jira/browse/HIVE-2292
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Reporter: Carl Steinbach
> Fix For: 0.8.0
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
