Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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

Image: https://us.v-cdn.net/6030995/uploads/editor/08/8rf7zaftuv7r.jpg

Both connections are test successful.

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

Image: https://us.v-cdn.net/6030995/uploads/editor/hz/n34f181ujb5p.png

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

Find more posts tagged with

AI Studio

JDBC

Connections

Accepted answers

All comments

MartinLiebig

Hi there,

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

Best,

Martin