Hi Divya,
Please see link below for more info, I have added details of how to Cancel
a query using the REST API
https://drill.apache.org/docs/rest-api-introduction/
GET /profiles/cancel/{queryid}
Cancel the query that has the given queryid.
Parameter
queryid--The UUID of the query in standard UUID format that Drill assigns
to each query.
Example
curl
http://localhost:8047/profiles/cancel/29b2e988-35e7-4c85-3151-32c7d3347f15
Thanks,
Khurram
On Thu, Oct 25, 2018 at 11:50 PM Divya Gehlot <[email protected]>
wrote:
> Hi ,
> The query hanging in Cancellation_Request is one of the bug on Drill 1.10
> and this issue has been resolved post Drill 1.10 .
> That's why I am asking is there any way apart from Web UI where I can kill
> the query using the query id ?
> The queries that I am trying to kill are running for days .
>
> Thanks,
> Divya
>
> On Fri, 26 Oct 2018 at 14:04, Sorabh Hamirwasia <[email protected]>
> wrote:
>
> > Hi Divya,
> > If possible can you also try running same query on master ? There have
> been
> > lots of improvement/bug fixes in cancellation code path to resolve hang
> > situations post 1.10.
> >
> > Thanks,
> > Sorabh
> >
> > On Thu, Oct 25, 2018 at 10:49 PM Kunal Khatua <[email protected]> wrote:
> >
> > > What is the Drillbit's JStack? You can try seeing the /threads webpage.
> > >
> > > On 10/25/2018 8:16:06 PM, Divya Gehlot <[email protected]>
> wrote:
> > > Hi,
> > > I am using Dril 1.10 and I have query running for days and when I click
> > on
> > > cacel the query through Drill Web UI . It hung in
> Cancellation_Requested
> > > state .
> > > Is there any way to cancel the query using query id though terminal ?
> > > Appreciate your help !
> > >
> > > Thanks,
> > > Divya
> > >
> >
>
