Fix the data type of requests.summary.respBodySize

[IvanUkhov]

It is supposed to be integer, but there are occasional strings set to null. It should be just JSON null.

[max-ostapenko]

@IvanUkhov please help with how to reproduce these cases.

[IvanUkhov]

I am still getting “The provided JSON input is not an integer” for this:

SELECT INT64(summary.respBodySize)
FROM `httparchive.crawl.requests`
WHERE date = '2025-07-01'

This shows what is happening:

SELECT TO_JSON_STRING(summary.respBodySize), JSON_TYPE(summary.respBodySize), COUNT(*)
FROM `httparchive.crawl.requests`
WHERE date = '2025-07-01' AND SAFE.INT64(summary.respBodySize) IS NULL
GROUP BY 1, 2

So I suppose it is due to the second row in the picture, that is, JSON nulls, not JSON strings equal to “null.” Maybe I originally misinterpreted, or maybe something has changed since then. In any case, the conclusion is that one should use SAFE.INT64.

Thank you for looking into this!