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

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

Author: Mufeed Usman

 

Original Publication Date: April 13, 2015

 

Environment:

   MapR Core 4.0.2

   MapR Oozie 4.0.1

   MapR Hive 0.13

 

Symptom:

  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.

<job-xml>hive-site.xml</job-xml>

 

Solution:

  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.

Attachments

    Outcomes