After Certain Number of Query Executions, Impala Service Hangs

(Doc ID 1950306.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 3.0 to 4.0 [Release 3.0 to 4.0]
Linux x86-64

Symptoms

On Oracle Big Data Appliance 3.0.1 with Impala 1.3.1, executing queries from Impala shell and OBI EE installed on Exalytics machine.

Intermittently one of the Select query from either Impala-shell thru OBI EE seems to hang and gets cancelled. Existing concurrent queries will stop making progress, and any new queries generally won't start. The
'Cancel' links on the web UI will also start timing out.

During the Hang , checked memory usage thru Cloudera Manager and also command line to make sure OOM is not the cause.

Eventually Impala service becomes unusable and the only solution is to restart the Impala service

 

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