Details
-
Bug
-
Status: Patch Available
-
Major
-
Resolution: Unresolved
-
0.13.1, 0.14.0
-
None
-
None
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).
Attachments
Attachments
Issue Links
- is related to
-
HIVE-5374 hive-schema-0.13.0.postgres.sql doesn't work
- Closed