Hi all,
We recently bump up the CDP GBN in this commit:
bd88b71ed IMPALA-11524: Bump up the CDP GBN to 33375775 and remove
workarounds
You might see HMS fails to start after rebasing your local branch on this.
The error is something like
org.postgresql.util.PSQLException: ERROR: column "DATACONNECTOR_NAME" of
relation "DBS" does not exist
org.postgresql.util.PSQLException: ERROR: column "TYPE" does not exist
There are upgrade scripts
in
toolchain/cdp_components-33375775/apache-hive-3.1.3000.7.2.16.0-233-bin/scripts/metastore/upgrade/postgres/
that can fix the schema. The following commands fix my issue:
source bin/impala-config.sh
cat
toolchain/cdp_components-33375775/apache-hive-3.1.3000.7.2.16.0-233-bin/scripts/metastore/upgrade/postgres/upgrade-3.1.3000.7.2.15.0-Update6-to-3.1.3000.7.2.16.0-Update1.postgres.sql
| psql -q -U hiveuser -d ${METASTORE_DB}
cat
toolchain/cdp_components-33375775/apache-hive-3.1.3000.7.2.16.0-233-bin/scripts/metastore/upgrade/postgres/upgrade-3.1.3000.7.2.16.0-Update1-to-3.1.3000.7.2.16.0-Update2.postgres.sql
| psql -q -U hiveuser -d ${METASTORE_DB}
bin/create-test-configuration.sh
If there are still schema issues of missing some columns, you probably need
other upgrade scripts in the same folder.
Regards,
Quanlong
