User receives errors querying against Cloudera Impala: Memory limit exceeded

Diagnostics

Product: Reporting Server

Release: 8206

Primary OS: Linux

Solution Date: 2020-04-20

Symptom

Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement.

(FOC1500)  :  Error Code: 0, SQL state: Memory limit exceeded

(FOC1500)  :  Error occurred on backend bda1node49.infoftps.com:22000 by fragment

Problem

The user receives the errors above with a query against Cloudera Impala.

Does the Impala adapter provide a way to control memory allocation?

Solution

The Impala adapter does not, but you can use SQL Passthru with the following native setting:

ENGINE SQLIMP
SET MEM_LIMIT=2000000000 ;
END

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.