Any demo/code/best-practice about downsampling

CrateDB Documentation
1

I can not find any official demo/sample-code/best-practice about time series downsampling for cratedb from google, github or crate.io, especially for IOT data. Could anyone help, Thanks!

2 Likes
2

try date_trunc.

1 Like
3

Hi, I realise it has been a while since this question was posted, but I thought of writting this here in case someone could find it useful.
We have a short tutorial on this topic Resampling time-series data with DATE_BIN - Tutorials - CrateDB Community.
Once old data has been resampled, we can either:

1 Like