My Oracle Support Banner

Step 5,Installing Hadoop Parcel and Upgrading CDH Cluster, of BDA Upgrade to 5.2/5.1 from BDA 4.x Fails Upgrading CDH in Cloudera Manager With NoSuchMethodError:HsqlProperties on the Hive Metastore Upgrade (Doc ID 2816631.1)

Last updated on OCTOBER 24, 2021

Applies to:

Big Data Appliance Integrated Software - Version 5.2.0 and later
Linux x86-64

Symptoms

Step 5, Installing Hadoop Parcel and Upgrading CDH Cluster, of BDA upgrade to 5.2/5.1 from BDA 4.x fails upgrading CDH in Cloudera Manager with NoSuchMethodError:HsqlProperties on the Hive Metastore upgrade.

1. Cloudera Manager reports in stderr:

Failed to Upgrade Hive Metastore Database Schema
$> hive/hive.sh ["upgrade_metastore"]
ERROR org.apche.hadoop.hive.common.FileUtils - The jar path file:///opt/oracle/bigdatasql/bdcell-12.1/jib/ojdbc7.jar doesn't exist
ERROR org.apche.hadoop.hive.common.FileUtils - The jar path file:///opt/oracle/bigdatasql/bdcell-12.1/jib/orai18n.jar doesn't exist
ERROR org.apche.hadoop.hive.common.FileUtils - The jar path file:///opt/oracle/bigdatasql/bdcell-12.1/jib/oraloader.jar doesn't exist
ERROR org.apche.hadoop.hive.common.FileUtils - The jar path file:///opt/oracle/bigdatasql/bdcell-12.1/jib/orahivedp.jar doesn't exist
WARN org.apache.hadoop.hive.conf.HiveConf - HiveConf of name hive.sentry.conf.url does not exist
Exception in thread "main" java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String:ZZ)/Lorg/hsqldb/persist/HsqlProperties:
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)

2. On the Hive Metastore (HMS) host /etc/hive/conf/hive-site.xml contains the list of files above, ojdbc7.jar, orai18n.jar, oraloader.jar, orahivedp.jar.

3. It is also the case, that on the HMS host the two files below exist:

  1. /opt/cloudera/parcels/CDH-<version>.cdh<verion>/jars/hsqldb-1.8.0.10.jar
  2. /opt/cloudera/parcels/CDH-<version>.cdh<verion>/jars/hsqldb-2.4.0.jar

For example on upgrade to BDA 5.2/CDH 6.3.4 the two files below exist:

  1. /opt/cloudera/parcels/CDH-6.3.4-1.cdh6.3.4.p4368.7037554/jars/hsqldb-1.8.0.10.jar
  2. /opt/cloudera/parcels/CDH-6.3.4-1.cdh6.3.4.p4368.7037554/jars/hsqldb-2.4.0.jar

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.