My Oracle Support Banner

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


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



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.