[
https://issues.apache.org/jira/browse/HIVE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13779889#comment-13779889
]
Hive QA commented on HIVE-5374:
-------------------------------
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12605380/HIVE-5374.1.patch
{color:green}SUCCESS:{color} +1 3176 tests passed
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/933/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/933/console
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
> 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
> Priority: Blocker
> Fix For: 0.12.0, 0.13.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
