Open tisonkun opened 4 months ago
But it seems we actually don't have complex window. Instead, we use always tumbling window.
The ALIGN
parameter only affect the timestamp of result rows?
UPDATE: No. RANGE is the window size and ALIGN is the step, so we still have multiple kinds of windows.
https://docs.greptime.com/user-guide/query-data/sql#time-range-window
We indeed have some picture to explain how Range query works
@Taylor-lagrange Cool. I hit this page (https://docs.greptime.com/reference/sql/range#range-query) and perhaps it needs some cross links.
It's unintuitive to understanding all the parameters of RANGE QUERY meaning.
I'd suggest we use some pictures like:
to demonstrate how to write RANGE QUERY.
What do you think? @nicecui @waynexia @Taylor-lagrange