11-27-2015 07:36 AM
I have a CDH5.4.4 cluster
I can't run Hive queries from Hue, it throws this error:
Fetching results ran into the following error(s):
Couldn't find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=31e3ba21-952b-4cdf-8688-c8716fcb430d]
Surfing around I found this:
How can I implement it on Cloudera Manager ? Is it the correct solution ?
11-30-2015 03:14 AM
11-30-2015 06:42 AM
There are a couple of options here:
1. Change the operations logging location by setting the following in HiveServer2 Advanced Configuration Snippet:
<property> <name>hive.server2.logging.operation.log.location</name> <value>/path/to/new/location</value> </property>
2. Make sure the default location exists and has correct permissions:
In either case make sure that the configured location exists and has permissions based on the above.
11-30-2015 07:44 AM
05-04-2016 07:29 AM
We have done the same settings but still getting the same error though for some users only they get the error plus we have also give 755 to /tmp/hive instead of 700 as mentioned below.