- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
Hi jaldons,
David here from AWS. I'm a Premium Support engineer from the Big Data team, working with EMR, Athena and other related services.
The Athena team recently deployed a host of new functionality for Athena, including more granular CloudWatch metrics for Athena queries.
For more information:
AWS What's New page: https://aws.amazon.com/about-aws/whats-new/analytics/?whats-new-content.sort-by=item.additionalFields.postDateTime&whats-new-content.sort-order=desc&awsf.whats-new-products=general-products%23amazon-athena
Athena docs on CloudWatch metrics: https://docs.aws.amazon.com/athena/latest/ug/query-metrics-viewing.html
As part of the deployment of more granular metrics, Athena now includes a "QUEUED" status for queries. This status indicates that an Athena query is waiting for resources to be allocated for processing. Query flow is roughly:
SUBMITTED -> QUEUED -> RUNNING -> COMPLETED/FAILED
Note that queries that fail due to system errors can be put back into the queue and retried.
I apologise for the frustration that this change has caused.
It seems like the forum formatting has stripped some elements from your code snippets.
However, I think that your WHILE loop is working on an array of the possible query statuses, which didn't previously cater for "QUEUED".
If that is the case, then yes, adding "QUEUED" to that array will allow your application to handle the new status.
Is this affecting a production system in your environment?
Please feel free to message me privately with more details, and I can see what I can do to help you.
Kind regards,
David F.
Thanks for that - at least it means i'm not going crazy! Is there some way in which these sort of changes are communicated normally? Luckily the particular API's i'm dealing with aren't in production yet but it would have been disastrous if we were a month further along... luckily it's an easy fix but knowing before it breaks would be preferable
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa