The main limitation I've found with Athena is that it's still based on Presto 0.172 (from April 2017) so is missing a bunch of functions and enhancements from subsequent releases. I've also found that it's not too hard to run into scalability issues where very large queries will intermittently fail due to lack of resources.
On the other hand it is incredibly simple to set up and much easier than running a standalone Presto cluster, and a lot cheaper than a decent Redshift cluster!
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
The main limitation I've found with Athena is that it's still based on Presto 0.172 (from April 2017) so is missing a bunch of functions and enhancements from subsequent releases. I've also found that it's not too hard to run into scalability issues where very large queries will intermittently fail due to lack of resources.
On the other hand it is incredibly simple to set up and much easier than running a standalone Presto cluster, and a lot cheaper than a decent Redshift cluster!