Support Questions
Find answers, ask questions, and share your expertise

JDBC hive connection error in beeline through knox

Highlighted

JDBC hive connection error in beeline through knox

New Contributor

I'm a newbie to hdp and knox.

My HDP environment description:

HDP version - 2.6

HS2 is enabled

Hive transport mode - HTTP

Knox installed via ambari

SSL is not enabled

non Kerberized instance

Issue:

I'm trying to connect to HIVE via beeline. The connection string is "!connect jdbc:hive2://<ip>:8443/;transportMode=http;httpPath=gateway/<ip>/hive". the user name : admin, password: admin-password. Its throws an an error : "18/06/18 08:17:39 [main]: ERROR jdbc.HiveConnection: Error opening session org.apache.thrift.transport.TTransportException: org.apache.http.NoHttpResponseException: <ip>:8443 failed to respond" and "Error: Could not establish connection to jdbc:hive2://<ip>:8443/;transportMode=http;httpPath=gateway/<ip>/hive: org.apache.http.NoHttpResponseException: <ip>:8443 failed to respond (state=08S01,code=0)".

Things i've tired:

I've tried changing the httpPath with "cliserver", "gateway/default/hive" and they didn't work.

I've tried to changing the connection url with " !connect jdbc:hive2://<ip>:10001/default;transportMode=http; httpPath=cliservice;" it worked but as it dont server the purpose of knox. as i'm trying to use exposed hive port.

I appreciate if any one can help me with detailed solution to this problem.