Sql GROUP_CONCAT equivalent function in DREMIO?

1

Hi,

In one of our dashboards, we use ‘group_concat’ function in Impala to concat distinct strings with group by, but it doesn’t work in Dremio.
Can someone help if there is any group_concat similar function available in Dremio?

Below is how group_concat in Impala works:
ID FullName

(1, ‘Matt’),
(1, ‘Rocks’),
(2, ‘Stylus’),
(3, ‘Foo’),
(3, ‘Bar’),
(3, ‘Baz’)

ID FullName

1 Matt, Rocks
2 Stylus
3 Bar, Baz, Foo

Thanks,
Ajay

1 Like
3

@Akuqk Currently no, there is an open enhancement request to add this function but currently no ETA

4

Ok. Thanks for the response.

5

you can define this agg function by your self。
AggStringConcatOp.zip (1.1 KB)

6

Thanks for this!
Does this require building Dremio from source?
Or is there some way to drop a compiled Java object into an existing Dremio instance?

7

@junphine How to use this function?