Łukasz Herman
10/14/2022, 7:42 AMAnkit Nayan
10/14/2022, 9:35 AMŁukasz Herman
10/14/2022, 10:56 AMAnkit Nayan
10/14/2022, 12:31 PMselected
fields from interesting
fields. If you can share your log line and what you want to extract from it, we can help with regex rules at otel-collector. cc @nitya-signoznitya-signoz
10/14/2022, 12:38 PMChris Pinola
10/14/2022, 4:08 PMAlexei Zenin
10/14/2022, 4:33 PMChris Pinola
10/14/2022, 6:46 PMSELECT
$__timeInterval(timestamp) as time
,sum(toInt32(tagMap['client.validSamples'])) as Written
,sum(toInt32(tagMap['client.initialSamples'])) as Attempted
FROM signoz_traces.signoz_index_v2
WHERE $__timeFilter(timestamp)
AND (serviceName = '$app')
AND has(tagMap, 'client.validSamples')
GROUP BY time
ORDER BY time ASC
Alexei Zenin
10/14/2022, 6:46 PMChris Pinola
10/14/2022, 6:49 PM$__timeInterval
and $__timeFilter
work as advertised 🎉
also aggregating fields from the tagMap
column works great. I was expecting performance to be a bit rocky, but ClickHouse continues to impress.Alexei Zenin
10/14/2022, 6:49 PMChris Pinola
10/14/2022, 8:12 PMAlexei Zenin
10/14/2022, 8:23 PMChris Pinola
10/14/2022, 8:24 PM