{"action":"closed","issue":{"url":"https://api.github.com/repos/grafana/grafana/issues/5662","repository_url":"https://api.github.com/repos/grafana/grafana","labels_url":"https://api.github.com/repos/grafana/grafana/issues/5662/labels{/name}","comments_url":"https://api.github.com/repos/grafana/grafana/issues/5662/comments","events_url":"https://api.github.com/repos/grafana/grafana/issues/5662/events","html_url":"https://github.com/grafana/grafana/issues/5662","id":167623047,"number":5662,"title":"[Bug] Repeat panel: Invalid GROUP BY time(1y) (InfluxDB)","user":{"login":"bbczeuz","id":11089403,"avatar_url":"https://avatars.githubusercontent.com/u/11089403?v=3","gravatar_id":"","url":"https://api.github.com/users/bbczeuz","html_url":"https://github.com/bbczeuz","followers_url":"https://api.github.com/users/bbczeuz/followers","following_url":"https://api.github.com/users/bbczeuz/following{/other_user}","gists_url":"https://api.github.com/users/bbczeuz/gists{/gist_id}","starred_url":"https://api.github.com/users/bbczeuz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bbczeuz/subscriptions","organizations_url":"https://api.github.com/users/bbczeuz/orgs","repos_url":"https://api.github.com/users/bbczeuz/repos","events_url":"https://api.github.com/users/bbczeuz/events{/privacy}","received_events_url":"https://api.github.com/users/bbczeuz/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/grafana/grafana/labels/type:%20bug","name":"type: bug","color":"dddddd"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/grafana/grafana/milestones/23","html_url":"https://github.com/grafana/grafana/milestones/4.0.0","labels_url":"https://api.github.com/repos/grafana/grafana/milestones/23/labels","id":1490356,"number":23,"title":"4.0.0","description":"","creator":{"login":"torkelo","id":10999,"avatar_url":"https://avatars.githubusercontent.com/u/10999?v=3","gravatar_id":"","url":"https://api.github.com/users/torkelo","html_url":"https://github.com/torkelo","followers_url":"https://api.github.com/users/torkelo/followers","following_url":"https://api.github.com/users/torkelo/following{/other_user}","gists_url":"https://api.github.com/users/torkelo/gists{/gist_id}","starred_url":"https://api.github.com/users/torkelo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/torkelo/subscriptions","organizations_url":"https://api.github.com/users/torkelo/orgs","repos_url":"https://api.github.com/users/torkelo/repos","events_url":"https://api.github.com/users/torkelo/events{/privacy}","received_events_url":"https://api.github.com/users/torkelo/received_events","type":"User","site_admin":false},"open_issues":40,"closed_issues":31,"state":"open","created_at":"2016-01-07T20:49:42Z","updated_at":"2016-07-26T15:20:56Z","due_on":"2016-10-30T23:00:00Z","closed_at":null},"comments":2,"created_at":"2016-07-26T14:34:42Z","updated_at":"2016-07-26T15:20:56Z","closed_at":"2016-07-26T15:20:56Z","body":"* **I'm submitting a ...**\r\n- [x] Bug report\r\n- [ ] Feature request\r\n- [ ] Question / Support request: **Please do not** open a github issue. [Support Options](http://grafana.org/support/)\r\n\r\nPlease include this information:\r\n- What Grafana version are you using?\r\nVersion     : 3.1.0\r\nRelease     : 1468321182\r\n\r\n- What datasource are you using?\r\nInfluxdb, 0.13.0\r\n\r\n- What OS are you running grafana on?\r\nRHEL 6\r\n\r\n- What did you do?\r\n - I want to see Error stats of all interfaces of a device, so I defined a table displaying all variables of a certain interface and tried to apply this per interface using a template variable $name\r\n- The table displays aggregates of columns (To Table Transform: Time Series Aggregations)\r\n - Enable \"Repeat panel\" based on template variable (multi selection, singlestat)\r\n\r\n- What was the expected result?\r\n - It displays the table panel for each element of the template variable\r\n\r\n- What happened instead?\r\n - Original query (template variable $name):\r\n```\r\nSELECT max(\"in-discards\") AS \"in-discards\", max(\"out-discards\") AS \"out-discards\", max(\"in-errors\") AS \"in-errors\", max(\"out-errors\") AS \"out-errors\" FROM \"SNMP Interface\" WHERE \"name\" =~ /^$name$/ AND $timeFilter GROUP BY time($interval) fill(null)\r\n```\r\n - Query sent to InfluxDB:\r\n```\r\nSELECT max(\"in-discards\") AS \"in-discards\", max(\"out-discards\") AS \"out-discards\", max(\"in-errors\") AS \"in-errors\", max(\"out-errors\") AS \"out-errors\" FROM \"SNMP Interface\" WHERE \"name\" =~ /^SOME_DEVICE-ae12$/ AND time > now() - 30d GROUP BY time(1y) fill(null)\r\n```\r\n - Response:\r\n```\r\n{\r\n  \"error\": \"error parsing query: found y, expected ) at line 1, char 247\",\r\n  \"message\": \"error parsing query: found y, expected ) at line 1, char 247\"\r\n}\r\n```\r\n - Grafana somehow uses a GROUP BY time(1y). Even if I manually set the interval to some value, it keeps using 1y, which InfluxDB doesn't understand (It understands 365d or 52w)"}}
{"actor":{"display_login":"torkelo"}}