Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)

SYMPTOM: Hive query through knox fails quickly with a a 500 error.

ERROR: You will find something like this in the gateway-audit.log

dispatch|uri|http://<hostname>:10000/cliservice?doAs=dav|success|Response status: 500 

ROOT CAUSE: Size of query being sent is larger than default replayBufferSize.

RESOLUTION: Change your topology to contain the following parameter in the service that is having the issue.

<param><name>replayBufferSize</name><value>16</value></param> 

For example if I had this issue in hive it would look something like:

<service> 
<role>HIVE</role> 
<url>$HTTP_SCHEME://$HIVE_HOST:10001/cliservice</url> 
<param><name>replayBufferSize</name><value>16</value></param> 
</service> 

The Value of the replayBufferSize is in KB and has a default of 8KB. Make sure the value is larger than your largest query size in order to get past this issue.

1,978 Views
Comments
New Contributor

I'm having same issue, how do you check size of query?

Hi Jennie, You can just pull the query out to a file and check how big the file is.

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎05-17-2016 11:00 PM
Updated by:
 
Contributors
Top Kudoed Authors