{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/1819","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/1819/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/1819/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/1819/events","html_url":"https://github.com/influxdb/influxdb/issues/1819","id":59578298,"number":1819,"title":"Wire up SORDER","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/functions","name":"category/functions","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/37","html_url":"https://github.com/influxdb/influxdb/milestones/Future%20Point%20Release","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/37/labels","id":1020711,"number":37,"title":"Future Point Release","description":"Not going into this release but slated for the next one","creator":{"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},"open_issues":42,"closed_issues":41,"state":"open","created_at":"2015-03-13T17:40:24Z","updated_at":"2015-10-19T20:51:40Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-03-03T00:52:05Z","updated_at":"2015-11-11T16:21:38Z","closed_at":null,"body":"SORDER is a way to order the series returned in a result. This is useful if you're going to return the top or bottom series by some function. For example:\r\n\r\n```sql\r\nSELECT mean(value)\r\nFROM cpu\r\nWHERE time > now() - 24h\r\nGROUP BY time(1h), host\r\nSORDER max(value) 5m desc\r\nSLIMIT 5\r\n```\r\n\r\nThis query says to take the most recent 5m period in the query's time range and compute the max for every host. It would then order those in descending order and then take the first 5 and do queries for them to get their series."},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/155833544","html_url":"https://github.com/influxdb/influxdb/issues/1819#issuecomment-155833544","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/1819","id":155833544,"user":{"login":"zapient","id":364087,"avatar_url":"https://avatars.githubusercontent.com/u/364087?v=3","gravatar_id":"","url":"https://api.github.com/users/zapient","html_url":"https://github.com/zapient","followers_url":"https://api.github.com/users/zapient/followers","following_url":"https://api.github.com/users/zapient/following{/other_user}","gists_url":"https://api.github.com/users/zapient/gists{/gist_id}","starred_url":"https://api.github.com/users/zapient/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zapient/subscriptions","organizations_url":"https://api.github.com/users/zapient/orgs","repos_url":"https://api.github.com/users/zapient/repos","events_url":"https://api.github.com/users/zapient/events{/privacy}","received_events_url":"https://api.github.com/users/zapient/received_events","type":"User","site_admin":false},"created_at":"2015-11-11T16:21:38Z","updated_at":"2015-11-11T16:21:38Z","body":"+1"}}