KNOWLEDGE BASE

[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Rejected query from pool root.s_app_tableau


Published: 27 Jun 2022
Last Modified Date: 27 Jun 2022

Issue

When attempting to run refresh extract in Tableau Server, the following error may occur:

"java.lang.RuntimeException: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Rejected query from pool root.s_app_tableau: request memory needed xxx GB is greater than pool max mem resources xxx GB.

Use the MEM_LIMIT query option to indicate how much memory is required per node. The total memory needed is the per-node MEM_LIMIT times the number of nodes executing the query. See the Admission Control documentation for more information."

Environment

  • Tableau Server
  • Cloudera Hadoop Hive

Resolution

Please work with the Impala database administrator to check and configure MEM_LIMIT option via Impala Admission control.

Cause

The default query mem_limit is set too small to run the query in Impala.
Did this article resolve the issue?