v.23.7New Feature
Add array_concat_agg function for BigQuery compatibility
Add aggregate functionarray_concat_aggfor compatibility with BigQuery, it's alias ofgroupArrayArray. Closes #52139. #52149 (flynn).
Why it matters
This feature introduces thearray_concat_agg aggregate function to improve interoperability with BigQuery by offering a familiar function name that behaves identically to groupArrayArray. It helps users migrating queries or integrating systems that rely on BigQuery's syntax, simplifying the transition and usage.How to use it
Use thearray_concat_agg aggregate function in your SELECT queries just like any other aggregate function. Since it is an alias of groupArrayArray, no additional setup or configuration is required. Example usage:SELECT array_concat_agg(column_name) FROM table_name;