Hi,
If you go to
https://boto3.readthedocs.io/en/latest/reference/services/athena.html#Athena.Client.get_waiter
looks like that feature is not implemented.
I have a lambda function which executes Athena queries. I use a function called start_query_execution() in boto3 and I need to write a loop to check if the execution is finished or not, so I think it will be awesome if we have waiter feature implemented in Athena.
Thanks
xysr89
All 38 comments
Marking this as a feature request. Thanks for your input!
joguSD
on 10 Aug 2017
Any updates on this?
kriskavalieri
on 18 Oct 2017
+1
oassif-oa
on 5 Nov 2017
+1
Tahrima
on 20 Nov 2017
+1
CM-Kajiwara
on 4 Dec 2017
Isn't this implemented yet?
priyanshuchandra
on 11 Dec 2017
+1
matohin
on 15 Jan 2018
+1
danielhaviv
on 5 Feb 2018
+1
Harshasai
on 14 Mar 2018
+1
mrtj
on 22 Mar 2018
Has anyone written one of these? Looks like just a matter of calling start_query_execution() which returns a QueryExecutionId then calling get_query_execution() with that QueryExecutionId until the status is one of the 'SUCCEEDED', 'FAILED', 'CANCELLED'
Probably with some delays between polling. Is there anything else to consider?
Hopefully this will be added to Boto3 soon
ghost
on 26 Mar 2018
@davoscollective Thats how https://github.com/guardian/athena-cli works.
See: https://github.com/guardian/athena-cli/blob/master/athena_cli.py#L37
tomvachon
on 26 Mar 2018
@tomvachon thanks for the link I wasn't aware of that one, super helpful.
ghost
on 26 Mar 2018
There is a pull request for this feature (boto/botocore#1358) open for this feature since 2018-01-09. Would be great to get it merged!
alewando
on 27 Jun 2018
+1
vivekvaidya
on 9 Jul 2018
+1
LJBD
on 11 Jul 2018
+1
HyeongGun
on 25 Jul 2018
+1
tadaskrisciunas
on 8 Aug 2018
+1 for sure
tomkoshy999
on 8 Aug 2018
+1
GuillaumeGomez
on 20 Aug 2018
+1
chunleng
on 30 Aug 2018
+1
nategranatir
on 31 Aug 2018
+1
GrigoriiKushnir
on 7 Sep 2018
+1
jdonadel
on 30 Nov 2018
+1
jaronoff97
on 5 Feb 2019
+1
OlegZhukov
on 8 Feb 2019
+1
Tan4ek
on 12 Feb 2019
+1
farridav
on 21 Mar 2019
+1
mike-thompson-day8
on 4 May 2019
+1
scottdear
on 10 Jul 2019
+1
y0m1g
on 17 Jul 2019
+1
mfarago
on 31 Jul 2019
+1
andypmw
on 14 Aug 2019
+1
smilesvua
on 28 Aug 2019
Could we at least remove this reference from the boto3 docs if it's not going to be implemented?
It's confusing to have this comment "See the waiters section of the service docs for a list of available waiters." when that list doesn't appear to exist.
griffinator76
on 16 Sep 2019
Is this necessary, if one can use the S3 waiter for the output file created by the query execution?
marias0l
on 3 Jun 2020
Hi @marias0l, the doc of S3.Waiter.ObjectExists states that the s3 waiter “Polls S3.Client.head_object() every 5 seconds until a successful state is reached. An error is returned after 20 failed checks”. It is very probable that an Athena query lasts longer than 100 seconds so I guess this approach won’t work.
mrtj
on 4 Jun 2020
That can be configured with WaiterConfig like:
waiter.wait(
Bucket='string',
WaiterConfig={
'Delay': 123,
'MaxAttempts': 123
}
)
marias0l
on 5 Jun 2020
Related issues
raolivei
·
3Comments
amattie
·
4Comments
jarruda
·
3Comments
rabinnh
·
3Comments
arnonki
·
3Comments
Most helpful comment
Could we at least remove this reference from the boto3 docs if it's not going to be implemented?
It's confusing to have this comment "See the waiters section of the service docs for a list of available waiters." when that list doesn't appear to exist.