Query exhausted resources at this scale factor

问题:

I was running SQL query on Amazon Athena. And I got the following error couple of times:

Query exhausted resources at this scale factor

This query ran against the "test1" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: *************

回答1:

We also encountered this. We noticed that this might be an internal Amazon issue. Whenever we encounter this error specially for very fast queries, we just try to delete the table and create it again. I know its a bit stupid answer and I wish I can give more details. Our guess is that we are assigned on an instance with low resources and creating the table again will give you the chance to be assigned to a better one.