Support Questions

Find answers, ask questions, and share your expertise

Error: Could not open client transport with JDBC Uri: jdbc:hive2:

avatar

Connection failed on host wrk2.vmware.com:10000 (Traceback (most recent call last):
File "/var/lib/ambari-agent/cache/common-services/SPARK2/2.0.0/package/scripts/alerts/alert_spark2_thrift_port.py", line 144, in execute
Execute(cmd, user=hiveruser, path=[beeline_cmd], timeout=CHECK_COMMAND_TIMEOUT_DEFAULT)
File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 166, in __init__
self.env.run()
File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 160, in run
self.run_action(resource, action)
File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 124, in run_action
provider_action()
File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 262, in action_run
tries=self.resource.tries, try_sleep=self.resource.try_sleep)
File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 72, in inner
result = function(command, **kwargs)
File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 102, in checked_call
tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy)
File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 150, in _call_wrapper
result = _call(command, **kwargs_copy)
File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 303, in _call
raise ExecutionFailed(err_msg, code, out, err)
ExecutionFailed: Execution of '! beeline -u 'jdbc:hive2://wrk2.vmware.com:10000/default' transportMode=binary -e '' 2>&1| awk '{print}'|grep -i -e 'Connection refused' -e 'Invalid URL'' returned 1. Error: Could not open client transport with JDBC Uri: jdbc:hive2:// wrk2.vmware.com:10000/default: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
Error: Could not open client transport with JDBC Uri: jdbc:hive2:// wrk2.vmware.com:10000/default: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
)

Due to above not able start Spark2 Thrift Server

1 REPLY 1

avatar
Master Mentor

@sharath kumar A S

As the error is basically "Connection Refused"

jdbc:hive2://xxx.yyy.com:10000/default java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)

So can you please check if the Port 10000 is opened on the HS2 host?

# netstat -tnlpa | grep 10000

.

Also please check if the port 10000 is accessible from the host where you are Spark2 is installed. This is to isolate any Connectivity / Firewall issue:

# nc -v xxx.yyy.com 10000
(OR)
# telnet xxx.yyy.com 10000

.