timeSeriesSamples - ClickHouse Documentation

timeSeriesSamples(db_name.time_series_table) - Returns the samples table used by table db_name.time_series_table whose table engine is TimeSeries:

CREATE TABLE db_name.time_series_table ENGINE=TimeSeries SAMPLES samples_table

The function also works if the samples table is inner:

CREATE TABLE db_name.time_series_table ENGINE=TimeSeries SAMPLES INNER UUID '01234567-89ab-cdef-0123-456789abcdef'

The following queries are equivalent:

SELECT * FROM timeSeriesSamples(db_name.time_series_table);
SELECT * FROM timeSeriesSamples('db_name.time_series_table');
SELECT * FROM timeSeriesSamples('db_name', 'time_series_table');

The function timeSeriesSamples has an alias timeSeriesData which is kept for backwards compatibility.

Last modified on July 2, 2026

timeSeriesSelectorReads time series from a TimeSeries table filtered by a selector and with timestamps in a specified interval.