Latest Activity

code

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 do...

static optimization data aggregation Optimization

code

No delegation cause: "The function 'case' cannot be delegated to this database"

Dear Denodo team, i created a view using a single table from a datasource (no joins). It is basically aggregating, filtering by a where condition, as well as doing some minor transformations and functions (cast, to timestamp, trim, case, now). The fil...

static optimization pushdown