Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cancel or close queued queries using Impala JDBC driver

SOLVED Go to solution

Cancel or close queued queries using Impala JDBC driver

Explorer

Hi,

 

I have a dashboard application (using Zoomdata) in which we submit queries to a Impala resource pool with limited number of concurrent requests. While we load the dashboard, some queries might get queued if conc. requests limit is reached.

When I change the dashboard time range, I noticed the running queries are properly cancelled, but the queued ones stay in the queue and are going to execute before the new queries submitted.

 

Do you know if there is any Impala JDBC driver property or Impala server setting to be able to cancel queued queries and prevent them from running?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Cancel or close queued queries using Impala JDBC driver

Master Collaborator

We fixed this behaviour in CDH6.1/Impala 3.1 - there was a product limitation that queued queries couldn't be cancelled. After the fix they should be cancellable the same as any other query. For reference, https://issues.apache.org/jira/browse/IMPALA-5216

2 REPLIES 2

Re: Cancel or close queued queries using Impala JDBC driver

Master Collaborator

We fixed this behaviour in CDH6.1/Impala 3.1 - there was a product limitation that queued queries couldn't be cancelled. After the fix they should be cancellable the same as any other query. For reference, https://issues.apache.org/jira/browse/IMPALA-5216

Re: Cancel or close queued queries using Impala JDBC driver

Explorer
Thanks a lot, Tim!