hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "nemon lou" <loudongf...@huawei.com>
Subject Review Request 29136: HIVE-7797 upgrade hive schema from 0.9.0 to 0.13.1 failed
Date Wed, 17 Dec 2014 01:50:24 GMT

-----------------------------------------------------------
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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message