TimeSeriesFilter
TimeSeriesFilter filters a table for the most recent N nanoseconds.
caution
TimeSeriesFilter must be used on a DateTime column.
Syntax
result = source.where(new TimeSeriesFilter(columnName, nanos))
result = source.where(new TimeSeriesFilter(columnName, period))
Parameters
| Parameter | Type | Description |
|---|---|---|
| columnName | String | The name of the |
| nanos | long | How much time, in nanoseconds, to include in the window. |
| period | String | How much time to include in the window. |
Returns
A new table that contains only the rows within the specified time window.
Examples
The following example creates a time table, and then applies TimeSeriesFilter so that it only contains rows from the last 10 seconds.
import io.deephaven.engine.table.impl.select.TimeSeriesFilter
source = timeTable("PT00:00:01")
result = source.where(new TimeSeriesFilter("Timestamp", "PT00:00:10"))