Group_concat emulation

Is there a simple solution to emulate the GROUP_CONCAT function from MySQL in crate 3.3 to concatinate the values of a string column when using GROUP BY as in:

SELECT column_a,GROUP_CONCAT(column_b,',')
FROM "some_db"."some_table"  
GROUP BY column_a

hi rene, sorry string_agg was only introduced with 4.0.

Thank you joemoe.
I was just hoping that there was some clever workaround, but now I will do the query without the group by and and do the grouping at the client.

upgrading cratedb to a newer version is not an option?
that’s not the only benefit you’d get. :slight_smile: