You can configure full pushdown optimization to push an Aggregator transformation to process in Databricks Delta.
Aggregate calculations
You can perform the following aggregate calculations:
AVG
COUNT
FIRST
LAST
MAX
MIN
SUM
STDDEV
VARIANCE
Incoming ports
When you configure an Aggregator transformation and the incoming port is not used in an aggregate function or in a group by field, the output is not deterministic as the ANY_VALUE() function returns any value from the port.
You can pass only single arguments to the LAST, STDDEV, and VARIANCE functions.
ASK INFAPreview
