Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

timeSeriesSamples

timeSeriesSamples(db_name.time_series_table) - Retorna a tabela de amostras usada pela tabela db_name.time_series_table cujo motor de tabela é TimeSeries:

CREATE TABLE db_name.time_series_table ENGINE=TimeSeries SAMPLES samples_table

A função também funciona quando a tabela samples é interna:

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

As consultas a seguir são equivalentes:

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