[HIVE-5374] hive-schema-0.13.0.postgres.sql doesn't work

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.12.0, 0.13.0
• Fix Version/s: 0.12.0
• Assignee: Kousuke Saruta
• Reporter: Kousuke Saruta
• Created: 26/Sep/13 21:39
• Updated: 20/Aug/14 07:38
• Resolved: 27/Sep/13 17:57

Description

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.

CREATE TABLE "VERSION" (
  "VER_ID" bigint,
  "SCHEMA_VERSION" character varying(127) NOT NULL,
  "COMMENT" character varying(255) NOT NULL,
  PRIMARY KEY ("VER_ID")
);

INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.13.0', 'Hive release version 0.13.0');

Also, the definition above defines column "COMMENT" but I think it should be named "VERSION_COMMENT".

Issue Links

• relates to: HIVE-7797 upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres