A
JAA
When can we expect pricing? Really want to scale it up more to billions...
MA
U
A
doubletimestampAlternatively, if you need to be very accurate, maybe you can filter using both columns? You could increase the range on the timestamp one slightly, if needed.That sounds like the best solution for now. I know for sure the real timestamp won't be larger than the datapoint's, and, unless there's an issue with Logpush, the datapoint will be written within a couple of minutes of the event.
AA
AA
Agood wayIs there a bad way to do it?
AA
blobdouble
A
JJWe recommend the use of the Altinity plugin for Clickhouse for querying Workers Analytics Engine from Grafana.
J
T
ECloudflare API in Pages Functions may also have been affected returning intermittent 500 errors.Thanks for the report @thomas_sc
A fix has been implemented and we are monitoring the results.
-- The original timestamp is stored in double12 as UNIX nano
SELECT
(intDiv(intDiv(double12, 1000000000), $interval) * $interval) * 1000 as ts,
sum(_sample_interval) AS events
FROM honeypot_spectrum_events
WHERE
-- Use the indexed timestamp to retrieve rows written between $from and $to + 15 minutes
timestamp >= toDateTime($from) AND timestamp < toDateTime($to + 900) AND
-- Use the original timestamp to retrieve events that occurred between $from and $to
double12 >= ($from * 1000000000) AND double12 < ($to * 1000000000)
GROUP BY ts ORDER BY ts-- The original timestamp is stored in double12 as UNIX nano
SELECT
(intDiv(intDiv(double12, 1000000000), $interval) * $interval) * 1000 as ts,
double9 as originPort,
sum(_sample_interval) AS events
FROM honeypot_spectrum_events
WHERE
-- Use the indexed timestamp to retrieve rows written between $from and $to + 1 day
timestamp >= toDateTime($from) AND timestamp <= toDateTime($to + 86400) AND
-- Use the original timestamp to retrieve events that occurred between $from and $to
double12 >= ($from * 1000000000) AND double12 <= ($to * 1000000000)
GROUP BY ts, originPort ORDER BY ts