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

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

Cause