{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/11635","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/11635/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/11635/comments","events_url":"https://api.github.com/repos/apache/spark/issues/11635/events","html_url":"https://github.com/apache/spark/pull/11635","id":139977293,"number":11635,"title":"[SPARK-13739] [SQL] Push Predicate Through Window","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":17,"created_at":"2016-03-10T18:48:19Z","updated_at":"2016-04-20T15:29:46Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/11635","html_url":"https://github.com/apache/spark/pull/11635","diff_url":"https://github.com/apache/spark/pull/11635.diff","patch_url":"https://github.com/apache/spark/pull/11635.patch"},"body":"#### What changes were proposed in this pull request?\r\n\r\nFor performance, predicates can be pushed through Window if and only if the following conditions are satisfied:\r\n\r\n- Predicate involves one and only one column that is part of window partitioning key\r\n- Window partitioning key is just a sequence of attributeReferences. (i.e., none of them is an expression)\r\n- Predicate must be deterministic\r\n\r\n#### How was this patch tested?\r\n\r\nTODO: \r\n- [X]  DSL needs to be modified for window\r\n- [X] more tests will be added."},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/212478519","html_url":"https://github.com/apache/spark/pull/11635#issuecomment-212478519","issue_url":"https://api.github.com/repos/apache/spark/issues/11635","id":212478519,"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-04-20T15:29:46Z","updated_at":"2016-04-20T15:29:46Z","body":"Test PASSed.\nRefer to this link for build results (access rights to CI server needed): \nhttps://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/56358/\nTest PASSed."}}