Aggregates
Aggregate
lttb()
Downsamples the (x, y) points to (at most) n representative points using the Largest Triangle Three Buckets algorithm. Returns a LIST of STRUCT(x, y); the points must be ordered by x (use lttb(x, y, n ORDER BY x)).
Reference: DuckDB 2.0.0
Arguments & returns
16 overloadslttb(x, y, n)
Aggregate
| Overload link | x | y | n |
Returns |
|---|---|---|---|---|
| #01 | DOUBLE | DOUBLE | BIGINT |
STRUCT(x DOUBLE, y DOUBLE)[] |
| #02 | DOUBLE | FLOAT | BIGINT |
STRUCT(x DOUBLE, y FLOAT)[] |
| #03 | FLOAT | DOUBLE | BIGINT |
STRUCT(x FLOAT, y DOUBLE)[] |
| #04 | FLOAT | FLOAT | BIGINT |
STRUCT(x FLOAT, y FLOAT)[] |
| #05 | TIMESTAMP WITH TIME ZONE | DOUBLE | BIGINT |
STRUCT(x TIMESTAMP WITH TIME ZONE, y DOUBLE)[] |
| #06 | TIMESTAMP WITH TIME ZONE | FLOAT | BIGINT |
STRUCT(x TIMESTAMP WITH TIME ZONE, y FLOAT)[] |
| #07 | TIMESTAMP_MS | DOUBLE | BIGINT |
STRUCT(x TIMESTAMP_MS, y DOUBLE)[] |
| #08 | TIMESTAMP_MS | FLOAT | BIGINT |
STRUCT(x TIMESTAMP_MS, y FLOAT)[] |
| #09 | TIMESTAMP_NS | DOUBLE | BIGINT |
STRUCT(x TIMESTAMP_NS, y DOUBLE)[] |
| #10 | TIMESTAMP_NS | FLOAT | BIGINT |
STRUCT(x TIMESTAMP_NS, y FLOAT)[] |
| #11 | TIMESTAMP_S | DOUBLE | BIGINT |
STRUCT(x TIMESTAMP_S, y DOUBLE)[] |
| #12 | TIMESTAMP_S | FLOAT | BIGINT |
STRUCT(x TIMESTAMP_S, y FLOAT)[] |
| #13 | TIMESTAMP | DOUBLE | BIGINT |
STRUCT(x TIMESTAMP, y DOUBLE)[] |
| #14 | TIMESTAMP | FLOAT | BIGINT |
STRUCT(x TIMESTAMP, y FLOAT)[] |
| #15 | TIMESTAMPTZ_NS | DOUBLE | BIGINT |
STRUCT(x TIMESTAMPTZ_NS, y DOUBLE)[] |
| #16 | TIMESTAMPTZ_NS | FLOAT | BIGINT |
STRUCT(x TIMESTAMPTZ_NS, y FLOAT)[] |
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example with sample data ยท Run to view results.