{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/22518","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/22518/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/22518/comments","events_url":"https://api.github.com/repos/apache/spark/issues/22518/events","html_url":"https://github.com/apache/spark/pull/22518","id":362615598,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE3MjgzNTU4","number":22518,"title":"[SPARK-25482][SQL] Avoid pushdown of subqueries to data source filters","user":{"login":"mgaido91","id":8821783,"node_id":"MDQ6VXNlcjg4MjE3ODM=","avatar_url":"https://avatars1.githubusercontent.com/u/8821783?v=4","gravatar_id":"","url":"https://api.github.com/users/mgaido91","html_url":"https://github.com/mgaido91","followers_url":"https://api.github.com/users/mgaido91/followers","following_url":"https://api.github.com/users/mgaido91/following{/other_user}","gists_url":"https://api.github.com/users/mgaido91/gists{/gist_id}","starred_url":"https://api.github.com/users/mgaido91/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mgaido91/subscriptions","organizations_url":"https://api.github.com/users/mgaido91/orgs","repos_url":"https://api.github.com/users/mgaido91/repos","events_url":"https://api.github.com/users/mgaido91/events{/privacy}","received_events_url":"https://api.github.com/users/mgaido91/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":18,"created_at":"2018-09-21T13:26:03Z","updated_at":"2018-11-13T17:52:59Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/22518","html_url":"https://github.com/apache/spark/pull/22518","diff_url":"https://github.com/apache/spark/pull/22518.diff","patch_url":"https://github.com/apache/spark/pull/22518.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nAn expressions with a subquery can be pushed down as a data source filter. Despite the filter is not actively used, this causes anyway a re-execution of the subquery becuase the `ReuseSubquery` optimization rule is ineffective in this case.\r\n\r\nThe PR avoids this problem by forbidding the push down of filters containing a subquery.\r\n## How was this patch tested?\r\n\r\nadded UT"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/438370977","html_url":"https://github.com/apache/spark/pull/22518#issuecomment-438370977","issue_url":"https://api.github.com/repos/apache/spark/issues/22518","id":438370977,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODM3MDk3Nw==","user":{"login":"cloud-fan","id":3182036,"node_id":"MDQ6VXNlcjMxODIwMzY=","avatar_url":"https://avatars3.githubusercontent.com/u/3182036?v=4","gravatar_id":"","url":"https://api.github.com/users/cloud-fan","html_url":"https://github.com/cloud-fan","followers_url":"https://api.github.com/users/cloud-fan/followers","following_url":"https://api.github.com/users/cloud-fan/following{/other_user}","gists_url":"https://api.github.com/users/cloud-fan/gists{/gist_id}","starred_url":"https://api.github.com/users/cloud-fan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloud-fan/subscriptions","organizations_url":"https://api.github.com/users/cloud-fan/orgs","repos_url":"https://api.github.com/users/cloud-fan/repos","events_url":"https://api.github.com/users/cloud-fan/events{/privacy}","received_events_url":"https://api.github.com/users/cloud-fan/received_events","type":"User","site_admin":false},"created_at":"2018-11-13T17:52:59Z","updated_at":"2018-11-13T17:52:59Z","author_association":"CONTRIBUTOR","body":"thanks, merging to master!"}}
{"actor":{"display_login":"cloud-fan"}}