JDBC Impala & Hive connections are not stable. Always return Connection timeout expired

kamolchanok_tankamolchanok_tan Member Posts: 3 Contributor I
Hi, Anyone know
Where is timeout configuration for JDBC connection for Hive and Impala which is truly apply on RapidMiner Studio and RapidMiner AI hub Server?

There are the steps in more details below that I have applied but it does not truly eliminate the timeout issue:

1. I am using JDBC Impala and Hive connection from JDBC driver jar. with RapidMiner  9.8

 Both connections are test successful.

2. I set my timeout RapidMiner studio > Settings> Preferences > Tools >Database Login timeout 

3. I ran very simple flow (to retrieve one table), it works fine as shown below (unit of time = millisecond)


<Figure: Process Execution Performance Monitoring>

4. However, I ran more complex workflow on RapidMiner Studio and took around 12 minutes. Then, it threw timeout exception. Sometime, I ran the same workflow on RapidMiner studio, it ran successfully. 


5.       Moreover, I tried the complex workflow on RapidMiner AI hub Server, It took around 3 minutes and threw timeout exception. 


Thanks 

Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,505 RM Data Scientist
    Hi there,

    please connect with your Customer Success Manager or directly with the support team. Those errors can have multiple reasons.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.