Author: Mufeed Usman
Original Publication Date: April 13, 2015
MapR Core 4.0.2
MapR Oozie 4.0.1
MapR Hive 0.13
Hive action submitted via Oozie fails with the following error,
[main] ERROR org.apache.hadoop.hive.metastore.RetryingHMSHandler - NoSuchObjectException(message:There is no database named raw_db)
The workflow.xml file used by the Hive job must have the following configuration for hive-site.xml. It is used by Oozie to identify the metastore to connect to. Since this was missing, Oozie was unable to access the Hive metastore.
Add the missing configuration line to the workflow.xml file and re-run the job. More details and sample configuration can be seen at MapR online documentation.