Trouble with Grafana Plugin's Group By Feature
TLDR Victor has issues with Grafana plugin's 'group by' feature. Hengfei and omkar help troubleshoot, discovering the 'sql_mode' isn't working. A fix is implemented, but more issues arise.
Hengfei
Fri, 23 Jun 2023 03:09:28 UTCEnable `SQL MODE` then you can use `group by`
VictorGuillen
Fri, 23 Jun 2023 03:46:57 UTCI enabled SQL_MODE in grafana, but have : message.SearchSQLNotValid ( sql_mode=context, Query SQL does not supported [limit|offset|group by|having|join|union] )
Hengfei
Fri, 23 Jun 2023 03:57:23 UTComkar it looks `sql_mode` not working in Grafana. Can you check it?
Victor
Mon, 26 Jun 2023 13:07:00 UTCDo you have a los old version of plug-in that work with group by?
omkar
Mon, 26 Jun 2023 14:00:27 UTCVictor The issue regarding group by has been fixed. Please can you try now.
Victor
Wed, 28 Jun 2023 04:33:23 UTCHi, I testing the new version , in new panel if swich to SQL mode, send error
VictorGuillen
Wed, 28 Jun 2023 04:35:13 UTC
Victor
Wed, 28 Jun 2023 04:44:41 UTCFor grafana , do you have an example of query to graph with time series panel?, for example count group by some field?
omkar
Thu, 29 Jun 2023 07:09:08 UTCVictor In plugin Explore is supported and we are working on dashboard panels.
OpenObserve
Indexed 419 threads
OpenObserve is an open-source, petabyte-scale observability platform for the cloud native realm, offering a 10x cost reduction and 140x less storage use compared to competitors like Elasticsearch or Splunk. Built in Rust for exceptional performance, it offers comprehensive features like logs, metrics, traces, dashboards, and more | Knowledge Base powered by Struct.AI
View in App
Victor
Thu, 22 Jun 2023 05:05:48 UTCHi, for grafana plug-in , does support aggregations ? In grafana show error using group by.