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.
