[HIVE-7797] upgrade hive schema from 0.9.0 to 0.13.1 failed when back end db is postgres

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.13.1, 0.14.0
• Component/s: Metastore
• Assignee: Nemon Lou
• Reporter: Nemon Lou
• Created: 20/Aug/14 07:37
• Updated: 16/Apr/15 21:34

Description

Using the following command to upgrade hive schema :
schematool -dbType postgres -upgradeSchemaFrom 0.9.0

then got this:
ERROR: null value in column "SCHEMA_VERSION" violates not-null constraint

Log shows that the upgrade sql file 014-HIVE-3764.postgres.sql failed.
The sql in it is :
INSERT INTO "VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '', 'Initial value');
And the result is:
ERROR: null value in column "SCHEMA_VERSION" violates not-null constraint
DETAIL: Failing row contains (1, null, Initial value).

Issue Links

• is related to: HIVE-5374 hive-schema-0.13.0.postgres.sql doesn't work