My Oracle Support Banner

Connection refused to HiveServer2 via JDBC on the BDA (Doc ID 2009130.1)

Last updated on DECEMBER 03, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 and later
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

The symptoms on BDA V4.1 OL6 are:

1. Errors like the following are raised during a hive job:

ERROR: Could not open connection to jdbc:hive2://bdanode0x.example.com:10000/TEST1. Check your Hive server status and
      also set option SUBPROTOCOL= appropriately.  Set SUBPROTOCOL=hive2 if you are running HiveServer2.  Set SUBPROTOCOL=hive if  you are running Hive1.
ERROR: Could not open connection to jdbc:hive2://bdanode0x.example.com:10000/TEST2. Check your Hive server status and also
      set option SUBPROTOCOL= appropriately.  Set SUBPROTOCOL=hive2 if you are running HiveServer2.  Set SUBPROTOCOL=hive if you are running Hive1.
ERROR: Error trying to establish connection.

 

2. The Zookeeper logs report errors indicating shortage of maxClientCnxns.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.