ClickHouse configuration

Configuring ClickHouse

If you don't know about config.xml and users.xml files yet, see How to configure ClickHouse?open in new window.

Server timezone

You can avoid a lot of confusion by configuringopen in new window ClickHouse to use UTC timezoneopen in new window by changing config.xml:

<?xml version="1.0" ?>


By default, ClickHouse uses LZ4 to compress data, but you can get a better compression ratio by using ZSTD. To use ZSTD-3, change ClickHouse config.xml:

<?xml version="1.0" ?>
  <compression incl="clickhouse_compression">


If you want to play with the queries generated by Uptrace, you should enable prefer_column_name_to_aliasopen in new window setting in ClickHouse users.xml:

<?xml version="1.0" ?>
Last Updated: