Eugene Klimov

@kotchuprik please subscribe to https://github.com/ClickHouse/ClickHouse/pull/7426

could you run in `clickhouse-client` `SELECT * FROM system.query_log WHERE query LIKE '%dsp.router%' AND exception_code=164 ORDER BY event_time DESC LIMIT 10 FORMAT Vertical;` and share query result?

`SELECT count() FROM system.query_log WHERE exception_code=164` ?

`grep "Code: 164" /var/log/clickhouse/clickhouse-server.err.log` ?

@ivan-tkatchev is the issue still relevant for you?

close issue after topic started inactivity

I think implements $columnsMs will better thanks for reporting

Why `$perSecondColumns` is not applicable for you?

How many `time series` do you need? Is only one series per datacenter or one per datacenter plus one per datacenter+interface?

maybe `GROUP BY ... WITH ROLLUP ..` will good solution for your use case? https://clickhouse.com/docs/en/sql-reference/statements/select/group-by/#with-rollup-modifier