You can translate the question and the replies:

AGGREGATION PUSH DOWN ON CSV

I have a final UNION view between views with group by that have as data source a CSV file (so there is no database as source). When I execute the query on the union in the execution trace appears that an AGGREGATION PUSH-DOWN was done. But the push down is possible on CSV file? I though the push down was able only on database (such an oracle data source), why it is shown in this case in the optimizations? I hope I was clear in my explanation, Thanks
data aggregation Optimization static optimization
user
18-01-2024 04:57:46 -0500
code

1 Answer

Hi, In general, Denodo tries to push down the group by operation to the underlying JDBC data source, if you are projecting **aggregation functions** such as COUNT, MIN, MAX or SUM functions. If I see Aggregation pushdown in the execution trace for non-relational sources such as delimited or excel files, I would see if [Cache](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cache_module/cache_module) has been enabled for the respective views. If the view is configured with a JDBC datasource as cache, then Aggregation push down is possible in that case. Hope this helps!
Denodo Team
23-01-2024 06:52:27 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here