If there is a problem connecting to any of the storage plugins that are enabled, irrespective of whether that plugin is used in the query or not, query can hang. Disable any plugins you are not using and remove unnecessary workspaces. You can enable/disable different storage plugins to narrow down the problem.
Thanks Padma > On Oct 9, 2017, at 1:05 AM, Tushar Pathare <[email protected]> wrote: > > Hello Team, > What are the pre-reqs needed to be performed to > ensure the queries are getting fired. > Strangely the Json profiles for queries are not getting created. > > And the query log stops at this message > > > drillbits: > Address | User Port | Control Port | Data Port | Version | > scflexnode02 | 31010 | 31011 | 31012 | 1.11.0 | > > 2017-10-09 10:57:22,867 [main] INFO o.apache.drill.exec.server.Drillbit - > Startup completed (9619 ms). > 2017-10-09 10:57:22,869 [main] DEBUG o.apache.drill.exec.server.Drillbit - > Started new Drillbit. > 2017-10-09 11:00:05,464 [2624d37a-4364-1dd5-8d2d-043f4b364b9b:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - Query text for query id > 2624d37a-4364-1dd5-8d2d-043f4b364b9b: SELECT A.SSDM_ID, A.SOURCE_SYSTEM, > A.SOURCE_SYSTEM_ID FROM tc.SAMPLE_MGMT.TBL_CODE_SYSTEM_MAPPING A INNER JOIN > tc.SAMPLE_MGMT.TBL_SAMPLE_SECURITY B ON A.SSDM_ID = B.SSDM_ID WHERE B.ACTIVE > = 1 AND B.USER_ID ='test' > 2017-10-09 11:00:05,481 [2624d37a-4364-1dd5-8d2d-043f4b364b9b:foreman] DEBUG > o.a.d.e.s.h.HBaseStoragePluginConfig - Initializing HBase StoragePlugin > configuration with zookeeper quorum 'localhost', port '2181'. > 2017-10-09 11:00:40,690 [qtp1218188770-76] DEBUG > o.a.d.e.s.h.HBaseStoragePluginConfig - Initializing HBase StoragePlugin > configuration with zookeeper quorum 'localhost', port '2181'. > > The query log doesn’t proceed beyong this and query is just running. > I checked all the connection to the databases and they are ok. > > > > Tushar B Pathare MBA IT,BE IT > Bigdata & GPFS > Software Development & Databases > Scientific Computing > Bioinformatics Division > Research > > "What ever the mind of man can conceive and believe, drill can query" > > Sidra Medical and Research Centre > Sidra OPC Building > Sidra Medical & Research Center > PO Box 26999 > Al Luqta Street > Education City North Campus > Qatar Foundation, Doha, Qatar > Office 4003 3333 ext 37443 | M +974 74793547 > [email protected]<mailto:[email protected]> | > www.sidra.org<http://www.sidra.org/> > > > Disclaimer: This email and its attachments may be confidential and are > intended solely for the use of the individual to whom it is addressed. If you > are not the intended recipient, any reading, printing, storage, disclosure, > copying or any other action taken in respect of this e-mail is prohibited and > may be unlawful. If you are not the intended recipient, please notify the > sender immediately by using the reply function and then permanently delete > what you have received. Any views or opinions expressed are solely those of > the author and do not necessarily represent those of Sidra Medical and > Research Center.
