-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/29136/
-----------------------------------------------------------
Review request for hive, Ashutosh Chauhan and Prasad Mujumdar.
Repository: hive
Description
-------
Using hive schema tool with the following command to upgrade hive schema failed:
schematool -dbType postgres -upgradeSchemaFrom 0.9.0
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).
Diffs
-----
trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql 1645877
Diff: https://reviews.apache.org/r/29136/diff/
Testing
-------
The modified upgrade sql file has been tested manually.
Thanks,
nemon lou
