Group_concat emulation

CrateDB SQL
1

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
LIMIT 10;
2

hi rene, sorry string_agg was only introduced with 4.0.
https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/4.0.0.html?highlight=string_agg#sql-standard-and-postgresql-compatibility-improvements
https://crate.io/docs/crate/reference/en/latest/general/builtins/aggregation.html#string-agg

3

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.

4

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