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 <kfar...@maprtech.com> wrote: > 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 > <https://issues.apache.org/jira/browse/DRILL-4355> maybe related, not sure > though. > > Thanks, > Khurram > > On Mon, Sep 26, 2016 at 2:11 PM, Dan Markhasin <minimi...@gmail.com> > wrote: > > > 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, > > etc.) and when trying to cancel the query from the UI it just changes to > > CANCELLATION_REQUESTED and stays in this state indefinitely. > > The only way to get out of this state is to kill sqlline... > > > > There is nothing in the log except for: > > > > 2016-09-18 20:53:07,521 [28212b88-282a-8bde-a2a7-93a6d9afc317:frag:0:0] > > INFO o.a.d.e.w.fragment.FragmentExecutor - > > 28212b88-282a-8bde-a2a7-93a6d9afc317:0:0: > > State change requested AWAITING_ALLOCATION --> RUNNING > > 2016-09-18 20:53:07,529 [28212b88-282a-8bde-a2a7-93a6d9afc317:frag:0:0] > > INFO o.a.d.e.w.f.FragmentStatusReporter - > > 28212b88-282a-8bde-a2a7-93a6d9afc317:0:0: > > State to report: RUNNING > > 2016-09-18 20:53:50,274 [CONTROL-rpc-event-queue] INFO > > o.a.d.e.w.fragment.FragmentExecutor > > - 28212b88-282a-8bde-a2a7-93a6d9afc317:0:0: State change requested > RUNNING > > --> CANCELLATION_REQUESTED > > 2016-09-18 20:53:50,276 [CONTROL-rpc-event-queue] INFO > > o.a.d.e.w.f.FragmentStatusReporter > > - 28212b88-282a-8bde-a2a7-93a6d9afc317:0:0: State to report: > > CANCELLATION_REQUESTED > > > > Is this a known issue with Drill & JDBC ? > > >