Unexpected error during the SELECT query execution

[#1]

Hello Team,

I faced an unexpected error during the execution of the SELECT query for Cloudera Apache Hive instance.
I see the next message in the logs:

errorClass:io.onetouch.exceptions.CrawlerSqlException, msg: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500540) Error caught in BackgroundFetcher. Foreground thread ID: 66051. Background thread ID: 91264. Error caught: null.

Driver: com.cloudera.HiveJDBC42 v2.6.25.1033
JDK: OpenJDK 17

Could you please assist with this issue?

[#2]

@alex88 Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Hive experts @Shmoo @mszurap @cravani  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

[#3]

Please review the HiveServer2 logs for the specific timeframe and provide us with the complete Stacktrace of the failed query, including the cluster version and query details, as well as the DDL statements for the source and target tables.

[#4]

@alex88 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.