group_concat() multi columns OOM

[16601746291]

when i execute sql that model like :
select column01, group_concat(column02, ',' order by update_time desc) as new columnA
,new columnB
,new columnC
,new columnD
,......
,new columnZ
from table
group by column01

total 22 columns ,like this:

result OOM，How to optimize script statement?

[yagagagaga]

I need more information to help you:

1. What is your Doris version?
2. Can you provide the profile of this case? You can enable profile by executing this sql SET enable_profile=true;. For more information about profile, you can see SHOW-QUERY-PROFILE
3. Can you provide the table DDL?