{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/10542","labels_url":"https://api.github.com/repos/apache/spark/issues/10542/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/10542/comments","events_url":"https://api.github.com/repos/apache/spark/issues/10542/events","html_url":"https://github.com/apache/spark/pull/10542","id":124521608,"number":10542,"title":"[SPARK-12594] [SQL] Outer Join Elimination by Filter Conditions","user":{"login":"gatorsmile","id":11567269,"avatar_url":"https://avatars.githubusercontent.com/u/11567269?v=3","gravatar_id":"","url":"https://api.github.com/users/gatorsmile","html_url":"https://github.com/gatorsmile","followers_url":"https://api.github.com/users/gatorsmile/followers","following_url":"https://api.github.com/users/gatorsmile/following{/other_user}","gists_url":"https://api.github.com/users/gatorsmile/gists{/gist_id}","starred_url":"https://api.github.com/users/gatorsmile/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gatorsmile/subscriptions","organizations_url":"https://api.github.com/users/gatorsmile/orgs","repos_url":"https://api.github.com/users/gatorsmile/repos","events_url":"https://api.github.com/users/gatorsmile/events{/privacy}","received_events_url":"https://api.github.com/users/gatorsmile/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2016-01-01T00:28:17Z","updated_at":"2016-01-03T21:49:12Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/10542","html_url":"https://github.com/apache/spark/pull/10542","diff_url":"https://github.com/apache/spark/pull/10542.diff","patch_url":"https://github.com/apache/spark/pull/10542.patch"},"body":"Conversion of outer joins, if the predicates in filter conditions can restrict the result sets so that all null-supplying rows are eliminated. \r\n\r\n- `full outer` -> `inner` if both sides have such predicates\r\n- `left outer` -> `inner` if the right side has such predicates\r\n- `right outer` -> `inner` if the left side has such predicates\r\n- `full outer` -> `left outer` if only the left side has such predicates\r\n- `full outer` -> `right outer` if only the right side has such predicates\r\n\r\nIf applicable, this can greatly improve the performance, since outer join is much slower than inner join, full outer join is much slower than left/right outer join. "},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/168543158","html_url":"https://github.com/apache/spark/pull/10542#issuecomment-168543158","issue_url":"https://api.github.com/repos/apache/spark/issues/10542","id":168543158,"user":{"login":"AmplabJenkins","id":4031291,"avatar_url":"https://avatars.githubusercontent.com/u/4031291?v=3","gravatar_id":"","url":"https://api.github.com/users/AmplabJenkins","html_url":"https://github.com/AmplabJenkins","followers_url":"https://api.github.com/users/AmplabJenkins/followers","following_url":"https://api.github.com/users/AmplabJenkins/following{/other_user}","gists_url":"https://api.github.com/users/AmplabJenkins/gists{/gist_id}","starred_url":"https://api.github.com/users/AmplabJenkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmplabJenkins/subscriptions","organizations_url":"https://api.github.com/users/AmplabJenkins/orgs","repos_url":"https://api.github.com/users/AmplabJenkins/repos","events_url":"https://api.github.com/users/AmplabJenkins/events{/privacy}","received_events_url":"https://api.github.com/users/AmplabJenkins/received_events","type":"User","site_admin":false},"created_at":"2016-01-03T21:49:12Z","updated_at":"2016-01-03T21:49:12Z","body":"Merged build finished. Test FAILed."}}