{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/814","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/814/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/814/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/814/events","html_url":"https://github.com/influxdb/influxdb/issues/814","id":39984534,"number":814,"title":"Aggregate functions should take a wildcard to work on all columns","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/category/continuous%20queries","name":"category/continuous queries","color":"207de5"},{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/feature%20request","name":"category/feature request","color":"006b75"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2014-08-11T18:11:05Z","updated_at":"2015-11-09T19:28:50Z","closed_at":"2015-11-09T19:28:49Z","body":"As a shortcut in the query language, it would be great to be able to aggregate all columns with a given function. Like this:\r\n\r\n```sql\r\nselect sum(*), mean(*) from some_series group by time(10m)\r\n```\r\n\r\nWhere it would expand the query out into a sum for each column. Previously, we didn't have a definition of what columns existed over all time for a series. Now that metadata is in Raft, we know the columns by just looking it up.\r\n\r\nThis would have to have some intelligent failure logic to deal with column types where it doesn't make sense like strings. In that case it should just omit that from the results."},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/155165896","html_url":"https://github.com/influxdb/influxdb/issues/814#issuecomment-155165896","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/814","id":155165896,"user":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"created_at":"2015-11-09T19:28:49Z","updated_at":"2015-11-09T19:28:49Z","body":"closing in favor of https://github.com/influxdb/influxdb/issues/4708"}}