Slackbot
09/05/2023, 7:04 PMSrikanth Chekuri
09/06/2023, 8:00 AMIs there a simple way to change the headings in a tableUse the Legend formatting option
how can I convert durationnano into secondsCumbersome but you can use formula.
Hannes Benson
09/06/2023, 10:40 AMB/1000000
results in
API responded with 400 - encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query
Hannes Benson
09/06/2023, 10:42 AM{{tag_messaging.sidekiq.job_class}}
, {{sidekiq.job_class}}
& {{job_class}}
none of which resulted in the class name to be used. What should I be using?Srikanth Chekuri
09/06/2023, 10:42 AM{{messaging.sidekiq.job_class}}
Srikanth Chekuri
09/06/2023, 10:43 AMSrikanth Chekuri
09/06/2023, 10:44 AMTrying to use a formula likeCan you share the full API response?results inB/1000000
Hannes Benson
09/06/2023, 10:45 AM{
"status": "error",
"data": {
"F1": "SELECT B.messaging.sidekiq.job_class as messaging.sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class`, quantile(0.99)(durationNano) as value from signoz_traces.distributed_signoz_index_v2 where (timestamp >= '1693993539000000000' AND timestamp <= '1693997100000000000') AND has(stringTagMap, 'messaging.sidekiq.job_class') group by `messaging.sidekiq.job_class` LIMIT 100) as B "
},
"errorType": "bad_data",
"error": "encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query"
}
Hannes Benson
09/06/2023, 10:47 AMHannes Benson
09/06/2023, 10:57 AM