- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hive JDBC connection on AWS
Created on ‎01-29-2014 10:02 AM - edited ‎09-16-2022 01:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎01-29-2014 03:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎01-29-2014 03:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎01-30-2014 08:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@anisbet Thanks for closing the loop on this thread with us!
