You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by nemon lou <lo...@huawei.com> on 2014/12/17 02:50:24 UTC
Review Request 29136: HIVE-7797 upgrade hive schema from 0.9.0 to
0.13.1 failed
-----------------------------------------------------------
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