Knox queries fail quickly with a 500 error

[#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.

[#2]

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

[#3]

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