Hive JDBC connection on AWS

anisbet — Fri, 16 Sep 2022 08:53:05 GMT

Hi,

I have set up a four node CDH cluster using the following instructions(http://blog.cloudera.com/blog/2013/03/how-to-create-a-cdh-cluster-on-amazon-ec2-via-cloudera-manager/) Everything seems to be up and running, but I having difficulty connecting to the cluster's hive instance using JDBC. I have verified the following

Hive is up and running
Port 10000 has been added to my security group

I am trying to connect to hive from another AWS instance using the public interface(I am running Jaspersoft on this instance).

Here is my connection string(ip specifics Xed out): jdbc:hive://ec2-xx-xx-x-xx.compute-1.amazonaws.com:10000/default

When I try to use this I am getting a connection refused message on the client side, and I am not seeing anything help in any of the server side messages.

Does anyone have any ideas?

Thanks

Re: Hive JDBC connection on AWS

anisbet — Wed, 29 Jan 2014 23:19:34 GMT

In case anyone else runs into this issue. The problem was that the Thrift server wasn't running. Once we started that on our target system(hive --service hiveserver ) We were able to connect via JDBC.

Re: Hive JDBC connection on AWS

Clint — Thu, 30 Jan 2014 16:15:27 GMT

@anisbet Thanks for closing the loop on this thread with us!

question Re: Hive JDBC connection on AWS in Archives of Support Questions (Read Only)

Hive JDBC connection on AWS

Re: Hive JDBC connection on AWS

Re: Hive JDBC connection on AWS