{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/2555","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/2555/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/2555/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/2555/events","html_url":"https://github.com/influxdb/influxdb/issues/2555","id":75807597,"number":2555,"title":"[feature request] backreference for measurement/series when making CQs","user":{"login":"liyichao","id":2576762,"avatar_url":"https://avatars.githubusercontent.com/u/2576762?v=3","gravatar_id":"","url":"https://api.github.com/users/liyichao","html_url":"https://github.com/liyichao","followers_url":"https://api.github.com/users/liyichao/followers","following_url":"https://api.github.com/users/liyichao/following{/other_user}","gists_url":"https://api.github.com/users/liyichao/gists{/gist_id}","starred_url":"https://api.github.com/users/liyichao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/liyichao/subscriptions","organizations_url":"https://api.github.com/users/liyichao/orgs","repos_url":"https://api.github.com/users/liyichao/repos","events_url":"https://api.github.com/users/liyichao/events{/privacy}","received_events_url":"https://api.github.com/users/liyichao/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/continuous%20queries","name":"category/continuous queries","color":"207de5"}],"state":"closed","locked":false,"assignee":{"login":"dgnorton","id":209347,"avatar_url":"https://avatars.githubusercontent.com/u/209347?v=3","gravatar_id":"","url":"https://api.github.com/users/dgnorton","html_url":"https://github.com/dgnorton","followers_url":"https://api.github.com/users/dgnorton/followers","following_url":"https://api.github.com/users/dgnorton/following{/other_user}","gists_url":"https://api.github.com/users/dgnorton/gists{/gist_id}","starred_url":"https://api.github.com/users/dgnorton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dgnorton/subscriptions","organizations_url":"https://api.github.com/users/dgnorton/orgs","repos_url":"https://api.github.com/users/dgnorton/repos","events_url":"https://api.github.com/users/dgnorton/events{/privacy}","received_events_url":"https://api.github.com/users/dgnorton/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/43","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.4","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/43/labels","id":1172852,"number":43,"title":"0.9.4","description":"","creator":{"login":"otoolep","id":536312,"avatar_url":"https://avatars.githubusercontent.com/u/536312?v=3","gravatar_id":"","url":"https://api.github.com/users/otoolep","html_url":"https://github.com/otoolep","followers_url":"https://api.github.com/users/otoolep/followers","following_url":"https://api.github.com/users/otoolep/following{/other_user}","gists_url":"https://api.github.com/users/otoolep/gists{/gist_id}","starred_url":"https://api.github.com/users/otoolep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/otoolep/subscriptions","organizations_url":"https://api.github.com/users/otoolep/orgs","repos_url":"https://api.github.com/users/otoolep/repos","events_url":"https://api.github.com/users/otoolep/events{/privacy}","received_events_url":"https://api.github.com/users/otoolep/received_events","type":"User","site_admin":false},"open_issues":61,"closed_issues":81,"state":"open","created_at":"2015-06-19T18:25:47Z","updated_at":"2015-09-11T15:49:48Z","due_on":"2015-09-10T07:00:00Z","closed_at":null},"comments":6,"created_at":"2015-05-13T01:45:27Z","updated_at":"2015-09-11T16:06:40Z","closed_at":"2015-09-03T17:33:39Z","body":"I try to create downsampling series:\r\n\r\n```\r\n> create continuous query \"1_mins_rollup\" on collectd begin select mean(value) into \"1_week\".:series_name from /^[a-z]+.*/ group by time(1m) end\r\nERR: error parsing query: found :, expected identifier at line 1, char 92\r\n```\r\n\r\nIt seems regex is not supported in influxdb 0.9 now. Then I have to create a continuous query for `every`  measurement or series. It is too tedious."},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/139586869","html_url":"https://github.com/influxdb/influxdb/issues/2555#issuecomment-139586869","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/2555","id":139586869,"user":{"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},"created_at":"2015-09-11T16:06:40Z","updated_at":"2015-09-11T16:06:40Z","body":"One thing I am not sure about is how to do a roll up of my 10s data into 1m series, keep all tags for each series (series = measurement and unique tag set). \r\n\r\n```sql\r\nCREATE CONTINUOUS QUERY myquery ON testdb \r\nBEGIN \r\n   SELECT mean(value) INTO \"policy1\".:measurement FROM /^[a-z]+.*/ GROUP BY time(1m) \r\nEND\r\n```\r\n\r\nSo this looks nice, the measurement back reference will allow for a generic rollup rule. But wont the query above (taken from your tests) loose all tag data? Since there are not group by tag it looks like it. \r\n\r\nAnd if the group by tag needs to be added to the select or group by clause in order to keep tag data in the target series of the CQ then this feature is incomplete or pointless. At least it does not seem to solve the case of creating generic rollup rules. Or am I missing something for how tags are preserved in the target series of a CQ? \r\n\r\nI really would like a way for InfluxDB users to create generic rollup rules, rules that then Grafana can use to pick the right retention policy. Right now InfluxDB users use no rollups and get a horrible and slow experience, would be awesome to solve this :) \r\n\r\nping @pauldix  any ideas?\r\n"}}