My Oracle Support Banner

During Mammoth Cluster Validation Checks, HCatalog Test Fails to Drop the Database (Doc ID 1940902.1)

Last updated on NOVEMBER 08, 2022

Applies to:

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

Symptoms

During Cluster validation checks using 'mammoth -c' or while upgrading or installing a patch on Oracle Big Data Appliance (BDA), HCatalog test fails with below error while deleting the test database. The test database is created in /user/hive/warehouse directory as part of tests performed during cluster validation.
 

{"errorDetail":"org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Database not dropped since hdfs://<ClusterName>-ns/user/hive is not writable by oracle)
at org.apache.hadoop.hive.ql.metadata.Hive.dropDatabase(Hive.java:289) org.apache.hadoop.hive.ql.exec.DDLTask.dropDatabase(DDLTask.java:3451)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:232) org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
...........
at org.apache.hive.hcatalog.cli.HCatCli.main(HCatCli.java:164) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) org.apache.hadoop.util.RunJar.main(RunJar.java:212)
Caused by: MetaException(message:Database not dropped since hdfs://<ClusterName>-ns/user/hive is not writable by oracle)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result$drop_database_resultStandardScheme.read(ThriftHiveMetastore.java:11232)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result$drop_database_resultStandardScheme.read(ThriftHiveMetastore.java:11200)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result.read(ThriftHiveMetastore.java:11134)
...............
at com.sun.proxy.$Proxy7.dropDatabase(Unknown Source)
at org.apache.hadoop.hive.ql.metadata.Hive.dropDatabase(Hive.java:285)
... 18 more",
"error":"FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
(message:Database not dropped since hdfs://<ClusterName>-ns/user/hive is not writable by oracle)","sqlState":"08S01","errorCode":40000,"database":"webhcat_test_db_<id>"}

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.