Skip to main content

​
timeSeriesPresentToGrid

Introduced in: v26.9.0 Aggregate function that checks whether time series data is present on the specified grid. For each point on the grid the function returns 1 if there is at least one sample within the specified time window, otherwise NULL.
This function is in private preview, enable it by setting enable_time_series_aggregate_functions=true.
Syntax
Parameters
  • start_timestamp — Specifies start of the grid. It can also be a fractional number, or a string containing a number or a date-time text. UInt32 or DateTime or DateTime64 or Float* or Decimal* or String
  • end_timestamp — Specifies end of the grid. It can also be a fractional number, or a string containing a number or a date-time text. UInt32 or DateTime or DateTime64 or Float* or Decimal* or String
  • grid_step — Specifies step of the grid in seconds. It can also be a fractional number, or a string containing a number or a duration like ’15s’ or ‘1m’. UInt32 or Float* or Decimal* or String
  • staleness — Specifies the maximum “staleness” in seconds of the considered samples. The staleness window is a left-open and right-closed interval. It can also be a fractional number, or a string containing a number or a duration like ’15s’ or ‘1m’. UInt32 or Float* or Decimal* or String
Arguments
  • timestamp — Timestamp of the sample. Can be individual values or arrays. UInt32 or DateTime or DateTime64 or Array(UInt32) or Array(DateTime) or Array(DateTime64)
  • value — Value of the time series corresponding to the timestamp. Can be individual values or arrays. Float* or Array(Float*)
  • samples — Samples of the time series passed as an array of tuples (timestamp, value), where the tuple elements have the timestamp and value types listed above. An alternative to passing the timestamps and the values as two separate arguments. Array(Tuple(T1, T2))
Returned value Returns 1 for each grid point whose window contains at least one sample, otherwise NULL. Array(Nullable(UInt8)) Examples
Last modified on October 7, 2026