Dataproc Hive: Auto reconnect is not allowed for this connection

[ashishcwx]

I am facing below error while  running tableau prep workflow which is connecting to hive on Dataproc.

"System error: An error occurred while communicating with the Cloudera Hadoop data source 'PrepDataSource' [Cloudera][Hardy] (71) Auto reconnect is not allowed for this connection. Original Error: Bad Status: Unrecognized response with no error message header. Status code: 500 Something went wrong. Try rerunning the flow."

For the error, it looks like, need to enable autoReconnect property, just tried to search and possible location for autoReconnect looks in hive-site.xml but not sure whether autoReconnect property is a valid property to configure in hive-site.xml or is there any other place which I can look for?

Many thanks in advance.

[caryna]

Hi @ashishcwx,

Welcome to Google Cloud Community!

There are common possibilities why you have encountered this error. The possible causes could be network connectivity problems between Hive and Tableau Prep or resource exhaustion on the Hive server.

To investigate further, use Cloud Logging to identify potential errors. Additionally, check Cloud Monitoring to monitor key metrics, ensuring Dataproc has sufficient resources.

If the issue persists, please contact Google Cloud Support. When reaching out, include detailed information and relevant screenshots of the errors you’ve encountered. This will assist them in diagnosing and resolving your issue more efficiently.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[ashishcwx]

Than you @caryna for response.

We have investigated further using cloud logging and cloud monitoring and didn't find anything suspicious.