drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tushar Pathare <tpath...@sidra.org>
Subject Drill queries not getting executed-son profile for queries not created
Date Mon, 09 Oct 2017 08:05:50 GMT
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
tpathare@sidra.org<mailto:tpathare@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.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message