Details
-
Bug
-
Status: Closed
-
Blocker
-
Resolution: Fixed
-
0.12.0, 0.13.0
-
None
-
None
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".
Attachments
Attachments
Issue Links
- relates to
-
HIVE-7797 upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres
- Patch Available