The error message is being thrown by Hive SQLStandardAuth authorization mode which disallows hive.cbo.enable to be set in the HS2 client session. As @Andrew Grande mentioned CBO should be enabled by default. For CBO to get exercised make sure stats are generated for the table in question. ANALYZE TABLE <table> [partion(key)] COMPUTE STATISTICS; ANALYZE TABLE <table> [partion(key)] COMPUTE STATISTICS FOR COLUMNS; ... View more

From the error you posted it seems that the default debug port is already taken. You can change the default port by following invocation hive --debug:port=8101 ... View more

You would need the following jars in your classpath: /usr/hdp/current/hive-client/lib/hive-jdbc.jar /usr/hdp/current/hadoop-client/hadoop-common.jar /usr/hdp/current/hadoop-client/hadoop-auth.jar With these in the classpath you can compile and execute your java client. ... View more