timeSeriesMetricFamilies

timeSeriesMetricFamilies(db_name.time_series_table) - Returns the metric families 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 METRIC FAMILIES metric_families_table

The function also works if the metric families table is inner:

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

The following queries are equivalent:

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

The function timeSeriesMetricFamilies has an alias timeSeriesMetrics which is kept for backwards compatibility.

Last modified on September 16, 2026

SQL Reference

Data Types

Engines

Functions

Formats

Interfaces

Settings

System Tables

Data Lakes