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:[email protected]]
Office NO:
Mobile NO:
Email: [email protected]<mailto:[email protected]>
Interswitch Limited
1648C Oko-Awo Street, Victoria Island Lagos
Customer Contact Centre 0700-9065000
? http://www.interswitchgroup.com<http://www.interswitchgroup.com/>
[cid:[email protected]]<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.
