New Aggregate Function: groupArrayIntersect

Why it matters

This feature solves the problem of efficiently finding common elements across arrays within grouped data, enabling users to perform intersections during aggregation operations. It simplifies queries where users need to identify shared elements across grouped arrays without manual processing.

How to use it

Use the groupArrayIntersect aggregate function in your queries by applying it to an array column within a GROUP BY context. For example:

SELECT key, groupArrayIntersect(array_column) FROM table GROUP BY key