hive-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/HIVE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13780468#comment-13780468
] 

Hudson commented on HIVE-5374:
------------------------------

FAILURE: Integrated in Hive-trunk-h0.21 #2363 (See [https://builds.apache.org/job/Hive-trunk-h0.21/2363/])
HIVE-5374 : hive-schema-0.13.0.postgres.sql doesn't work (Kousuke Saruta via Ashutosh Chauhan)
(hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1527007)
* /hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
* /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
* /hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
* /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
* /hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql

                
> 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.12.0, 0.13.0
>            Reporter: Kousuke Saruta
>            Assignee: Kousuke Saruta
>            Priority: Blocker
>             Fix For: 0.12.0
>
>         Attachments: HIVE-5374.1.patch, HIVE-5374.patch.1, HIVE-5374.patch.2
>
>
> hive-schema-0.13.0.postgres.sql doesn't work. In PostgreSQL, if we double quote keyword
(colmn name, table name etc ), those names are 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