By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
set @temp = '[{"keyId": "aded5b0107bb5a936604bcb6f", "keyNames": ["abc1, abc2, abc3, abc4"], "keyDesc": "test"}]';
SELECT j.keyId, group_concat(distinct j.keyNames) as keyNames, j.keyDesc
FROM JSON_TABLE(@temp, '$[*]'
COLUMNS(
keyId TEXT PATH '$.keyId',
NESTED PATH '$.keyNames[*]' COLUMNS (keyNames TEXT PATH '$'),
keyDesc TEXT PATH '$.keyDesc')
) AS j
group by j.keyId, j.keyDesc;
| keyId | keyNames | keyDesc |
|---|---|---|
| aded5b0107bb5a936604bcb6f | abc1, abc2, abc3, abc4 | test |