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

Symptoms

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/****
java.io.IOException: No such file or directory
  at java.io.UnixFileSystem.createFileExclusively(Native Method)
  at java.io.File.createNewFile(File.java:1012)
  at org.apache.hive.service.cli.operation.Operation.createOperationLog(Operation.java:195)
  at org.apache.hive.service.cli.operation.Operation.beforeRun(Operation.java:237



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

 

Cause

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