Connect to talend hive in Cloudera Sandbox

Five Stars

Connect to talend hive in Cloudera Sandbox

 

I have cloudera distribution imported along with the Talend VM. However talend Weave Scope is not showing up the Hive host 

i am not very sure whether hive services are started or not?if they need to be started what is the command to execute it in command prompt.

from where can i get the hive host,port ,resource manager uri,name node uri,database,username,password etc of hive cloudera.can you please help finding the below config details.

 

Note:i have not installed Cloudera manager separately due to memory issues.so as i believe when Cloudera distribution is imported it would install Hive as well.

 

 

 

Hive Config.png


Accepted Solutions
Five Stars

Re: Connect to talend hive in Cloudera Sandbox

 

 

Following is the Cloudera configuration to connect to Hive.

 

Cloudera-HiveConfig.JPG

View solution in original post


All Replies
Eight Stars

Re: Connect to talend hive in Cloudera Sandbox

Are you using the Cloudera Quickstart VM? Your screenshot looks like you are trying to connect to a HortonWorks cluster, not a Cloudera one. In general, when you start the Quickstart VM, it will start the Hive service: the easiest way to check is to pull up Cloudera Manager inside the VM and look for the green circle next to the Hive service.

Five Stars

Re: Connect to talend hive in Cloudera Sandbox

Thank you for the reply.just for refrence i had uploaded the screenshot.however i was trying to connect to cloudera one(hive) distribution.i am not seeing the cloudera manager with talend sandbox.any idea how to get those services started/to pullup in sandbox.
Five Stars

Re: Connect to talend hive in Cloudera Sandbox

Thank you for the reply.just for refrence i had uploaded the screenshot.however i was trying to connect to cloudera one(hive) distribution.i am not seeing the cloudera manager with talend sandbox.any idea how to get those services started/to pull-up in sandbox.
Eight Stars

Re: Connect to talend hive in Cloudera Sandbox

Here's a tutorial I wrote on how to connect Talend Open Studio to the Quickstart VM. I hope it's what you're looking for:

 

http://synchronicanalytics.com/connecting-talend-open-studio-to-cloudera-quickstart/

Five Stars

Re: Connect to talend hive in Cloudera Sandbox

I have nt installed Cloudera quick start VM.Only installed Talend big data sandbox and cloudera distribution provided by talend.

and trying to connect to Hive with the attached configuration and i am getting the below error.tried with other hosts as well but nothing works out.your help on this greatly appreciated.

 

Connection failure. You must change the Database Settings.
java.sql.SQLException: java.util.concurrent.ExecutionException:
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://talend:9083/default: java.net.ConnectException: Connection refused (Connection refused)

Five Stars

Re: Connect to talend hive in Cloudera Sandbox

Hi David,
Any thoughts on this.may i request you to go through the latest comment and screenshot.Thanks for your help on this
Five Stars

Re: Connect to talend hive in Cloudera Sandbox

 

 

Following is the Cloudera configuration to connect to Hive.

 

Cloudera-HiveConfig.JPG

View solution in original post

Eight Stars

Re: Connect to talend hive in Cloudera Sandbox

Arun,

 

Sorry, I don't know enough about that distribution to be of any help. It's saying "connection refused", which means your settings are correct, but the authentication won't let you in. Double-check your username and password to make sure they are correct, then temporarily disable your firewall and try to connect. That's the best I can do from here.

 

Good luck,

 

David

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now