![]() Amazon caught up with version 0.217 only in Nov 2020. Feature delays: Presto is evolving at an expedited rate, with new performance features, SQL functions, and optimizations being contributed by the community as well as companies such as Facebook, Alibaba, Uber, and others periodically.Security: In spite of having access controls via IAM and other AWS security measures, some customers simply want better control over the querying infrastructure and choose to deploy a solution that provides better manageability, visibility, and control.This visibility is important from a query tuning and consistency standpoint and even to reduce the amount of data scanned in a query. You have no visibility into the underlying infrastructure or even into the details as to why the query failed or how it’s performing. Visibility and Control: There are no knobs to tweak in terms of capacity, performance, CPU, or priority for the queries.If however, your datasets are large in the order of hundreds or thousands of queries, scanning over terabytes or petabytes of data Athena may not be the most cost-effective choice. If your datasets are not very large, and you don’t have a lot of users querying the data often, Athena is the perfect solution for your needs. Cost per query: Athena charges based on Terabytes of data scanned ($5 per TB).Query concurrency can be challenging due to limits imposed on accounts to avoid users from overwhelming the regional service. If too many users leverage the service at the same time in a region, users across the board start seeing query queuing and latencies. Performance consistency: Athena is a shared, serverless, multi-tenant service deployed per-region.There are various reasons users look for alternative options to Athena, in spite of its advantages: Athena (engine 2) also provides federated query capabilities, which allows you to run SQL queries across data stored in relational, non-relational, object, and custom data sources. Amazon Athena is great for interactive querying on datasets already residing in S3 without the need to move the data into another analytics database or a cloud data warehouse. Athena is serverless, so there is no infrastructure to manage. What is AWS Athena?ĪWS Athena is an interactive query service based on Presto that makes it easy to analyze data in Amazon S3 using standard SQL. In this blog post, we’ll compare Athena with each of these other options to help you make the best decision for your data. There are a number of other alternatives that you might want to consider, including serverless options such as Ahana or Presto, as well as cloud data warehouses.Įach of these tools has its own strengths and weaknesses, and really the best choice depends on the data you have and what you want to do with it. In this blog post, we’ll explore some of the best AWS Athena alternatives out there.Īthena is a great tool for querying data stored in S3 – typically in a data lake or data lakehouse architecture – but it’s not the only option out there. ![]() If you’re looking for Amazon Athena alternatives, you’ve come to the right place. ![]() ![]() PrestoDB Blog Series: Athena Partition Limits PrestoDB Blog Series: Athena Query Limits If you missed the others, you can find them here: This is the 4th blog in our comparing AWS Athena to PrestoDB series. Get better price/performance and regain control over your cloud infrastructure with Ahana’s managed Presto solution for AWS. Looking for Athena alternatives? Ahana gives you the scale and performance of PrestoDB – the same underlying technology that powers Athena, and which is used for petabyte-scale analytics at Meta and Uber – with none of the limitations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |