{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/10454","labels_url":"https://api.github.com/repos/apache/spark/issues/10454/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/10454/comments","events_url":"https://api.github.com/repos/apache/spark/issues/10454/events","html_url":"https://github.com/apache/spark/pull/10454","id":123714890,"number":10454,"title":"[SPARK-12505] [SQL] Pushdown a Limit on top of an Outer-Join","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":3,"created_at":"2015-12-23T19:54:56Z","updated_at":"2015-12-23T21:33:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/10454","html_url":"https://github.com/apache/spark/pull/10454","diff_url":"https://github.com/apache/spark/pull/10454.diff","patch_url":"https://github.com/apache/spark/pull/10454.patch"},"body":"\"Rule that applies to a Limit on top of an OUTER Join. The original Limit won't go away after applying this rule, but additional Limit node(s) will be created on top of the outer-side child (or children if it's a FULL OUTER Join). \"\r\n– from https://issues.apache.org/jira/browse/CALCITE-832\r\n\r\nAlso, the same topic in Hive: https://issues.apache.org/jira/browse/HIVE-11684 This has been merged to HIVE. "},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/166993610","html_url":"https://github.com/apache/spark/pull/10454#issuecomment-166993610","issue_url":"https://api.github.com/repos/apache/spark/issues/10454","id":166993610,"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":"2015-12-23T21:33:50Z","updated_at":"2015-12-23T21:33:50Z","body":"Merged build finished. Test PASSed."}}