drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Edike <peter.ed...@interswitchgroup.com>
Subject This query is so slow
Date Mon, 06 Aug 2018 16:00:53 GMT
Hello all,

The following query takes ages to complete in drill and more often that not, fails

select * from dfs.`/iswdata/rj/201805` where unique_key in
    (
         select unique_key from dfs.`/iswdata/rj/201805` group by unique_key having count(unique_key)
> 1
    )
limit 40

Please what can I do to improve the performance of this query

Kind Regards

________________________________
Peter Edike
Senior Software Engineer
Research and Development, ENG
Engineering
[cid:image001.png@01D42DA7.101866D0]
Office  NO:
Mobile NO:
Email: peter.edike@interswitchgroup.com<mailto:peter.edike@interswitchgroup.com>
Interswitch Limited
1648C Oko-Awo Street, Victoria Island Lagos
Customer Contact Centre 0700-9065000
? http://www.interswitchgroup.com<http://www.interswitchgroup.com/>
[cid:image003.png@01D42DA7.101866D0]<https://www.quickteller.com/loan-request>
This e-mail and all  attachments transmitted with it remain the property of Interswitch Limited
, the information contained herein  are private  confidential and intended solely for the
use of the addressee. If you have received this e-mail in error, kindly notify the sender.
If you are not the addressee, you should not disseminate, distribute or copy this e-mail.
Kindly notify Interswitch immediately by email if you have received this email in error and
delete this email and any attachment from your system  Emails cannot be guaranteed to be secure
or error free as the message and any attachments could be intercepted, corrupted, lost, delayed,
incomplete or amended. the contents of this email or its attachments have been scanned for
all viruses and all reasonable measures have been taken to ensure that no viruses are present.
Interswitch Limited and its subsidiaries do not accept liability for damage caused by this
email or any attachments.

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message