KNOWLEDGE BASE

[Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [HY000] : Query expired due to execution time limit


Published: 28 Jun 2022
Last Modified Date: 29 Jun 2022

Issue

When attempting to run refresh extract in Tableau Server, the following error may occur:
 
This job failed on xxx after running for 60.1 min because of: java.lang.RuntimeException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [HY000] : Query xxx expired due to execution time limit of 1h
LUID: xxx
Content: xxx

Environment

  • Tableau Desktop 2022.1.2
  • Cloudera Hadoop Hive

Resolution

Please work with the Impala database administrator to reconfigure EXEC_TIME_LIMIT_S query option to allow the long query execution.

Cause

The EXEC_TIME_LIMIT_S query option configured in Impala defines a time limit on query execution. If a query is executing when the time limit expires, it is automatically canceled. 
Did this article resolve the issue?