Function string_agg() in dremio

1

Hey Community,

Does dremio now support string_agg() function. And if not, is there any work around anyone has implemented.

Thank you,
Samson

2

@iskidet Currently Dremio does not support string_agg()

3

@iskidet , you can write your own!
Just add into StringFunctions.java something like this

  @FunctionTemplate(name = "string_agg", scope = FunctionTemplate.FunctionScope.POINT_AGGREGATE)
  public static class StringAgg implements AggrFunction

Implement all needed methods and register this function in ServerMetaProvider.java

  private static final ServerMeta DEFAULT = ServerMeta.newBuilder()
        .addStringFunctions("string_agg")
4

@iskidet, did you find any solution?

5

Found a way to do this. Posted in a similar thread Function string_agg() postgresql data base - #7 by donatobarone