+ New Ticket

Connection to HDP 2.6 with knox

Comments

2 comments

  • Official comment
    Avatar
    Aleksander Vinokur

    Hello MAIF,

    Please follow the instructions by the link below:

    https://support.aginity.com/hc/en-us/articles/115004427727-Knox-queries-fail-quickly-with-a-HTTP-Response-code-500-error

    Let us know if it works for you.

    Regards,

    Alex.

    Comment actions Permalink
  • Avatar
    Eli Weine

    The above article is only accessible for Amp subscription customers, however we have pasted the contents below:

    Knox queries fail quickly with a HTTP Response code: 500 error

    Hive queries fail quickly with a HTTP Response code: 500 error in Knox, but if you send the query directly to Hiveserver2 the query works.

    This is likely because the size of query being sent is larger than default replayBufferSize.

    Workaround(s)

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

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

    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:

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

    0
    Comment actions Permalink

Please sign in to leave a comment.