group_concat was cut when running a query on table

问题:

I have a table that looks likes this:

and this table contains 343 rows.

I'm trying to run this query on it:

create table newTest2 
select function_name, service_name, min(concurrency), substring_index(group_concat(date order by concurrency ), ',',1) as minDate, 
 max(concurrency), substring_index(group_concat(date order by concurrency desc), ',',1) as maxDate , avg(concurrency)
        from conc_intermidate
        group by function_name,service_name;

and when I run the query it gives me the : "row 203 was cut by GROUP_CONCAT()", I don't know why it's giving me this error. Please HELP! thanks...

回答1:

Thanks to RobertRozas for providing me with similar post MySQL “Row 30153 was cut by GROUP_CONCAT()” error I ran SET group_concat_max_len=15000; and the query ran perfectly.