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.

Connect Zoomdata to Cloudera Amazon Hive

Solved Go to solution

Connect Zoomdata to Cloudera Amazon Hive

Explorer

I loaded some of my own data into Hive and can easily work with it through Hue.   I've read a number of topics here about trying to connect to both Impala and Hive.  But, when I try to use the connection strings within Zoomdata I simply get failed connections.    I believe I have made sure the appropriate ports are open in the Network ACL and that the appropriate Security Groups.   I've tried, among others,the following with no success:

 

jdbc:hive2://<Manager Node IP>:10000/;auth=noSasl
jdbc:hive2://<A Worker Node IP>:10000/default;user=<my username>;password=<my password>

 

jdbc:impala://<Manager Node IP>:21050/;auth=noSasl
jdbc:impala://<Manager Node IP>:21050/default;user=<my username>;password=<my password>

 

What am I missing?

 

 

 

I also noticed the following within Hue:

 

Snap 2016-02-19 at 09.16.44.png

I haven't touched anything related to the Impala configuration.   I have started and stopped the instances.

Should that have caused a problem in Impala?

 

What do I need to do to get impala back up and running?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Connect Zoomdata to Cloudera Amazon Hive

Explorer

Ignore all the above.   It's funny how if you actually pay attention to status messages and do things about them, you stop having problems.

 

BTW:  Now I love the Cloudera Manager!

1 REPLY 1
Highlighted

Re: Connect Zoomdata to Cloudera Amazon Hive

Explorer

Ignore all the above.   It's funny how if you actually pay attention to status messages and do things about them, you stop having problems.

 

BTW:  Now I love the Cloudera Manager!