Worker Analytics ist down for almost 24 hours now.
Worker Analytics ist down for almost 24 hours now.
null-values in queries?
AVG as well as the function can not calculate a proper AVG when the source data contains null valuesnull instead? IS NOT NULL still returned these values as null.cf.cacheTtl: 10 : cacheKey, but that's for Enterprise plan only.Delete from DatasetsAVGAVGIS NOT NULLSorry, we were unable to evaluate your querySELECT
AVG(avg_invocations) AS invocations
FROM
(
SELECT
blob6,
AVG(double9) AS avg_invocations
FROM
$table
WHERE
$timeFilter
AND double9 <> 0
GROUP BY
blob6
)cf.cacheTtl: 10 const res = await fetch('https://api.cloudflare.com/client/v4/accounts/{id}/analytics_engine/sql', {
method: 'POST',
headers: {
Authorization: `Bearer ${API_KEY}`,
},
cf: {
cacheTtl: 10,
cacheEverything: true,
},
body: query,
});Delete from Datasets... or (worldId = clpprgvnv0001fbcv6m28ndkc and ((t >= 1702232349 and t < 1702232352) or (t >= 1702228384 and t < 1702229575) or (t >= 1702221105) or (t >= 1702173999 and t < 1702175196) or (t >= 1702251280 and t < 1702252985) or (t >= 1702241344 and t < 1702242264) or (t >= 1702275005) or (t >= 1702180952) or (t >= 1702184092 and t < 1702185187) or (t >= 1702185193 and t < 1702188608) or (t >= 1702277945 and t < 1702281683) or (t >= 1702185189 and t < 1702185193) or (t >= 1702172903 and t < 1702173999) or (t >= 1702254745 and t < 1702258871) or (t >= 1702191878) or (t >= 1702168539) or (t >= 1702264627 and t < 1702265900) or (t >= 1702265900 and t < 1702268949) or (t >= 1702277945) or (t >= 1702232352 and t < 1702235552) or (t >= 1702171431 and t < 1702172903) or (t >= 1702182215) or (t >= 1702183141) or (t >= 1702264626) or (t >= 1702202124 and t < 1702202128) or (t >= 1702171431) or (t >= 1702242264) or (t >= 1702193522 and t < 1702194531) or (t >= 1702185187 and t < 1702185188) or (t >= 1702245960))) or (worldId = cllisd5wh0001la08gyvc3jck and ((t >= 1702183837) or (t >= 1702243546 and t < 1702243548) or (t >= 1702254549) or (t >= 1702243548) or (t >= 1702243491) or (t >= 1702220952 and t < 1702220953) or (t >= 1702272819) or (t >= 1702262251) or (t >= 1702243484))) or (worldId = cln279iow0001mj082w4li9kc and ((t >= 1702177163) or (t >= 1702171697) or (t >= 1702169331 and t < 1702170586) or (t >= 1702171697 and t < 1702177163) or (t >= 1702169330 and t < 1702169331))) or (worldId = clmv2avne0001l608fphxfdqo and ((t >= 1702174723 and t < 1702174731) or (t >= 1702174722) or (t >= 1702172510 and t < 1702174723) or (t >= 1702175810))) or (worldId = cllkfmnu70001jk08ai7kccbq and ((t >= 1702191346 and t < 1702191348) or (t >= 1702277155) or (t >= 1702193653)))