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

 

 

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