Oozie Hive Action Failing With "ERROR org.apache.hadoop.hive.metastore.RetryingHMSHandler - NoSuchObjectException"

Document created by mufeed on Feb 13, 2016
Version 1Show Document
  • View in full screen mode

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)


Root cause:

   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.