Good question. There are limits on the max query execution time (30 minutes) and the number of parallel queries that can be executed at the same time.
There is a separate page about service limits here: https://docs.aws.amazon.com/athena/latest/ug/service-limits....