{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/297","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/297/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/297/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/297/events","html_url":"https://github.com/influxdb/influxdb/issues/297","id":28795941,"number":297,"title":"Continuous query series names should support regex groups","user":{"login":"pauldix","id":4331,"avatar_url":"https://avatars.githubusercontent.com/u/4331?v=3","gravatar_id":"","url":"https://api.github.com/users/pauldix","html_url":"https://github.com/pauldix","followers_url":"https://api.github.com/users/pauldix/followers","following_url":"https://api.github.com/users/pauldix/following{/other_user}","gists_url":"https://api.github.com/users/pauldix/gists{/gist_id}","starred_url":"https://api.github.com/users/pauldix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pauldix/subscriptions","organizations_url":"https://api.github.com/users/pauldix/orgs","repos_url":"https://api.github.com/users/pauldix/repos","events_url":"https://api.github.com/users/pauldix/events{/privacy}","received_events_url":"https://api.github.com/users/pauldix/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/0%20-%20Backlog","name":"0 - Backlog","color":"CCCCCC"},{"url":"https://api.github.com/repos/influxdb/influxdb/labels/continuous%20queries","name":"continuous queries","color":"207de5"}],"state":"open","locked":false,"assignee":{"login":"toddboom","id":53132,"avatar_url":"https://avatars.githubusercontent.com/u/53132?v=3","gravatar_id":"","url":"https://api.github.com/users/toddboom","html_url":"https://github.com/toddboom","followers_url":"https://api.github.com/users/toddboom/followers","following_url":"https://api.github.com/users/toddboom/following{/other_user}","gists_url":"https://api.github.com/users/toddboom/gists{/gist_id}","starred_url":"https://api.github.com/users/toddboom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toddboom/subscriptions","organizations_url":"https://api.github.com/users/toddboom/orgs","repos_url":"https://api.github.com/users/toddboom/repos","events_url":"https://api.github.com/users/toddboom/events{/privacy}","received_events_url":"https://api.github.com/users/toddboom/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/34","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.0","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/34/labels","id":875135,"number":34,"title":"0.9.0","description":null,"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":42,"closed_issues":22,"state":"open","created_at":"2014-11-21T03:38:20Z","updated_at":"2015-03-06T18:21:06Z","due_on":null,"closed_at":null},"comments":12,"created_at":"2014-03-05T15:06:06Z","updated_at":"2015-03-08T06:00:52Z","closed_at":null,"body":"For continuous queries that select from regexes, you should be able to do regex group captures and use those in the resulting series name. Like this:\r\n\r\n```sql\r\nselect mean(value) from /raw_stats\\.(.*)/ group by time(5m) into mean_stats.$1\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/77734969","html_url":"https://github.com/influxdb/influxdb/issues/297#issuecomment-77734969","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/297","id":77734969,"user":{"login":"inthecloud247","id":1683995,"avatar_url":"https://avatars.githubusercontent.com/u/1683995?v=3","gravatar_id":"","url":"https://api.github.com/users/inthecloud247","html_url":"https://github.com/inthecloud247","followers_url":"https://api.github.com/users/inthecloud247/followers","following_url":"https://api.github.com/users/inthecloud247/following{/other_user}","gists_url":"https://api.github.com/users/inthecloud247/gists{/gist_id}","starred_url":"https://api.github.com/users/inthecloud247/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/inthecloud247/subscriptions","organizations_url":"https://api.github.com/users/inthecloud247/orgs","repos_url":"https://api.github.com/users/inthecloud247/repos","events_url":"https://api.github.com/users/inthecloud247/events{/privacy}","received_events_url":"https://api.github.com/users/inthecloud247/received_events","type":"User","site_admin":false},"created_at":"2015-03-08T06:00:52Z","updated_at":"2015-03-08T06:00:52Z","body":"+1"}}