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 (2)

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>
3,037 Views
Comments

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

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