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 tpath...@sidra.org<mailto:tpath...@sidra.org> | 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.