drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Padma Penumarthy <ppenumar...@mapr.com>
Subject Re: Drill queries not getting executed-son profile for queries not created
Date Mon, 09 Oct 2017 14:40:45 GMT
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 <tpathare@sidra.org> 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
> 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
View raw message