{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/chronograf/issues/3350","repository_url":"https://api.github.com/repos/influxdata/chronograf","labels_url":"https://api.github.com/repos/influxdata/chronograf/issues/3350/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/chronograf/issues/3350/comments","events_url":"https://api.github.com/repos/influxdata/chronograf/issues/3350/events","html_url":"https://github.com/influxdata/chronograf/issues/3350","id":319375286,"number":3350,"title":"Support subqueries in select.go (query AST)","user":{"login":"russorat","id":4805997,"avatar_url":"https://avatars2.githubusercontent.com/u/4805997?v=4","gravatar_id":"","url":"https://api.github.com/users/russorat","html_url":"https://github.com/russorat","followers_url":"https://api.github.com/users/russorat/followers","following_url":"https://api.github.com/users/russorat/following{/other_user}","gists_url":"https://api.github.com/users/russorat/gists{/gist_id}","starred_url":"https://api.github.com/users/russorat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/russorat/subscriptions","organizations_url":"https://api.github.com/users/russorat/orgs","repos_url":"https://api.github.com/users/russorat/repos","events_url":"https://api.github.com/users/russorat/events{/privacy}","received_events_url":"https://api.github.com/users/russorat/received_events","type":"User","site_admin":false},"labels":[{"id":430519659,"url":"https://api.github.com/repos/influxdata/chronograf/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"goller","id":1922921,"avatar_url":"https://avatars2.githubusercontent.com/u/1922921?v=4","gravatar_id":"","url":"https://api.github.com/users/goller","html_url":"https://github.com/goller","followers_url":"https://api.github.com/users/goller/followers","following_url":"https://api.github.com/users/goller/following{/other_user}","gists_url":"https://api.github.com/users/goller/gists{/gist_id}","starred_url":"https://api.github.com/users/goller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goller/subscriptions","organizations_url":"https://api.github.com/users/goller/orgs","repos_url":"https://api.github.com/users/goller/repos","events_url":"https://api.github.com/users/goller/events{/privacy}","received_events_url":"https://api.github.com/users/goller/received_events","type":"User","site_admin":false},"assignees":[{"login":"goller","id":1922921,"avatar_url":"https://avatars2.githubusercontent.com/u/1922921?v=4","gravatar_id":"","url":"https://api.github.com/users/goller","html_url":"https://github.com/goller","followers_url":"https://api.github.com/users/goller/followers","following_url":"https://api.github.com/users/goller/following{/other_user}","gists_url":"https://api.github.com/users/goller/gists{/gist_id}","starred_url":"https://api.github.com/users/goller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goller/subscriptions","organizations_url":"https://api.github.com/users/goller/orgs","repos_url":"https://api.github.com/users/goller/repos","events_url":"https://api.github.com/users/goller/events{/privacy}","received_events_url":"https://api.github.com/users/goller/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-05-02T00:47:59Z","updated_at":"2018-05-02T23:54:08Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"https://github.com/influxdata/chronograf/blob/master/influx/queries/select.go#L293\r\n\r\nexample:\r\n`select sum(rate) from (SELECT difference(\"usage_user\") AS \"rate\" FROM \"telegraf\".\"autogen\".\"cpu\" WHERE time > now()-15m GROUP BY *) WHERE \"rate\" > 0 GROUP BY cpu`\r\n\r\nrequired for #1686 "},"comment":{"url":"https://api.github.com/repos/influxdata/chronograf/issues/comments/386156018","html_url":"https://github.com/influxdata/chronograf/issues/3350#issuecomment-386156018","issue_url":"https://api.github.com/repos/influxdata/chronograf/issues/3350","id":386156018,"user":{"login":"ebb-tide","id":10937678,"avatar_url":"https://avatars2.githubusercontent.com/u/10937678?v=4","gravatar_id":"","url":"https://api.github.com/users/ebb-tide","html_url":"https://github.com/ebb-tide","followers_url":"https://api.github.com/users/ebb-tide/followers","following_url":"https://api.github.com/users/ebb-tide/following{/other_user}","gists_url":"https://api.github.com/users/ebb-tide/gists{/gist_id}","starred_url":"https://api.github.com/users/ebb-tide/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebb-tide/subscriptions","organizations_url":"https://api.github.com/users/ebb-tide/orgs","repos_url":"https://api.github.com/users/ebb-tide/repos","events_url":"https://api.github.com/users/ebb-tide/events{/privacy}","received_events_url":"https://api.github.com/users/ebb-tide/received_events","type":"User","site_admin":false},"created_at":"2018-05-02T23:54:08Z","updated_at":"2018-05-02T23:54:08Z","author_association":"CONTRIBUTOR","body":"@desa and I looked at this and concluded that it was not possible to update the queryAST generator to handle subqueries. Chronograf depends on Kapacitor which needs a ~1.1.x version of Influx to work with, and can not upgrade for a reason, so Chronograf can not update its own dependency on Influxdb. We decided on another way to deal with groupby's."}}
{"actor":{"display_login":"ebb-tide"}}