After Certain Number of Query Executions, Impala Service Hangs
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]
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
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