{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/13028","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/13028/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/13028/comments","events_url":"https://api.github.com/repos/apache/spark/issues/13028/events","html_url":"https://github.com/apache/spark/pull/13028","id":154019858,"number":13028,"title":"[SPARK-9860][SQL] Join: Determine the join strategy (broadcast join or shuffle join) at runtime","user":{"login":"lianhuiwang","id":545478,"avatar_url":"https://avatars2.githubusercontent.com/u/545478?v=3","gravatar_id":"","url":"https://api.github.com/users/lianhuiwang","html_url":"https://github.com/lianhuiwang","followers_url":"https://api.github.com/users/lianhuiwang/followers","following_url":"https://api.github.com/users/lianhuiwang/following{/other_user}","gists_url":"https://api.github.com/users/lianhuiwang/gists{/gist_id}","starred_url":"https://api.github.com/users/lianhuiwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lianhuiwang/subscriptions","organizations_url":"https://api.github.com/users/lianhuiwang/orgs","repos_url":"https://api.github.com/users/lianhuiwang/repos","events_url":"https://api.github.com/users/lianhuiwang/events{/privacy}","received_events_url":"https://api.github.com/users/lianhuiwang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2016-05-10T14:26:00Z","updated_at":"2017-06-16T23:10:22Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/13028","html_url":"https://github.com/apache/spark/pull/13028","diff_url":"https://github.com/apache/spark/pull/13028.diff","patch_url":"https://github.com/apache/spark/pull/13028.patch"},"body":"## What changes were proposed in this pull request?\n1. add query fragment for execute stage according to exchange.\n2. before running no leaf query fragment, optimize plan using mapOutputStatistics of its child fragments.\n   if size of one exchange is less than autoBroadcastJoinThreshold, it transforms sort merge join to broadcast join.\n   I will support optimization for skew join in another PR.\n## How was this patch tested?\n\nunit tests\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/309159286","html_url":"https://github.com/apache/spark/pull/13028#issuecomment-309159286","issue_url":"https://api.github.com/repos/apache/spark/issues/13028","id":309159286,"user":{"login":"sameeragarwal","id":166454,"avatar_url":"https://avatars3.githubusercontent.com/u/166454?v=3","gravatar_id":"","url":"https://api.github.com/users/sameeragarwal","html_url":"https://github.com/sameeragarwal","followers_url":"https://api.github.com/users/sameeragarwal/followers","following_url":"https://api.github.com/users/sameeragarwal/following{/other_user}","gists_url":"https://api.github.com/users/sameeragarwal/gists{/gist_id}","starred_url":"https://api.github.com/users/sameeragarwal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sameeragarwal/subscriptions","organizations_url":"https://api.github.com/users/sameeragarwal/orgs","repos_url":"https://api.github.com/users/sameeragarwal/repos","events_url":"https://api.github.com/users/sameeragarwal/events{/privacy}","received_events_url":"https://api.github.com/users/sameeragarwal/received_events","type":"User","site_admin":false},"created_at":"2017-06-16T23:10:22Z","updated_at":"2017-06-16T23:10:22Z","body":"@lianhuiwang could this regress performance for existing queries? Can you please share some benchmarks with us (if any)?"}}
{"actor":{"display_login":"sameeragarwal"}}