Error querying database. Cause: java.sql.SQLException: Row 28 was cut by GROUP_CONCAT()
created at 11-16-2021
views: 4
reason¶
Insufficient length causes
solution¶
##Set size
SET GLOBAL group_concat_max_len=10240000;
SET SESSION group_concat_max_len=10240000;
##or
SET GLOBAL group_concat_max_len=-1; - Maximum
SET SESSION group_concat_max_len=-1 ;--- maximum
##verify
select @@global.group_concat_max_len;
#or
show variables like'group_concat_max_len';
Restart after setting
