search

mtanda / grafana-aws-athena-datasource

Apache License 2.0
73 stars 21 forks source link

How to get timeseries data #35

Open theironrobin opened 4 years ago

theironrobin commented 4 years ago

I am doing a count(*) which just returns one value. I thought this would make graph view work but grafana is telling me "unable to graph data, switch to table view" any idea how to get graph view to work so i can plot data over time?

theironrobin commented 4 years ago

Update: was able to get graphed data by doing posting query and doing something like SELECT count(*) AS "200 event/media", localtimestamp AS ts but it doesn't persist, it just keeps updating but its only one dot, it does not continue as a line graph. any advice?

theironrobin commented 4 years ago

i solved it partially by changing my query to query 5 minute windows like so: SELECT FROM_UNIXTIME( FLOOR( TO_UNIXTIME( DATE_PARSE(time, '%Y-%m-%dT%H:%i:%s.%fZ') )/300 ) * 300 ) AS five_minute_window, COUNT(*) AS "count" FROM alb_logs GROUP BY 1

its slow but it works