{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/presto/issues/4565","repository_url":"https://api.github.com/repos/facebook/presto","labels_url":"https://api.github.com/repos/facebook/presto/issues/4565/labels{/name}","comments_url":"https://api.github.com/repos/facebook/presto/issues/4565/comments","events_url":"https://api.github.com/repos/facebook/presto/issues/4565/events","html_url":"https://github.com/facebook/presto/pull/4565","id":134159545,"number":4565,"title":"Optimize some TupleDomains to produce fewer expressions","user":{"login":"raghavsethi","id":715788,"avatar_url":"https://avatars.githubusercontent.com/u/715788?v=3","gravatar_id":"","url":"https://api.github.com/users/raghavsethi","html_url":"https://github.com/raghavsethi","followers_url":"https://api.github.com/users/raghavsethi/followers","following_url":"https://api.github.com/users/raghavsethi/following{/other_user}","gists_url":"https://api.github.com/users/raghavsethi/gists{/gist_id}","starred_url":"https://api.github.com/users/raghavsethi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raghavsethi/subscriptions","organizations_url":"https://api.github.com/users/raghavsethi/orgs","repos_url":"https://api.github.com/users/raghavsethi/repos","events_url":"https://api.github.com/users/raghavsethi/events{/privacy}","received_events_url":"https://api.github.com/users/raghavsethi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/facebook/presto/labels/CLA%20Signed","name":"CLA Signed","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"erichwang","id":737851,"avatar_url":"https://avatars.githubusercontent.com/u/737851?v=3","gravatar_id":"","url":"https://api.github.com/users/erichwang","html_url":"https://github.com/erichwang","followers_url":"https://api.github.com/users/erichwang/followers","following_url":"https://api.github.com/users/erichwang/following{/other_user}","gists_url":"https://api.github.com/users/erichwang/gists{/gist_id}","starred_url":"https://api.github.com/users/erichwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erichwang/subscriptions","organizations_url":"https://api.github.com/users/erichwang/orgs","repos_url":"https://api.github.com/users/erichwang/repos","events_url":"https://api.github.com/users/erichwang/events{/privacy}","received_events_url":"https://api.github.com/users/erichwang/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-02-17T02:38:56Z","updated_at":"2016-02-25T20:03:06Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/facebook/presto/pulls/4565","html_url":"https://github.com/facebook/presto/pull/4565","diff_url":"https://github.com/facebook/presto/pull/4565.diff","patch_url":"https://github.com/facebook/presto/pull/4565.patch"},"body":"Optimizations convert NOT IN queries to discontinuous ranges. For\r\nexample, NOT IN (1, 2, 3) turns into <1 || (>1 && <2) || >3. Queries\r\nwith a large number of values in the IN list become slow (or in some\r\ncases generated classes that were too large) as a result of this.\r\n\r\nAdded an optimization to convert ranges into expressions with NOT INs\r\nif doing so would produce fewer expressions.\r\n\r\nFixes #4434."},"comment":{"url":"https://api.github.com/repos/facebook/presto/issues/comments/188955219","html_url":"https://github.com/facebook/presto/pull/4565#issuecomment-188955219","issue_url":"https://api.github.com/repos/facebook/presto/issues/4565","id":188955219,"user":{"login":"raghavsethi","id":715788,"avatar_url":"https://avatars.githubusercontent.com/u/715788?v=3","gravatar_id":"","url":"https://api.github.com/users/raghavsethi","html_url":"https://github.com/raghavsethi","followers_url":"https://api.github.com/users/raghavsethi/followers","following_url":"https://api.github.com/users/raghavsethi/following{/other_user}","gists_url":"https://api.github.com/users/raghavsethi/gists{/gist_id}","starred_url":"https://api.github.com/users/raghavsethi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raghavsethi/subscriptions","organizations_url":"https://api.github.com/users/raghavsethi/orgs","repos_url":"https://api.github.com/users/raghavsethi/repos","events_url":"https://api.github.com/users/raghavsethi/events{/privacy}","received_events_url":"https://api.github.com/users/raghavsethi/received_events","type":"User","site_admin":false},"created_at":"2016-02-25T20:03:06Z","updated_at":"2016-02-25T20:03:06Z","body":"@erichwang ready for (hopefully) the final review"}}