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