ERR_HIVE_HS2_CONNECTION_FAILED: Failed to establish HiveServer2 connection

DSS tried to connect to HiveServer2 but couldn’t establish the connection.

This error can happen:

  • when trying to synchronize the metastore on an HDFS dataset
  • when trying to run Hive recipes, or recipes on Hive engine
  • when trying to run queries on a Hive SQL notebook
  • when trying to import table definitions from the Hive Metastore

This error indicates that the connection could not be established. The message of the error will contain additional information.

Some common reasons for failure to establish the connection are:

  • The connection settings (host, port, …) to the server are invalid
  • The HiveServer2 server is not running or not accepting connections
  • There is a firewall blocking connection attempts from DSS to HiveServer2

Remediation

Note

This issue can only be fixed by a DSS administrator or a cluster administrator

The first step for solving this issue is to go to the Hive settings screen (Administration > Settings > Hadoop)

  • Refer to the documentation on DSS and Hive in order to get additional information on Hive support by DSS.
  • Refer to the documentation on SCP/SFTP sources in order to get additional information on Hive support by DSS.
  • Make sure that the connection settings are correct
  • If you get “connection refused” or similar errors, check that the Hiveserver2 server is properly running and that the Hive settings in DSS allow for authentication over JDBC.
  • Check if a firewall is blocking connections between DSS and the Hiverserver2 server (this can result in either “connection refused” issues, or timeout issues)