Join Slack

This message was deleted.

# support

Slackbot

01/14/2023, 10:18 AM

This message was deleted.

Apoorva

01/14/2023, 10:19 AM

Any idea on how to write clickhouse queries on resources_string_value

Pranay

01/14/2023, 11:40 AM

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

Pranay

01/14/2023, 11:40 AM

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

Pranay

01/14/2023, 11:41 AM

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?

Apoorva

01/14/2023, 11:51 AM

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

Yes, look at the stats

Ankit Nayan

01/14/2023, 1:36 PM

@Apoorva 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

Ankit Nayan

01/14/2023, 1:36 PM

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/

Ankit Nayan

01/14/2023, 1:37 PM

you should query

distributed_logs

table to fetch data from all shards

Apoorva

01/16/2023, 7:30 AM

@Ankit Nayan Thanks for the detailed explanation, really helpful 🙏

👍 1

9 Views

Open in Slack

Previous Next

SigNoz Community

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