HiveServer2 - concurrent.ExecutionException

Highlighted
Seven Stars

HiveServer2 - concurrent.ExecutionException

Hi everyone,

Anyone using Sandbox right now? I'm  not able to connect to Hive & MySQL on Sandbox. Tried to install it on different machine... same issue. Following is the error I'm getting 

 

Connection failure, check the database settings or contact your database administrator.
java.util.concurrent.ExecutionException: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://talend-cdh580.weave.local:10000/default: java.net.ConnectException: Connection refused (Connection refused)

 

Can you please help me with this. Following are Hive connection properties (please see attached file)


Accepted Solutions
Seven Stars

Re: HiveServer2 - concurrent.ExecutionException

Got it - I had to download new MySQL 5.7 from the docker. Please see below for details

Open following file in Gedit - 
/opt/talend/Docker/Cloudera-compose.yml

mysql:
dns: 172.17.0.1
dns_search: weave.local.
environment:
- MYSQL_DATABASE=sandbox
- MYSQL_USER=sandbox
- MYSQL_PASSWORD=sandbox
- MYSQL_ROOT_PASSWORD=first1
hostname: mysql.weave.local
image: mysql:5.7
networks:
- weave

 

 

The only modification is the tag "5.7" instead of "latest"

 

Execute following commands on terminal - 

sudo docker-compose -f ~/.dkr/compose/cluster1/docker-compose.yml rm -f mysql

sudo docker-compose -f ~/.dkr/compose/cluster1/docker-compose.yml down

docker pull mysql:5.7

 

Reboot VM

 

 


All Replies
Seven Stars

Re: HiveServer2 - concurrent.ExecutionException

Got it - I had to download new MySQL 5.7 from the docker. Please see below for details

Open following file in Gedit - 
/opt/talend/Docker/Cloudera-compose.yml

mysql:
dns: 172.17.0.1
dns_search: weave.local.
environment:
- MYSQL_DATABASE=sandbox
- MYSQL_USER=sandbox
- MYSQL_PASSWORD=sandbox
- MYSQL_ROOT_PASSWORD=first1
hostname: mysql.weave.local
image: mysql:5.7
networks:
- weave

 

 

The only modification is the tag "5.7" instead of "latest"

 

Execute following commands on terminal - 

sudo docker-compose -f ~/.dkr/compose/cluster1/docker-compose.yml rm -f mysql

sudo docker-compose -f ~/.dkr/compose/cluster1/docker-compose.yml down

docker pull mysql:5.7

 

Reboot VM

 

 

What’s New for Talend Summer ’19

Watch the recorded webinar!

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

How to Modernize Your Cloud Platform for Big Data Analytics With Talend and Micr...

Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>

Read