MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.36


create table data (
dump_time datetime,
proc_id int,
node_id VARCHAR(20),
stats JSON
);

insert into data values
('2022-07-07 13:03:03',	9,	'NODE_IDD02',	'{"First":1,"Second":5,"Third":2}'),
('2022-07-07 13:17:35',	8,	'NODE_IDD03',	'{"First":2,"Second":3,"Third":4}'),
('2022-07-07 13:22:35',	9,	'NODE_IDD02',	'{"First":0,"Second":3,"Third":0}'),
('2022-07-07 13:03:03',	0,	'NODE_IDD01',	'{"First":0,"Second":0,"Third":5}'),
('2022-07-07 13:17:35',	8,	'NODE_IDD03',	'{"First":4,"Second":1,"Third":1}'),
('2022-07-07 13:22:35',	0,	'NODE_IDD01',	'{"First":3,"Second":3,"Third":3}');

Records: 6  Duplicates: 0  Warnings: 0


SELECT 
    MIN(data.dump_time) AS DumpTime,
    data.proc_id AS ProcId,
    data.node_id AS NodeId,
    JSON_OBJECTAGG(q.attr, q.attr_total) AS Stats
FROM (
    SELECT 
        proc_id,
        attr,
        CAST(SUM(JSON_EXTRACT(stats, CONCAT('$.', attr))) AS SIGNED)  AS attr_total 
    FROM  data
    CROSS JOIN JSON_TABLE(CAST(JSON_KEYS(stats) AS JSON), '$[*]' COLUMNS(attr VARCHAR(20) PATH '$')) t
    GROUP BY proc_id, attr
) q
JOIN data ON q.proc_id = data.proc_id
GROUP BY data.proc_id, data.node_id


DumpTime
ProcId
NodeId
Stats


2022-07-07 13:03:03
0
NODE_IDD01
{"First": 3, "Third": 8, "Second": 3}

2022-07-07 13:17:35
8
NODE_IDD03
{"First": 6, "Third": 5, "Second": 4}

2022-07-07 13:03:03
9
NODE_IDD02
{"First": 1, "Third": 2, "Second": 8}


SELECT 
    MIN(data.dump_time) AS DumpTime,
    data.proc_id AS ProcId,
    data.node_id AS NodeId,
    JSON_OBJECTAGG(q.attr, q.attr_total) AS Stats
FROM (
    SELECT 
        proc_id,
        attr,
        CAST(SUM(JSON_EXTRACT(stats, CONCAT('$.', attr))) AS SIGNED)  AS attr_total 
    FROM  data
    CROSS JOIN (VALUES ROW("First"), ROW("Second"), ROW("Third")) t(attr)
    GROUP BY proc_id, attr
) q
JOIN data ON q.proc_id = data.proc_id
GROUP BY data.proc_id, data.node_id


DumpTime
ProcId
NodeId
Stats


2022-07-07 13:03:03
0
NODE_IDD01
{"First": 3, "Third": 8, "Second": 3}

2022-07-07 13:17:35
8
NODE_IDD03
{"First": 6, "Third": 5, "Second": 4}

2022-07-07 13:03:03
9
NODE_IDD02
{"First": 1, "Third": 2, "Second": 8}

DumpTime	ProcId	NodeId	Stats
2022-07-07 13:03:03	0	NODE_IDD01	{"First": 3, "Third": 8, "Second": 3}
2022-07-07 13:17:35	8	NODE_IDD03	{"First": 6, "Third": 5, "Second": 4}
2022-07-07 13:03:03	9	NODE_IDD02	{"First": 1, "Third": 2, "Second": 8}