{"action":"created","issue":{"url":"https://api.github.com/repos/druid-io/druid/issues/2393","repository_url":"https://api.github.com/repos/druid-io/druid","labels_url":"https://api.github.com/repos/druid-io/druid/issues/2393/labels{/name}","comments_url":"https://api.github.com/repos/druid-io/druid/issues/2393/comments","events_url":"https://api.github.com/repos/druid-io/druid/issues/2393/events","html_url":"https://github.com/druid-io/druid/pull/2393","id":131245745,"number":2393,"title":"support alphanumeric sorting for dimensional columns in groupby","user":{"login":"CHOIJAEHONG1","id":7674735,"avatar_url":"https://avatars.githubusercontent.com/u/7674735?v=3","gravatar_id":"","url":"https://api.github.com/users/CHOIJAEHONG1","html_url":"https://github.com/CHOIJAEHONG1","followers_url":"https://api.github.com/users/CHOIJAEHONG1/followers","following_url":"https://api.github.com/users/CHOIJAEHONG1/following{/other_user}","gists_url":"https://api.github.com/users/CHOIJAEHONG1/gists{/gist_id}","starred_url":"https://api.github.com/users/CHOIJAEHONG1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CHOIJAEHONG1/subscriptions","organizations_url":"https://api.github.com/users/CHOIJAEHONG1/orgs","repos_url":"https://api.github.com/users/CHOIJAEHONG1/repos","events_url":"https://api.github.com/users/CHOIJAEHONG1/events{/privacy}","received_events_url":"https://api.github.com/users/CHOIJAEHONG1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/druid-io/druid/labels/Feature","name":"Feature","color":"2ceefb"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/druid-io/druid/milestones/18","html_url":"https://github.com/druid-io/druid/milestones/0.9.1","labels_url":"https://api.github.com/repos/druid-io/druid/milestones/18/labels","id":1526819,"number":18,"title":"0.9.1","description":"","creator":{"login":"fjy","id":428325,"avatar_url":"https://avatars.githubusercontent.com/u/428325?v=3","gravatar_id":"","url":"https://api.github.com/users/fjy","html_url":"https://github.com/fjy","followers_url":"https://api.github.com/users/fjy/followers","following_url":"https://api.github.com/users/fjy/following{/other_user}","gists_url":"https://api.github.com/users/fjy/gists{/gist_id}","starred_url":"https://api.github.com/users/fjy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fjy/subscriptions","organizations_url":"https://api.github.com/users/fjy/orgs","repos_url":"https://api.github.com/users/fjy/repos","events_url":"https://api.github.com/users/fjy/events{/privacy}","received_events_url":"https://api.github.com/users/fjy/received_events","type":"User","site_admin":false},"open_issues":37,"closed_issues":11,"state":"open","created_at":"2016-01-20T19:04:22Z","updated_at":"2016-02-19T18:02:24Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2016-02-04T05:13:06Z","updated_at":"2016-02-19T18:14:20Z","closed_at":"2016-02-16T05:11:30Z","pull_request":{"url":"https://api.github.com/repos/druid-io/druid/pulls/2393","html_url":"https://github.com/druid-io/druid/pull/2393","diff_url":"https://github.com/druid-io/druid/pull/2393.diff","patch_url":"https://github.com/druid-io/druid/pull/2393.patch"},"body":"Currently, an orderby clause in a groupby query only supports the lexicographical ordering for dimensional columns. I think it would be useful to provide the alphanumeric ordering as well. \r\n\r\n`StringComparator` is a newly introduced class to abstract two types of ordering in characters. The main routines for them have been pulled from `AlphaNemericTopNMetircSpec` and `LexicographicalTopNMetricSpec`.\r\n\r\nThe below is a piece of grouby query which sorts the `page` dimension in descending alphanumeric order to give an example.\r\n```\r\n  \"limitSpec\" : {\"type\" : \"default\"\r\n    , \"limit\":5000\r\n    , \"columns\": [{\"dimension\":\"page\"\r\n                          , \"direction\":\"descending\"\r\n                          , \"dimensionOrder\" : \"alphanumeric\"}]\r\n  },\r\n```\r\nIt would be grateful if you post any comment here. Thanks."},"comment":{"url":"https://api.github.com/repos/druid-io/druid/issues/comments/186341803","html_url":"https://github.com/druid-io/druid/pull/2393#issuecomment-186341803","issue_url":"https://api.github.com/repos/druid-io/druid/issues/2393","id":186341803,"user":{"login":"fjy","id":428325,"avatar_url":"https://avatars.githubusercontent.com/u/428325?v=3","gravatar_id":"","url":"https://api.github.com/users/fjy","html_url":"https://github.com/fjy","followers_url":"https://api.github.com/users/fjy/followers","following_url":"https://api.github.com/users/fjy/following{/other_user}","gists_url":"https://api.github.com/users/fjy/gists{/gist_id}","starred_url":"https://api.github.com/users/fjy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fjy/subscriptions","organizations_url":"https://api.github.com/users/fjy/orgs","repos_url":"https://api.github.com/users/fjy/repos","events_url":"https://api.github.com/users/fjy/events{/privacy}","received_events_url":"https://api.github.com/users/fjy/received_events","type":"User","site_admin":false},"created_at":"2016-02-19T18:14:20Z","updated_at":"2016-02-19T18:14:20Z","body":"@CHOIJAEHONG1, @vogievetsky makes a good point. We should have some docs for this"}}