Skip to main content
alex88
alex88
Bronze ⭐️⭐️⭐️
November 8, 2024
Question

Unexpected error during the SELECT query execution

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?

 

    3 replies

    DianaTorres
    Community Manager
    DianaTorres
    Community Manager
    November 8, 2024

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

    Translate
    Regards, Diana Torres, Senior Community Moderator
      ggangadharan
      Gold ⭐️
      ggangadharan
      Gold ⭐️
      November 11, 2024

      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.

      Translate
        DianaTorres
        Community Manager
        DianaTorres
        Community Manager
        November 13, 2024

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

        Translate
        Regards, Diana Torres, Senior Community Moderator
        Terms & ConditionsAccessibility statement