{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/11248","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/11248/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/11248/comments","events_url":"https://api.github.com/repos/apache/spark/issues/11248/events","html_url":"https://github.com/apache/spark/pull/11248","id":134504913,"number":11248,"title":"[SPARK-13373] [SQL] generate sort merge join","user":{"login":"davies","id":40902,"avatar_url":"https://avatars.githubusercontent.com/u/40902?v=3","gravatar_id":"","url":"https://api.github.com/users/davies","html_url":"https://github.com/davies","followers_url":"https://api.github.com/users/davies/followers","following_url":"https://api.github.com/users/davies/following{/other_user}","gists_url":"https://api.github.com/users/davies/gists{/gist_id}","starred_url":"https://api.github.com/users/davies/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davies/subscriptions","organizations_url":"https://api.github.com/users/davies/orgs","repos_url":"https://api.github.com/users/davies/repos","events_url":"https://api.github.com/users/davies/events{/privacy}","received_events_url":"https://api.github.com/users/davies/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2016-02-18T07:43:20Z","updated_at":"2016-02-23T18:55:57Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/11248","html_url":"https://github.com/apache/spark/pull/11248","diff_url":"https://github.com/apache/spark/pull/11248.diff","patch_url":"https://github.com/apache/spark/pull/11248.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nGenerates code for SortMergeJoin.\r\n\r\n## How was the this patch tested?\r\n\r\nUnit tests and manually tested with TPCDS Q72, which showed 70% performance improvements (from 42s to 25s), but micro benchmark only show minor improvements, it may depends the distribution of data and number of columns."},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/187840884","html_url":"https://github.com/apache/spark/pull/11248#issuecomment-187840884","issue_url":"https://api.github.com/repos/apache/spark/issues/11248","id":187840884,"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-02-23T18:55:56Z","updated_at":"2016-02-23T18:55:56Z","body":"Merged build finished. Test PASSed."}}