{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/11422","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/11422/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/11422/comments","events_url":"https://api.github.com/repos/apache/spark/issues/11422/events","html_url":"https://github.com/apache/spark/pull/11422","id":137147908,"number":11422,"title":"[SPARK-13544] [SQL] Rewrite/Propagate Constraints for Aliases in Aggregate and Windows","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":4,"created_at":"2016-02-29T04:33:07Z","updated_at":"2016-02-29T05:58:03Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/11422","html_url":"https://github.com/apache/spark/pull/11422","diff_url":"https://github.com/apache/spark/pull/11422.diff","patch_url":"https://github.com/apache/spark/pull/11422.patch"},"body":"#### What changes were proposed in this pull request?\r\n\r\nAfter analysis by Analyzer, three operators could have alias. They are `Project`, `Aggregate` and `Window`. So far, we only rewrite and propagate constraints if `Alias` is defined in `Project`. This PR is to resolve this issue in `Aggregate` and `Window`.\r\n\r\n#### How was this patch tested?\r\n\r\nAdded a test case for `Aggregate` in `ConstraintPropagationSuite`. We do not have a DSL for `Window`. It is a little bit tedious to add such a similar case for `Windows`. Could we skip it? : )\r\n\r\n@marmbrus @sameeragarwal "},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/190057230","html_url":"https://github.com/apache/spark/pull/11422#issuecomment-190057230","issue_url":"https://api.github.com/repos/apache/spark/issues/11422","id":190057230,"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-29T05:58:03Z","updated_at":"2016-02-29T05:58:03Z","body":"Merged build finished. Test FAILed."}}