question Unexpected error during the SELECT query execution in Support Questions

Unexpected error during the SELECT query execution

alex88 — Fri, 08 Nov 2024 12:58:43 GMT

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?

Re: Unexpected error during the SELECT query execution

DianaTorres — Fri, 08 Nov 2024 19:33:41 GMT

@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.

Re: Unexpected error during the SELECT query execution

ggangadharan — Mon, 11 Nov 2024 07:05:14 GMT

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.

Re: Unexpected error during the SELECT query execution

DianaTorres — Wed, 13 Nov 2024 21:40:29 GMT

@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.