analytics is exposed but not ``dataImpressions``

analytics is exposed but not

dataImpressions

dataImpressions

dataImpressions

dataImpressions

AriesOP•8/22/23, 2:12 AM

Very weird.

AAries analytics is exposed but not ``dataImpressions``

Victor•8/22/23, 2:14 AM

Going to https://dash.cloudflare.com/<account id>/workers/analytics-enginehttps://dash.cloudflare.com/<account id>/workers/analytics-engine, do you see stats?

AriesOP•8/22/23, 2:14 AM

Only the old dataset.
https://files.aries.fyi/2023/08/21/firefox_1e1881fe7a266c61.png

AriesOP•8/22/23, 2:16 AM

When uploading, it does not acknowledge it at all.
https://files.aries.fyi/2023/08/21/Code_9957cb0c3fb79cea.png

VVictor Going to `https://dash.cloudflare.com/<account id>/workers/analytics-engine`, do...

AriesOP•8/22/23, 2:17 AM

Weird..

AriesOP•8/22/23, 2:17 AM

And when deployed:
https://files.aries.fyi/2023/08/21/firefox_e676d010ecf6d878.png

VVictor ```toml analytics_engine_datasets = [ { binding = "TRACKING_CLOUDFLARE_REQUE...

AriesOP•8/22/23, 2:34 AM

Copying your syntax exactly doesn't register them, but doing it this way does: https://files.aries.fyi/2023/08/21/Code_a16a743b078b69f7.png

AriesOP•8/22/23, 2:35 AM

dataset not dataset_name as well, my bad.

AAries Copying your syntax exactly doesn't register them, but doing it this way does: h...

Victor•8/22/23, 2:36 AM

My syntax is setup for multiple environments, that probably why it's not picking up

AriesOP•8/22/23, 2:49 AM

Is 25 writes (writeDataPoint invocations) per client HTTP request25 writes (writeDataPoint invocations) per client HTTP request a hard limit?

chientrm.com•8/22/23, 3:49 AM

is analytics engine available on free plan?

AAries Is ``25 writes (writeDataPoint invocations) per client HTTP request`` a hard lim...

Victor•8/22/23, 5:16 AM

I don't know of any limits

Elliot Hesp•8/22/23, 3:20 PM

If I'm wrapping analytics engine in an ORM, what flavour of SQL is it using?

EElliot Hesp If I'm wrapping analytics engine in an ORM, what flavour of SQL is it using?

John Spurlock•8/22/23, 3:21 PM

it's a subset of clickhouse: https://clickhouse.com/docs/en/sql-reference

AriesOP•8/24/23, 6:24 AM

In the SQL, how would I say give me the top 100, then group the rest as "Other"?

AriesOP•8/24/23, 6:25 AM

https://files.aries.fyi/2023/08/24/firefox_469e36f8aac75ae2.png

AAries In the SQL, how would I say give me the top 100, then group the rest as "Other"?

DaniFoldi•8/24/23, 7:04 AM

In SQL, you can use a statement like below

SELECT id, ...,
CASE
  WHEN id <= 100 THEN id
  ELSE 'Other'
END AS groupedId
FROM myTable

SELECT id, ...,
CASE
  WHEN id <= 100 THEN id
  ELSE 'Other'
END AS groupedId
FROM myTable

However, I'm not sure if clickhouse/AE supports that as I haven't played around with it too much yet, so if it doesn't work you're likely best selecting the top 100, and summing the rest "manually" in subqueries

itsmatteomanf•8/31/23, 12:46 PM

Is there a way to get more than the default 25 ingestions per invocation? I have a queue that processes 100 items which need to push things a few things to AE per item.

itsmatteomanf•8/31/23, 1:58 PM

Oh, I read now... maybe I should ping @46bit

John Spurlock•8/31/23, 9:28 PM

having used AE from basically day 1, you definitely have to deal with pretty much every 5xx5xx error in the book coming back, and retry-after-delay. Most of these errors are either one-offs or transient

pigri•9/1/23, 7:22 AM

Hmm... anybody else who also has experience with analytics_engine is not working? My grafana dashboards are down and I can see this error: Sorry, we were unable to evaluate your querySorry, we were unable to evaluate your query

Jjimh Hi @.pigri - can you post an example of a query that returns this error?

pigri•9/1/23, 8:29 AM

Sure,
SELECT
timestamp AS t,
*
FROM
usageDataOutput
WHERE
t >= NOW() - INTERVAL '1' DAY
ORDER BY t

pigri•9/1/23, 8:29 AM

2 days ago this query is worked

pigri•9/1/23, 9:26 AM

Thank you! We try to figure out who can fix it.

Jjimh I searched through errors on our end based on a hunch and I'm pretty sure the is...

Kasumi•9/1/23, 9:53 AM

Sorry for disturbing but does it mean that cf cuts the responses off as soon as the response hits 100mb or is it just analytics-engine ?

Jjimh The quickest way to reduce response size for this query will be to remove the `*...

pigri•9/1/23, 10:52 AM

Thank you we fixed it!

Unsmart•9/1/23, 3:58 PM

Any new plugin we should be using since I guess the altinity plugin thats recommended is using legacy stuff and will eventually break unless they are working on updating it maybe

Jjimh It looks like they're aware: https://github.com/Altinity/clickhouse-grafana/issu...

itsmatteomanf•9/1/23, 5:22 PM

It’s been open since March 22… doesn’t feel like it’s really moving along

AriesOP•9/4/23, 8:02 AM

Does this support prepared statements?

AriesOP•9/4/23, 8:02 AM

I cannot seem to find any references.

AAries Does this support prepared statements?

itsmatteomanf•9/4/23, 8:03 AM

In the sense that you save them prior to calling them or you do pepare them in your code prior to sending them, and then call them directly like D1 does?