hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kousuke Saruta (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5374) hive-schema-0.13.0.postgres.sql doesn't work
Date Thu, 26 Sep 2013 21:42:05 GMT

     [ https://issues.apache.org/jira/browse/HIVE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kousuke Saruta updated HIVE-5374:
---------------------------------

    Attachment: HIVE-5374.patch.1

I've attached a patch for this issue.
                
> hive-schema-0.13.0.postgres.sql doesn't work
> --------------------------------------------
>
>                 Key: HIVE-5374
>                 URL: https://issues.apache.org/jira/browse/HIVE-5374
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.0
>            Reporter: Kousuke Saruta
>             Fix For: 0.13.0
>
>         Attachments: HIVE-5374.patch.1
>
>
> hive-schema-0.13.0.postgres.sql doesn't work. In PostgreSQL, if we double quote keyword
(colmn name, table name etc ), those name is treated case sensitively. But in the script,
there is a non double quoted table name and column anme although those are double quoted at
the definition.
> {code}
> CREATE TABLE "VERSION" (
>   "VER_ID" bigint,
>   "SCHEMA_VERSION" character varying(127) NOT NULL,
>   "COMMENT" character varying(255) NOT NULL,
>   PRIMARY KEY ("VER_ID")
> );
> {code}
> {code}
> INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.13.0', 'Hive
release version 0.13.0');
> {code}
> Also, the definition above defines column "COMMENT" but I think it should be named "VERSION_COMMENT".

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message