Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Configure OJDBC Hive driver to Connect to AWS HDP 2.6

Configure OJDBC Hive driver to Connect to AWS HDP 2.6

Hello,

I am trying to connect my Tableau client to AWS-Hortonworks2.6 and I am constantly getting error

[Hortonworks][Hardy] (34) Error from server: connect() failed: Operation timed out.
Unable to connect to the server "XX.XX.XX.XX". Check that the server is running and that you have access privileges to the requested database.

also had a new errno = 10060

I can connect to hive on my sandbox but not on the AWS, I referred the following link for connecting to AWS-HIVE.

https://hortonworks.github.io/hdp-aws/hive-jdbc/index.html#download-ssl-certificate

But While generating the certificate I am constantly getting this error (tried port 443 & 10000 as found in Ambari):

openssl s_client -servername ${GATEWAY_HOSTNAME} -connect ${GATEWAY_ADDRESS}:443 -showcerts </dev/null | openssl x509 -outform PEM > gateway.pem
connect: Operation timed outconnect:errno=60
unable to load certificate140735832372104:error:0906D06C:PEM routines:PEM_read_bio:no start line:/BuildRoot/Library/Caches/com.apple.xbs/Sources/libressl/libressl-22/libressl/crypto/pem/pem_lib.c:704:Expecting: TRUSTED CERTIFICATE



openssl s_client -servername ${GATEWAY_HOSTNAME} -connect ${GATEWAY_ADDRESS}:10000 -showcerts </dev/null | openssl x509 -outform PEM > gateway.pem

connect: Operation timed out

connect:errno=60

unable to load certificate

I tried to keep my sandbox setting same as AWS, but not sure why I am getting a different error.

Can I disable any security at the moment ?, not sure if that is the reason of failure.

When I test with beeline I get this error

!connect jdbc:hive2://ec2-54-80-219-49.compute-1.amazonaws.com:10000/default;transportMode=http;httpPath=cliserviceConnecting to jdbc:hive2://ec2-54-80-219-49.compute-1.amazonaws.com:10000/default;transportMode=http;httpPath=cliservice

Caused by: org.apache.http.ProtocolException: The server failed to respond with a valid HTTP response
ERROR jdbc.HiveConnection: Error opening session

org.apache.thrift.transport.TTransportException: org.apache.http.client.ClientProtocolException

	at org.apache.thrift.transport.THttpClient.flushUsingHttpClient(THttpClient.java:297)


Caused by: org.apache.http.client.ClientProtocolException


<br>
Don't have an account?
Coming from Hortonworks? Activate your account here