There is an open JIRA DRILL-4258 <https://issues.apache.org/jira/browse/DRILL-4258> Once that is fixed/implemented you can query from sys.queries or sys.statements to know about all SQL statements that are in different states.
Khurram On Fri, Aug 19, 2016 at 4:45 PM, Anup Tiwari <[email protected]> wrote: > Thanks for above info.. i found running queries information in Zookeeper > logs but i guess it is in binary or some other form. > Is their any way to read it in drill? > > Regards, > *Anup Tiwari* > Software Engineer(BI-Team),PlayGames24x7 Pvt Ltd > > On Thu, Aug 18, 2016 at 11:59 PM, Sudheesh Katkam <[email protected]> > wrote: > > > Profiles of running queries are stored in Zookeeper (or the configured > > transient store). > > > > Thank you, > > Sudheesh > > > > > On Aug 18, 2016, at 11:23 AM, Anup Tiwari <[email protected]> > > wrote: > > > > > > Thanks chun for info.. > > > > > > But can you tell me from where, running queries status come on profile > > > user-interface(UI)? Because if it's coming on profile UI then it must > > have > > > some back end file or something like that.. > > > On 18-Aug-2016 11:37 PM, "Chun Chang" <[email protected]> wrote: > > > > > > Anup, > > > > > > 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 < > [email protected] > > > > > > wrote: > > > > > >> 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 > > >> > > > > >
