Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Series and time are not formatted - Alerting TimeSeries - 9.5.1 #479

Closed
gravellierb opened this issue May 22, 2023 · 1 comment
Closed
Assignees
Milestone

Comments

@gravellierb
Copy link

gravellierb commented May 22, 2023

I'm working on an alert rule to check a volume over time.
In a dashboard, when I apply my query, I get this result
image

But when I use the same query in an alert, I get this result.
image

You can see that the timestamp is not interpreted correctly and the series names are repeating.

I applied the query using the official clickhouse plugin (panel and alert rule), and I didn't have any problem.

the request is :
`SELECT
$timeSeries as t,
page_domain_name,
sum(1) as ad_start
FROM $table

WHERE $timeFilter
AND event in ( 'ad_start')
AND toDate($dateTimeCol) < toDate($to)
GROUP BY t, page_domain_name
`

And the Generated SQL is:
`SELECT
(intDiv(toUInt32(timestamp), 86400) * 86400) * 1000 as t,
page_domain_name,
sum(1) as ad_start
FROM viously.event_ad

WHERE timestamp >= toDateTime(1684508508) AND timestamp <= toDateTime(1684767708)
AND event in ( 'ad_start')
GROUP BY t, group`

@Slach
Copy link
Collaborator

Slach commented Jun 1, 2023

According to
#478 (comment)
it looks like grafana related issue, doesn't reproduce on grafana/grafana:main (10.1.x) docker image
grafana/grafana#69289

@Slach Slach closed this as completed Jun 1, 2023
@Slach Slach self-assigned this Jun 1, 2023
@Slach Slach added this to the 2.6.0 milestone Jun 1, 2023
@Slach Slach modified the milestones: 2.6.0, 3.0.0 Jan 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants