Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

check is lttb function applicable and usefull #500

Open
Slach opened this issue Dec 1, 2023 · 1 comment
Open

check is lttb function applicable and usefull #500

Slach opened this issue Dec 1, 2023 · 1 comment
Labels
p2 Priority 2
Milestone

Comments

@Slach
Copy link
Collaborator

Slach commented Dec 1, 2023

Would be very cool would be to have an option to use the new lttb function in 23.10 for the downsampling. This could be an option to select in the plugin settings and/or maybe a completely new macro?

https://clickhouse.com/docs/en/sql-reference/aggregate-functions/reference/largestTriangleThreeBuckets

@Slach Slach added this to the 3.0.0 milestone Dec 1, 2023
@Slach
Copy link
Collaborator Author

Slach commented Apr 1, 2024

if we will implements $lttb(bucket_numbers, field1, field2)

shall transformed to something like that

WITH largestTriangleThreeBuckets(4)(field1, field2) AS lttb
SELECT untuple(arrayJoin(lttb)) FROM $table;

@Slach Slach modified the milestones: 3.1.0, 3.2.0 Apr 1, 2024
@Slach Slach added the p2 Priority 2 label May 20, 2024
@Slach Slach changed the title check lttb function application for work check is lttb function applicable and usefull May 27, 2024
@Slach Slach modified the milestones: 3.2.0, 3.3.0 Jun 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
p2 Priority 2
Projects
None yet
Development

No branches or pull requests

1 participant