How to resolve HTTP/1.1 500 Server jdbc/odbc error

Issue:

When you are trying to run queries from Tableau, SQuirrel etc.. connecting to Hiveserver2 via JDBC/ODBC driver in a Knox environment, you might intermittently come across the above error. This error pops-up especially when the query has more columns in the select statement. Interestingly, the same query works fine from hive cli and beeline cli.

Resolution:

This is a bug in Knox - https://issues.apache.org/jira/browse/KNOX-492

Log into Ambari > Knox > Config > Add the below under "Advanced Topology" file section

<service>
<role>HIVE</role>
<url>http://localhost:10001/cliservice</url>
<param>
<name>replayBufferSize</name>
<value>16</value>
</param>
</service>