Copying your syntax exactly doesn't register them, but doing it this way does: https://files.aries.f

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

25 writes (writeDataPoint invocations) per client HTTP request

25 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

5xx

5xx

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 query

Sorry, 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?

Iitsmatteomanf In the sense that you save them prior to calling them or you do pepare them in y...

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

To prevent SQL injection, where you can pass values seperately from the query.

AAries To prevent SQL injection, where you can pass values seperately from the query.

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

Yeah, then no, it's a REST api, there is no direct binding for querying it.
https://developers.cloudflare.com/analytics/analytics-engine/worker-querying/#worker-script

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

It would be nice if the REST API accepted a body like {sql: string, values: string}{sql: string, values: string} so that wouldn't be an issue.

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

https://files.aries.fyi/2023/09/04/Code_6e32d17f8bd23031.png

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

https://files.aries.fyi/2023/09/04/Code_3490596e08bdb62c.png

riskiidrus•9/5/23, 5:03 AM

Hi, can I know how long my and my customers' analytics data is stored?

I just want to make sure that the data can still be accessed for a long time.

Erisa•9/5/23, 5:34 AM

3 months at the moment https://developers.cloudflare.com/analytics/analytics-engine/get-started/#data-retention

AriesOP•9/6/23, 12:23 AM

why does

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

end up as a string?

AriesOP•9/6/23, 12:23 AM

https://files.aries.fyi/2023/09/05/Code_f04483f7b576c9d4.png

AriesOP•9/6/23, 12:41 AM

same with toUnixTimestamp(timestamp) * 1000toUnixTimestamp(timestamp) * 1000

AriesOP•9/6/23, 12:42 AM

I assume because it doesn't fit in a 32int but still, pretty weird.

Original message was deleted

AriesOP•9/6/23, 12:47 AM

?? 16938009000001693800900000 is a perfectly valid js number.

Unsmart•9/6/23, 12:48 AM

A Uint64 can contain more precise numbers than js numbers can though so all the Uint64 will be string and you can look at meta for the type

Copying your syntax exactly doesn't register them, but doing it this way does: https://files.aries.f

Similar Threads

Similar Threads

Similar Threads