[jira] [Commented] (HIVE-2292) Comment clause should immediately follow identifier field in CREATE DATABASE statement

["Carl Steinbach (JIRA)" <ji...@apache.org>]

    [ 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