HIVE Query Fails wiith "Unable to create operation log file: /tmp/hive/operation_logs"

(Doc ID 2099903.1)

Last updated on JANUARY 25, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64


Running a Hive query in Hue fails, for some users, with following error.  Other users run the query successfully in Hue.

Bad status for request TFetchResultsReq(fetchType=1, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='...

The hive logs show the following error:

2016-01-14 14:06:13,139 WARN org.apache.hive.service.cli.operation.Operation: Unable to create operation log file: /tmp/hive/operation_logs/**** No such file or directory
  at Method)
  at org.apache.hive.service.cli.operation.Operation.createOperationLog(
  at org.apache.hive.service.cli.operation.Operation.beforeRun(

Is is observed that the Hive operation logs created under /tmp/hive/operation_logs have the following permissions.  Changing permissions on the operation_logs folder to 0777 does not help.

drwxr-xr-x 11 hive hive 4096 Jan 14 15:09 operation_logs



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