microblame l3.session.sql

--@block
SELECT
		statementHash,

arraySort(
    arrayMap(
        (x, y) -> (x, y),
        (arrayReduce(
            'sumMap',
            [(groupArrayArray([prismaSpan]) as arrPrismaSpan)],
            [arrayResize(CAST([], 'Array(UInt64)'), length(arrPrismaSpan), toUInt64(1))]
        ) as sPrismaSpan).1,
        sPrismaSpan.2
    )
) as sorted_rPrismaSpan
		--arrayDistinct(groupArray(prismaSpan)) AS distinctPrismaSpans
	FROM
		traced_queries
	GROUP BY
		statementHash;


--@block oldest row
SELECT
		*
	FROM
		traced_queries
	ORDER BY
		timestamp ASC
	LIMIT 1;