Function string_agg() postgresql data base

Hi guys !!!

Is there any alternative to using the “string_agg” function from postgresql database in dremio?

Example below:

SELECT string_agg(PARECER_CONSULTOR, ’ - ')
FROM PESQUISA.PLANO_TRABALHO
WHERE ID_CONSULTOR = 7054310

Dremio Functions : https://docs.dremio.com/sql-reference/sql-functions/

Dremio has a bunch of String and Aggregation functions, does not have anything that will implement Postgress string_agg equivalent out of the box : https://www.postgresqltutorial.com/postgresql-aggregate-functions/postgresql-string_agg-function/

Is there any way that a loop can create over query so multiple records can be set separated with comma?

@munish.singla

Currently Dremio does not support equivalent of an Oracle PL/SQL. Direct ANSI SQL is what is supported

Thanks
Bali

Thanks for reply @balaji.ramaswamy
Is there any way I can create a loop to generate that kind of required resultset?

Thanks
Munish

@munish.singla

As I had mentioned, Dremio does not support loops inside the SQL construct

Thanks