Configuring ClickHouse for Uptrace

Configuring ClickHouse

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


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">

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" ?>


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: