You can translate the question and the replies:

Query to AWS Athena

Do the Denodo query optimizations (aggregation pushdown etc) works with AWS Athena?
01-06-2020 08:56:53 -0400

1 Answer

Hi, As Amazon Athena is a [JDBC data source]( and also it has its own [database adapter](, then the Execution Engine will perform optimizations based on the **scenario** and **types** of queries. However, the Execution Engine will optimize the queries only if the optimization is enabled in the Server Configuration of Virtual DataPort. Hence, I would make sure that I have enabled Queries optimization in the Server Configuration. You could refer to the [Queries Optimization]( section under the Virtual DataPort Administration Guide for more details. Also, I suggest you to refer the Knowledge Base (KB) article [Best Practices to Maximize Performance II: Configuring the Query Optimizer]( which explains more about the Query Optimizer. Hope this helps!
Denodo Team
02-06-2020 08:04:38 -0400
You must sign in to add an answer. If you do not have an account, you can register here