[ https://issues.apache.org/jira/browse/HIVE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13779758#comment-13779758 ]
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/930/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/930/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