Adds the differences between consecutive rows. If the difference is negative, it is ignored.
timestamp to order values.
This function is primarily for materialized views that are ordered by some time bucket aligned
timestamp, for example a
toStartOfMinute bucket. Because the rows in such a materialized view
will all have the same timestamp, it is impossible for them to be merged in the "right" order. This
function keeps track of the
timestamp of the values it's seen, so it's possible to order the states
correctly during merging.
To calculate the delta sum across an ordered collection you can simply use the
valuemust be some Integer type or Float type or a Date or DateTime.
timestampmust be some Integer type or Float type or a Date or DateTime.
- Accumulated differences between consecutive values, ordered by the
SELECT deltaSumTimestamp(value, timestamp) FROM (select number as timestamp, [0, 4, 8, 3, 0, 0, 0, 1, 3, 5][number] as value from numbers(1, 10))
┌─deltaSumTimestamp(value, timestamp)─┐ │ 13 │ └─────────────────────────────────────┘