Clickhouse 22.3 Fresh Install Causes Otel Collector Startup Error

TLDR Romil experienced an error preventing the otel collector from starting after a fresh Clickhouse installation. vishal-signoz shared the fix from a previous thread.

Photo of Romil
Thu, 23 Feb 2023 16:34:35 UTC

noob question, i did a fresh install yesterday on clickhouse 22.3 using the helm chart and now the otel collector won't start, i see the following in logs: ```2023/02/23 07:54:28 application run finished with error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": code: 62, message: Syntax error: failed at position 2290 (')') (line 43, col 3): ) ENGINE MergeTree() PARTITION BY toDate(timestamp) ORDER BY (durationNano, timestamp) TTL toDateTime(timestamp) + INTERVAL 604800 SECOND DELETE SETTING. Expected one of: table property (column, index, constraint) declaration, INDEX, CONSTRAINT, PROJECTION, PRIMARY KEY, column declaration, identifier```

Photo of Prashant
Fri, 24 Feb 2023 06:12:01 UTC

vishal-signoz can you look into this?

Photo of vishal-signoz
Fri, 24 Feb 2023 06:13:26 UTC

I think it is fixed:

Photo of Prashant
Fri, 24 Feb 2023 07:12:46 UTC

got it