Reply
Explorer
Posts: 14
Registered: ‎01-13-2017

How to manage Impala connection exhaustion

Hello team,
We have different applications/scripts that are fetching data via Impala.

These are jdbc connections. The output of the queries ends up with exceptions

Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: null, SQL state: HY000,

The issue gets resolved after a service restart of Impala.

Is there a way to check how many open connections ? Please let us know.

Thanks and regards
Sayak

Master
Posts: 377
Registered: ‎07-01-2015

Re: How to manage Impala connection exhaustion

You can try to monitor the number of queries in the Impala Daemon's web ui.
Explorer
Posts: 14
Registered: ‎01-13-2017

Re: How to manage Impala connection exhaustion

Thank you. Is there any other way apart from web ui. Like from command interface ?
Master
Posts: 377
Registered: ‎07-01-2015

Re: How to manage Impala connection exhaustion

No, but you can easily write a script to get those data from the Impala Daemon rest api
Highlighted
Champion
Posts: 753
Registered: ‎05-16-2016

Re: How to manage Impala connection exhaustion

If you are looking for number of sessions against HS2 in impala you can use the chart library that you can found in CM -> IMPALA -> Chart library - > 

Announcements