drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chun Chang <cch...@maprtech.com>
Subject Re: Fetch queries status from drill prompt
Date Thu, 18 Aug 2016 18:07:21 GMT

I believe only when a query is in a "terminal", i.e.
cancelled/completed/failed state, then it is written to the
drillbit_queries.json file on the foreman node. If what you want to do is
monitoring queries running on your cluster, your best bet is to configure
your cluster to store profile information on HDFS and monitor through query
profile. Remember if you have a cluster, you will have a
drillbit_queries.json file on very cluster node where drillbit is running.
And each file only contains completed queries that were run on that node as
foreman. You would have to aggregate to get the whole picture of your
cluster. Even that, you will not see running queries.

Hope this helps.

On Thu, Aug 18, 2016 at 12:34 AM, Anup Tiwari <anup.tiwari@games24x7.com>

> Hi All,
> We want to see all types of queries which ran on drill cluster or currently
> running from drill prompt, Can someone help us on this?
> To achieve above , we read the drill documentation and set up a storage
> plugin to access local file system and able to query
> *"drillbit_queries.json"* log file, but in above file we are getting status
> of all queries whose status is either "cancelled","completed" or "failed"
> but missing "running". At the same time we check drill profile interface
> where we can see running queries.
> I am sure if we can see on User-Interface then it must be coming from
> somewhere.
> Kindly help me on this.
> Regards,
> *Anup Tiwari*
> Software Engineer(BI-Team),PlayGames24x7 Pvt Ltd

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message