question Re: Hive JDBC : Could not open client transport with JDBC Uri in Support Questions

Hive JDBC : Could not open client transport with JDBC Uri

ahmed_missaoui_ — Thu, 07 Jan 2016 18:03:36 GMT

Hello,

I tried to connect to hive using jdbc but i had the following error:

Error: Could not open client transport with JDBC Uri: jdbc:hive2://server:10000/;principal=<Server_Principal_of_HiveServer2> java.net.ConnectException: Connection refused (state=08S01,code=0)

I got the same error from beeline : beeline -u 'jdbc:hive2://server:10000/;principal=<Server_Principal_of_HiveServer2>'

I will be thankfull for your help.

thanks

Hive version: 1.2.1

HDP: 2.3

Re: Hive JDBC : Could not open client transport with JDBC Uri

rahulpathak109 — Thu, 07 Jan 2016 23:50:35 GMT

Have you checked if hive services are running? Also server name is correct?

Re: Hive JDBC : Could not open client transport with JDBC Uri

amcbarnett — Fri, 08 Jan 2016 01:00:56 GMT

Is this a kerberos enabled cluster?

Re: Hive JDBC : Could not open client transport with JDBC Uri

GeeKay2015 — Fri, 08 Jan 2016 03:21:35 GMT

is your hive Server is running in HTTP mode?

Connection URL When HiveServer2 Is Running in HTTP Mode:-

jdbc:hive2://<host>:<port>/<db>;transportMode=http;httpPath=<http_endpoint>

where:-

<http_endpoint> is the corresponding HTTP endpoint configured in hive-site.xml. Default value is cliservice.

Default port for HTTP transport mode is 10001.

Re: Hive JDBC : Could not open client transport with JDBC Uri

tsaito — Tue, 19 Jan 2016 02:01:24 GMT

I may be able to provide analysis if you can post any error in hive server2 log.

First thing is to check if hive server2 is up and running properly.

Re: Hive JDBC : Could not open client transport with JDBC Uri

aervits — Tue, 02 Feb 2016 10:14:15 GMT

@Ahmed Missaoui can you accept the best answer to close this thread?

Re: Hive JDBC : Could not open client transport with JDBC Uri

kr_sushilkumarj — Thu, 18 Feb 2016 20:29:22 GMT

Kill your hiveserver2 & metastore & Restart them again.
check hiveserver2 & metastore are running using 'jps' command.
Run "root@hostname~]# beeline -u jdbc:hive2://localhost:10000/" .
if still getting this error then replace "localhost" with "hostname " of step 3

These above steps has worked for me.

Re: Hive JDBC : Could not open client transport with JDBC Uri

ssainath — Thu, 10 Mar 2016 01:56:21 GMT

These can be few reasons :

1) other instance of database may be running .

2) namenode might be in safe mode

3) common localhost:9000 connection refused error.

Best way is to check the hive logs and debug it.

Re: Hive JDBC : Could not open client transport with JDBC Uri

muanang — Mon, 14 Nov 2016 11:55:05 GMT

This happened to me. What I did was connect run the command below from beeline:

beeline> !connect jdbc:hive2://

Then, will ask for my user and pass, and i'm connected to my hive.

I'm having issues now connecting to hiveserver from Hue and Ambari View thou. 😞

EDIT:

I have 2 hiveserver2, hive metastore and webhcat servers.

Re: Hive JDBC : Could not open client transport with JDBC Uri

harrytcs — Fri, 20 Jan 2017 07:23:12 GMT

Hi All,

HiveServer2 is constantly going down and it works max for a day when we restart. The following is the error from hiveserver2 log when it is down.

Connection failed on host ip-172-30-5-146.us-west-2.compute.internal:10000 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_thrift_port.py", line 200, in execute check_command_timeout=int(check_command_timeout)) File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/hive_check.py", line 74, in check_thrift_port_sasl timeout=check_command_timeout) File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 154, 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 238, 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 70, in inner result = function(command, **kwargs) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_call tries=tries, try_sleep=try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 291, in _call raise Fail(err_msg) Fail: Execution of '! beeline -u 'jdbc:hive2://ip-172-30-5-146.us-west-2.compute.internal:10000/;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://ip-172-30-5-146.us-west-2.compute.internal:10000/;transportMode=binary: java.net.ConnectException: Connection refused (state=08S01,code=0) Error: Could not open client transport with JDBC Uri: jdbc:hive2://ip-172-30-5-146.us-west-2.compute.internal:10000/;transportMode=binary: java.net.ConnectException: Connection refused (state=08S01,code=0)

Re: Hive JDBC : Could not open client transport with JDBC Uri

dmehta — Thu, 13 Jul 2017 05:37:35 GMT

I ran into similar problem as @Hari Krishnan Umapathy, my HiveServer2 was going down as soon as I started it. I recommend following steps to debug the:

- Check the error logs(.err) under - /var/log/hive

- Restart the service and put a tail on the new logs: tail -f hiverserver2.log

Note: I was running into out of memory error on my node and stopped some of the unwanted services and was able to bring up hive and beeline.

Re: Hive JDBC : Could not open client transport with JDBC Uri

bthodla — Wed, 19 Aug 2020 16:23:17 GMT

I have the same issue and in my case it is a Kerberos-enabled cluster. I modified the beeline command as follows:

${HIVE_HOME}/bin/beeline -u "jdbc:hive2://<server_name>:10015/default ssl=true;principal=<principal_name>/<hostname>@<REALM>;auth=kerberos; '' ''" "$@"

I get two errors:

- Unknown HS2 problem when communicating with Thrift server.

- Error: Could not open client transport with JDBC Uri: jdbc:hive2://<node_name>:10015/default: Invalid status 21 (state=08S01,code=0)

I would appreciate any help.

Re: Hive JDBC : Could not open client transport with JDBC Uri

yogeshp036 — Tue, 15 Feb 2022 15:56:42 GMT

There is kerboras keytab issue, please take new ticket and connect with HS2, it will work.

Re: Hive JDBC : Could not open client transport with JDBC Uri

Jayakumar — Mon, 12 Sep 2022 12:18:08 GMT

How do we check if Hive is running in Http mode?

I tried to search the same in hive-site.xml and found that http.mode <binary> be default.

In this case , can you please help me with this issue?

Re: Hive JDBC : Could not open client transport with JDBC Uri

Arun0811 — Wed, 06 Nov 2024 08:29:19 GMT

Hi,
I am trying to connect hive database from nodejs using hive-driver npm. In that code,the session cannot be established to access the hive database.
I am putting the console for each and every variables,but the log was printed,before the session establishing code only.please anyone help me on this.please refer a snap shot below.