SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Any idea on how to write clickhouse queries on resources_string_value

<@U047H5RL3SP> can you share what results you wanted to get from your query and current clickhouse queries which are not giving results as expected

Also, have you had a look at this - <https://signoz.io/docs/tutorial/writing-clickhouse-queries-in-dashboard/>

When you say `distributed logs table is not being used`   what do you mean?

do you mean that it doesn't have actual rows/data?

&gt;  do you mean that it doesn't have actual rows/data? (edited)
Yes, look at the stats

<@U047H5RL3SP> distributed view in clickhouse does not retail data. The data is supposed to be in shards only. Distributed tables do the splitting of queries and aggregation of results

&gt; Tables with Distributed engine do not store any data of their own, but allow distributed query processing on multiple servers. Reading is automatically parallelized. During a read, the table indexes on remote servers are used, if there are any.
<https://clickhouse.com/docs/en/engines/table-engines/special/distributed/>

you should query `distributed_logs` table to fetch data from all shards

<@U01HWQ1RTC2> Thanks for the detailed explanation, really helpful :pray: