Error "Memory limit exceeded" Refreshing Cloudera Impala Extracts

KNOWLEDGE BASE

Error "Memory limit exceeded" Refreshing Cloudera Impala Extracts

Published: 17 Sep 2018
Last Modified Date: 17 Sep 2018

Issue

Impala extract refresh fails, and the following error can be seen in the Backgrounder Tasks for Extracts administrative view:

{
com.tabIeausoftware.nativeapi.dII.TabIeauException: (ClouderaJLI mpaIaODBCJ (120) Error while retrieving data from

in Impala: CHYOOOJ : Memory limit exceeded: Error occurred on backend xxxx

xxx

Unable to create extract

}

Environment

Tableau Server
Windows
Cloudera Hadoop Hive

Resolution

Work with your DBA to increase the database's memory limit.

Cause

This error is an Impala error message which is passed through and displayed in Tableau Server, indicating that the database has reached its memory limit.

Additional Information

impala memory limit exceed at Cloudera Community
What are the most memory-intensive operations? in Cloudera docs

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.