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.
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```
vishal-signoz can you look into this?
I think it is fixed:
Indexed 1060 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI