Miki Mokrysz | Analytics Engine
05/09/2023, 7:18 PMAdvany
05/12/2023, 8:48 AMTim Fish
05/18/2023, 10:35 AMsdan
05/19/2023, 8:38 AMconst dataPoint = {
'indexes': [`${request.headers.get('CF-Connecting-IP')}`],
'blobs': [
[host, path, JSON.stringify(requestBodyJson)],
[
request.cf.colo,
request.cf.country,
request.cf.city,
request.cf.region,
request.cf.timezone,
request.headers,
],
[
response.status,
response.headers,
]
],
};
console.log('Data to be written:', JSON.stringify(dataPoint, null, 2));
env.<dataset name>.writeDataPoint(dataPoint);
i assumed you can't have multiple indexes but apparently you can... curious what others are doingSkye
05/19/2023, 9:05 PMsql
SELECT
blob1 AS colo,
SUM(_sample_interval) AS count1
FROM 'colo-tracker'
WHERE $timeFilter
GROUP BY colo, count1
ORDER BY count1
Not sure if there's an particular reason why?PaganMuffin
05/19/2023, 9:09 PMDani Foldi
05/19/2023, 9:10 PMSkye
05/19/2023, 9:10 PMSkye
05/19/2023, 9:11 PMCyb3r-Jok3
05/20/2023, 2:33 PMLeo
05/20/2023, 3:58 PMCyb3r-Jok3
05/20/2023, 5:31 PMIann
05/21/2023, 11:58 AMjohn.spurlock
05/21/2023, 11:37 PMselect if(startsWith(blob3, 'www.'), substring(blob3, 5), blob3) hostname, min(blob2) sample_url, count() c from 'the-dataset' where index1 = 'the-index' group by hostname order by c desc format tsv
but fails with:
Input was invalid: cannot use the String type as argument 1 in min("blob2")
Walshy | Pages
05/21/2023, 11:40 PMjohn.spurlock
05/21/2023, 11:41 PMUnsmart | Tech debt
05/22/2023, 12:18 AM.Zero
05/22/2023, 6:39 AMJim | Data
05/22/2023, 7:19 AM<
, >
, <=
, >=
went live last week. Sorry, I forgot to post here.
I'm afraid that doesn't help with min(string)
.Jim | Data
05/22/2023, 7:27 AMjohn.spurlock
05/22/2023, 1:19 PMjohn.spurlock
05/22/2023, 1:20 PMIann
05/24/2023, 1:52 AMWalshy | Pages
05/24/2023, 2:02 AMIann
05/24/2023, 2:21 AMWalshy | Pages
05/24/2023, 2:24 AMsdan
05/24/2023, 3:38 AMhttps://cdn.discordapp.com/attachments/981314061268578304/1110773894203310090/Screenshot_2023-05-23_at_8.37.38_PM.pngâ–¾
dust
05/24/2023, 4:47 AMHardAtWork
05/24/2023, 5:54 AMcharl
05/27/2023, 7:56 AM