My Oracle Support Banner

Hive Jobs in Big Data Cloud Fail with: "Error: Failure while running task:java.lang.RuntimeException...there are 2 datanode(s) running and 2 node(s) are excluded in this operation." (Doc ID 2513609.1)

Last updated on JANUARY 29, 2020

Applies to:

Oracle Big Data Cloud Service - Compute Edition - Version N/A and later
Information in this document applies to any platform.


When using Oracle Big Data Cloud, (BDC), hive queries and jobs intermittently fail.  One of the larger hive query (HQL) jobs is run on a daily basis and runs queries and uses mapreduce to merge new data into data warehouse/summary tables.
The job is run on the HQL command line using syntax like:

If the job is re-attempted, it will run to completion but is slower than expected and takes approximately 20 minutes.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.