Skip to content

Allow to filter null in array_agg #13742

@rluvaton

Description

@rluvaton

Is your feature request related to a problem or challenge?

Yes, I want nulls to be filtered from array_agg when I specify with_ignore_nulls: true in AggregateExprBuilder to have behavior similar to Spark, this should also work when with_distinct is false or true

Describe the solution you'd like

Specifing with_ignore_nulls: true should ignore

Describe alternatives you've considered

  1. Adding a filter for removing nulls to the child before creating the array_agg
  2. Copy the implementation and added in myself as an UDAF

Additional context

This PR might be relevant:

I'm willing to open a pull request

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions