My Oracle Support Banner

HIVE Query Fails wiith "Unable to create operation log file: /tmp/hive/operation_logs" (Doc ID 2099903.1)

Last updated on NOVEMBER 08, 2022

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



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.