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

Last updated on MAY 14, 2015

Applies to:

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

Symptoms

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms