We started by testing the normal scan speed of the data set. The same query was executed in both the environments. With a simple where clause, we tried to filter out rows from the data set. Athena gave the best results, completing the scan in just 2.53 sec compared to 41.35 sec in Redshift.18 abr 2017
Is AWS Athena fast?
Query Run time
------- ----------
Speedup 98% faster
How much faster is redshift?
Performance matters: Amazon Redshift is now up to 3.5x faster for real-world workloads. Since we launched Amazon Redshift, thousands of customers have trusted us to get uncompromising speed for their most complex analytical workloads.1 nov 2018
Can Athena write to Redshift?
Athena natively supports the AWS Glue Data Catalog. The AWS Glue Data Catalog is a data catalog built on top of other datasets and data sources such as Amazon S3, Amazon Redshift, and Amazon DynamoDB. You can also connect Athena to other data sources by using a variety of connectors.
What is AWS glue Athena?
AWS Glue is a fully managed ETL (extract, transform, and load) AWS service. One of its key abilities is to analyze and categorize data. ... Athena uses the AWS Glue Data Catalog to store and retrieve table metadata for the Amazon S3 data in your Amazon Web Services account.
Is Athena a data lake or warehouse?
Using Athena allows you to query large volumes of data stored in a data lake on Amazon S3; and since this storage costs a fraction of what you would pay to store the same data in a data warehouse, you can work with higher volumes of data without concern.3 may 2020