September 7, 2022 release notes#

OPAL#

array_agg_distinct() and string_agg_distinct()#

These aggregating functions allow you to get the unique values in a set of items. This is useful for ad hoc analytics such as identifying unique error messages, IDs, or IP addresses.

array_agg_distinct() returns an array with the results and string_agg_distinct() a string with items separated by a string delimiter of your choice. Note that the order is nondeterministic and these functions do not accept an order_by() argument.