timeSeriesTimeRanges

timeSeriesTimeRanges(db_name.time_series_table) - Returns the time ranges table used by table db_name.time_series_table whose table engine is the TimeSeries engine:

CREATE TABLE db_name.time_series_table ENGINE=TimeSeries TIME RANGES time_ranges_table

The function also works if the time ranges table is inner:

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

The following queries are equivalent:

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

The time ranges table exists if the store_time_ranges setting is enabled. Tables of version 7 or earlier keep the columns min_time and max_time in the tags table.

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes