I have a web front-end which submits an HPL/SQL job to a Linux server via SSH containing ImpalaSQL code which returns useful results. Our Impala Admission Control is limited to 5 concurrent running jobs. From the Linux command line, I'm trying to determine the number of executing/pending SQL queries running in a specific Impala Admission Control request pool. Knowing this number at any time will help our web front-end be more user friendly.
I tried to use the following code to view the running queries in a request pool, but unfortunately this is specific to YARN and not Impala Admission Control:
yarn application -list -appStates RUNNING -queue my_request_pool
I did several Google searches, but was unable to find the corresponding command line for Impala Admission Control.
Does anyone know if there exists a CLI for Impala Admission Control so I can see the currently running/pending queries?
Any help would be greatly appreciated!!
You can try accessing Web UI of the Impala daemons in your cluster. Among other things, it contains the lists of all running and X most recently completed queries. Default URL for it is https://your.impala.host:25000/queries. These lists contain "Resource pool" attribute which specifies the AC pool through which a query has entered.