Manually upgrade:
|
1 2 3 4 5 6 7 8 9 10 |
[root@hadoop4 postgres]# /opt/cloudera/parcels/CDH/lib/hive/bin/schematool -dbType derby -upgradeSchemaFrom 0.11.0 14/02/07 14:41:33 INFO Configuration.deprecation: hive.server2.enable.impersonation is deprecated. Instead, use hive.server2.enable.doAs 14/02/07 14:41:33 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore. Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting upgrade metastore schema from version 0.11.0 to 0.11.0-c5b1 Upgrade script upgrade-0.11.0-to-0.11.0-c5b1.derby.sql Completed upgrade-0.11.0-to-0.11.0-c5b1.derby.sql schemaTool completeted |
Hive MetaStore Schema Upgrade Failed When Upgrading CDH5 by @sskaje: https://sskaje.me/2014/02/hive-metastore-schema-upgrade-failed-upgrading-cdh5/