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

[#1]

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>

[#2]

I wrote about this a while back not really a bug anymore but more of default setting that needs to be adjusted based on data being passed. see https://community.hortonworks.com/articles/33875/knox-queries-fail-quickly-with-a-500-error.html