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

Last updated on OCTOBER 11, 2016

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)\n\t
at org.apache.hadoop.hive.ql.metadata.Hive.dropDatabase(Hive.java:289)\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.dropDatabase(DDLTask.java:3451)\n\t
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:232)\n\tat org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)\n\t
...........
at org.apache.hive.hcatalog.cli.HCatCli.main(HCatCli.java:164)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\t
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\t
at java.lang.reflect.Method.invoke(Method.java:606)\n\tat org.apache.hadoop.util.RunJar.main(RunJar.java:212)\n
Caused by: MetaException(message:Database not dropped since hdfs://<ClusterName>-ns/user/hive is not writable by oracle)\n\t
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result$drop_database_resultStandardScheme.read(ThriftHiveMetastore.java:11232)\n\t
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result$drop_database_resultStandardScheme.read(ThriftHiveMetastore.java:11200)\n\t
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_database_result.read(ThriftHiveMetastore.java:11134)\n\t
...............
at com.sun.proxy.$Proxy7.dropDatabase(Unknown Source)\n\t
at org.apache.hadoop.hive.ql.metadata.Hive.dropDatabase(Hive.java:285)\n\t
... 18 more\n",
"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_1414017127"}

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms