Complex Joins or Inner Queries are better supported by Redshift due to its computational capacity. Because Athena's charges are based on the amount of data scanned in each query, it would be considerably cheaper if the data sets are compressed.18 abr 2017
Is red shift free?
In order to provide the best customer experience, Redshift is now only available as a subscription product.
Is redshift faster than Athena?
Redshift is more expensive as you are paying for both storage and compute, compared to Athena's decoupled architecture. A highly optimized Redshift cluster with sufficient compute resources will most likely return results faster than the same query in Athena.30 oct 2019