{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/presto/issues/2085","labels_url":"https://api.github.com/repos/facebook/presto/issues/2085/labels{/name}","comments_url":"https://api.github.com/repos/facebook/presto/issues/2085/comments","events_url":"https://api.github.com/repos/facebook/presto/issues/2085/events","html_url":"https://github.com/facebook/presto/pull/2085","id":51389302,"number":2085,"title":"Rewrite Single Distinct Aggregation into GroupBy","user":{"login":"zhenxiao","id":1274155,"avatar_url":"https://avatars.githubusercontent.com/u/1274155?v=3","gravatar_id":"","url":"https://api.github.com/users/zhenxiao","html_url":"https://github.com/zhenxiao","followers_url":"https://api.github.com/users/zhenxiao/followers","following_url":"https://api.github.com/users/zhenxiao/following{/other_user}","gists_url":"https://api.github.com/users/zhenxiao/gists{/gist_id}","starred_url":"https://api.github.com/users/zhenxiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhenxiao/subscriptions","organizations_url":"https://api.github.com/users/zhenxiao/orgs","repos_url":"https://api.github.com/users/zhenxiao/repos","events_url":"https://api.github.com/users/zhenxiao/events{/privacy}","received_events_url":"https://api.github.com/users/zhenxiao/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"martint","id":14387,"avatar_url":"https://avatars.githubusercontent.com/u/14387?v=3","gravatar_id":"","url":"https://api.github.com/users/martint","html_url":"https://github.com/martint","followers_url":"https://api.github.com/users/martint/followers","following_url":"https://api.github.com/users/martint/following{/other_user}","gists_url":"https://api.github.com/users/martint/gists{/gist_id}","starred_url":"https://api.github.com/users/martint/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martint/subscriptions","organizations_url":"https://api.github.com/users/martint/orgs","repos_url":"https://api.github.com/users/martint/repos","events_url":"https://api.github.com/users/martint/events{/privacy}","received_events_url":"https://api.github.com/users/martint/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/facebook/presto/milestones/11","html_url":"https://github.com/facebook/presto/milestones/0.102","labels_url":"https://api.github.com/repos/facebook/presto/milestones/11/labels","id":1089783,"number":11,"title":"0.102","description":null,"creator":{"login":"martint","id":14387,"avatar_url":"https://avatars.githubusercontent.com/u/14387?v=3","gravatar_id":"","url":"https://api.github.com/users/martint","html_url":"https://github.com/martint","followers_url":"https://api.github.com/users/martint/followers","following_url":"https://api.github.com/users/martint/following{/other_user}","gists_url":"https://api.github.com/users/martint/gists{/gist_id}","starred_url":"https://api.github.com/users/martint/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martint/subscriptions","organizations_url":"https://api.github.com/users/martint/orgs","repos_url":"https://api.github.com/users/martint/repos","events_url":"https://api.github.com/users/martint/events{/privacy}","received_events_url":"https://api.github.com/users/martint/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":3,"state":"closed","created_at":"2015-04-29T18:59:08Z","updated_at":"2015-05-22T22:16:11Z","due_on":null,"closed_at":"2015-05-22T22:16:11Z"},"comments":26,"created_at":"2014-12-09T05:25:21Z","updated_at":"2015-06-01T04:36:36Z","closed_at":"2015-04-29T18:35:53Z","pull_request":{"url":"https://api.github.com/repos/facebook/presto/pulls/2085","html_url":"https://github.com/facebook/presto/pull/2085","diff_url":"https://github.com/facebook/presto/pull/2085.diff","patch_url":"https://github.com/facebook/presto/pull/2085.patch"},"body":"Follow https://github.com/facebook/presto/issues/1472\r\nrewrite Single Distinct Aggregation into GroupBy"},"comment":{"url":"https://api.github.com/repos/facebook/presto/issues/comments/107302699","html_url":"https://github.com/facebook/presto/pull/2085#issuecomment-107302699","issue_url":"https://api.github.com/repos/facebook/presto/issues/2085","id":107302699,"user":{"login":"xerial","id":57538,"avatar_url":"https://avatars.githubusercontent.com/u/57538?v=3","gravatar_id":"","url":"https://api.github.com/users/xerial","html_url":"https://github.com/xerial","followers_url":"https://api.github.com/users/xerial/followers","following_url":"https://api.github.com/users/xerial/following{/other_user}","gists_url":"https://api.github.com/users/xerial/gists{/gist_id}","starred_url":"https://api.github.com/users/xerial/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xerial/subscriptions","organizations_url":"https://api.github.com/users/xerial/orgs","repos_url":"https://api.github.com/users/xerial/repos","events_url":"https://api.github.com/users/xerial/events{/privacy}","received_events_url":"https://api.github.com/users/xerial/received_events","type":"User","site_admin":false},"created_at":"2015-06-01T04:36:36Z","updated_at":"2015-06-01T04:36:36Z","body":"@zhenxiao \r\nWe have experienced 2-3x slowdown of `count(distinct x)` queries with this optimization. Could you explain in what situation is this effective? "}}