Can not open connection to Hive

[nsaolapu]

Description

I trying to connect one HIveDB from DBeaver and i am getting the error as shown above . i can connect to the server using other tools like Putty, WinScp and Hive Shell. Any help regrading this is highly appreciated.

DBeaver Version

22.0.4

Operating System

Windows 10 Enterprise

Database and driver

1 . Database HIVE and Driver "org.apache.hive.jdbc.HiveDriver"

hive-jdbc-uber-2.6.5.0-292.jar

Steps to reproduce

1. I try to connect to the database using credentials
2. i get this error
   Could not open client transport with JDBC Uri: jdbc:hive2://{HiveServer}:10001/{DB}: java.net.ConnectException: Connection refused: connect
   java.net.ConnectException: Connection refused: connect
   java.net.ConnectException: Connection refused: connect
   Connection refused: connect
   Connection refused: connect
   I kept server name as hidden.

Additional context

No response

[LonwoLonwo]

Hello @nsaolapu
Maybe this thread will be helpful for you: https://community.cloudera.com/t5/Support-Questions/Hive-JDBC-Could-not-open-client-transport-with-JDBC-Uri/td-p/101772

[LonwoLonwo]

Did you use the URL connection type or host?

[nsaolapu]

Hi , I did use host and specified the our server name there. .

…

On Thu, 5 Jan, 2023, 2:43 pm Anastasiya, ***@***.***> wrote: Did you use the URL connection type or host? [image: 2023-01-05 12_12_38-Connect to a database] <https://user-images.githubusercontent.com/45152336/210743682-2e70f0c8-1cbf-4d55-b578-f710eee93b78.png> — Reply to this email directly, view it on GitHub <#18663 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5CYTYKIQXAWIYLA7U7ACGTWQ2GFHANCNFSM6AAAAAATRQ2ZCY> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[ShadelessFox]

Hello @nsaolapu,

I'm sorry for the late response. Are you using an SSH tunnel?

[nsaolapu]

We arr not using SSH . its not required . i have specified the connection that we are using in mail trail above

…

On Thu, 26 Jan, 2023, 7:22 pm ShadelessFox, ***@***.***> wrote: Hello @nsaolapu <https://github.com/nsaolapu>, I'm sorry for the late response. Are you using an SSH tunnel? — Reply to this email directly, view it on GitHub <#18663 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5CYTYOH5YTEXEU6LUU4ND3WUJ6QRANCNFSM6AAAAAATRQ2ZCY> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[ShadelessFox]

It looks like the supplied server URL/address is not accessible. Are you sure it's available through other tools without an SSH tunnel?

[E1izabeth]

It's been a long time since no update here. If you encounter this issue again, please let me know and provide additional info.