Join Slack

This message was deleted.

# support

Slackbot

05/30/2023, 8:00 PM

This message was deleted.

Romario Lopez C

05/30/2023, 8:07 PM

I'm trying to use this field from the trace:

Romario Lopez C

05/30/2023, 8:09 PM

Seems that the http_status is not a tag? 🤔 not sure

Srikanth Chekuri

05/31/2023, 1:55 AM

Copy code

SELECT
      count() AS value,
      toStartOfInterval(timestamp, INTERVAL 1 MINUTE) AS interval,
      stringTagMap['net.host.name'] AS host,
      numberTagMap['http.status_code'] as http_status
FROM signoz_traces.distributed_signoz_index_v2
WHERE timestamp > {{.start_datetime}} AND timestamp < {{.end_datetime}}
      AND (stringTagMap['net.host.name'] = 'some_host' OR stringTagMap['net.host.name'] = 'other_host')
      AND stringTagMap['http.target'] = '/api/webhooks/1'
GROUP BY (host, http_status), interval
ORDER BY host ASC, http_status ASC, interval

Try this instead

Romario Lopez C

05/31/2023, 5:46 PM

What's the difference? Just the order of the selecte fields?

Romario Lopez C

05/31/2023, 5:48 PM

Didn't work

Srikanth Chekuri

06/01/2023, 1:32 AM

I think there is conflict between using the value vs http status code for the chart value since both are numbers. The reorder should have worked. I will check. You can also try

toString

explicitly since you are not doing anything with status code.

Romario Lopez C

06/01/2023, 1:33 AM

The reorder left me with the graph I shared. How do I use the

toString

thing?

Srikanth Chekuri

06/01/2023, 1:34 AM

Copy code

SELECT
      count() AS value,
      toStartOfInterval(timestamp, INTERVAL 1 MINUTE) AS interval,
      stringTagMap['net.host.name'] AS host,
      toString(numberTagMap['http.status_code']) as http_status
FROM signoz_traces.distributed_signoz_index_v2
WHERE timestamp > {{.start_datetime}} AND timestamp < {{.end_datetime}}
      AND (stringTagMap['net.host.name'] = 'some_host' OR stringTagMap['net.host.name'] = 'other_host')
      AND stringTagMap['http.target'] = '/api/webhooks/1'
GROUP BY (host, http_status), interval
ORDER BY host ASC, http_status ASC, interval

Romario Lopez C

06/01/2023, 1:42 AM

Yes! That worked

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.