After Upgrade to Mammoth 4.4.0 Impala Error in Hue of "Memory limit exceeded Query did not have enough memory to get the minimum required buffers in the block manager" (Doc ID 2134103.1)

Last updated on MAY 05, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64

Symptoms

In Hue an Impala query raises:

Memory limit exceeded Query did not have enough memory to get the minimum required buffers in the block manager.

 

The Impala daemon log after the startup shows:

W0502 10:35:28.278945 28772 tmp-file-mgr.cc:110] Could not remove and recreate directory /tmp/impala-scratch: cannot use it for scratch. Error was: Encountered error removing directory '/tmp/impala-scratch': Operation not permitted
E0502 10:35:28.279000 28772 tmp-file-mgr.cc:130] Running without spill to disk: could not use any scratch directories in list: /tmp. See previous warnings for information on causes.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms