Open sandersaares opened 1 year ago
Thanks for creating this issue, @sandersaares
generally it is better to use Grafana's built-in time-macros for filtering by time:
have you tried these instead?
As you can see on my screenshot, I am creating a query using the GUI designer. Presumably this already implies that the relevant macros are used. You can also see the macro in the query inspector output I pasted.
could you please copy and paste all relevant data using the panel --> more --> get help
workflow in the panel's dropdown menu? This will help up mock up your data and reproduce your issue. It is important to our teams that issues get verified as reproducible before we formally mark them as bugs. Thank you!
here are more details and steps for copying your data over to this issue:
https://grafana.com/docs/grafana/latest/troubleshooting/send-panel-to-grafana-support/
Key | Value |
---|---|
Panel | timeseries @ 9.3.2.2 (67a213dc85) |
Grafana | 9.3.2.2 (67a213dc85) // Pro |
Panel | \ntimeseries @ 9.3.2.2 (67a213dc85) | \n
---|---|
Queries | \nA[grafana-azure-data-explorer-datasource] | \n
Data | Error 1 frames, 0 fields, 0 rows |
Grafana | \n9.3.2.2 (67a213dc85) // Pro | \n
Hi @sandersaares - I can replicate this issue as mentioned. We are looking into how to handle reserved keywords in the query builder. In the meantime there are two workarounds you can use to run a successful query:
1) Create a new column called Time
:
test1
| extend Time = time
| where Time >= datetime(2000-01-01T00:00:00Z) and Time <= datetime(2000-01-01T01:00:00Z)
| order by Time asc
2) Create a new column using the reserved keyword escaping called ["time"]
:
test1
| extend ["time"] = time
| where ["time"] >= datetime(2000-01-01T00:00:00Z) and ["time"] <= datetime(2000-01-01T01:00:00Z)
| order by ["time"] asc
What happened:
I suspect this is be due to lack of required keyword-escaping of
time
.What you expected to happen:
A working query should have been created.
How to reproduce it (as minimally and precisely as possible):
Make Azure Data Explorer table with timestamp in
time
column.Sample data: metrics.json.gz
Anything else we need to know?:
Environment: