Re: Cannot cancel query - stuck in CANCELLATION_REQUESTED

2016-09-26 Thread Gautam Parai
Can you please run EXPLAIN PLAN FOR your_query? The plan will give an idea if there is something unusual and it will also confirm if this is the same issue as DRILL-4355 (if your query hangs during planning). Gautam On Mon, Sep 26, 2016 at 3:29 AM, Khurram Faraaz wrote:

Re: Cannot cancel query - stuck in CANCELLATION_REQUESTED

2016-09-26 Thread Khurram Faraaz
Can you please get the jstack for the hung Drillbit process ? And what version of Drill are you running ? I found this jira DRILL-4355 maybe related, not sure though. Thanks, Khurram On Mon, Sep 26, 2016 at 2:11 PM, Dan Markhasin

Cannot cancel query - stuck in CANCELLATION_REQUESTED

2016-09-26 Thread Dan Markhasin
I am trying to use Drill with SQL Server using Microsoft's JDBC driver. One of the issues I've ran into is that once submitted, a query cannot be cancelled - sqlline stops responding completely (running on Windows in Embedded mode, not responding to neither Ctrl+C nor Ctrl+D, Ctrl+X, Ctrl+Z,