agg_funcs Expression Audits#

Audit notes for expressions in this category that have been audited. Absence of an entry means the expression has not been audited yet, not that it is unsupported. See the user guide Spark Expression Support for current support status.

any#

  • Spark 3.4.3 (audited 2026-05-26): registered as a SQL alias of BoolOr, which extends RuntimeReplaceableAggregate with replacement = Max(child). Catalyst rewrites any(x) to max(x) before Comet sees the plan, so any is served by CometMax on a BooleanType column.

  • Spark 3.5.8 (audited 2026-05-26): identical to 3.4.3.

  • Spark 4.0.1 (audited 2026-05-26): identical to 3.4.3.

avg#

  • Spark 3.4.3 (2026-05-26)

  • Spark 3.5.8 (2026-05-26): aggregate logic identical to 3.4.3

  • Spark 4.0.1 (2026-05-26): aggregate logic identical to 3.5.8; only QueryContext import path differs. YearMonthIntervalType and DayTimeIntervalType inputs (supported by Spark) fall back to Spark in Comet.

bit_and#

  • Spark 3.4.3 (2026-05-26)

  • Spark 3.5.8 (2026-05-26)

  • Spark 4.0.1 (2026-05-26)