{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/9167","labels_url":"https://api.github.com/repos/apache/spark/issues/9167/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/9167/comments","events_url":"https://api.github.com/repos/apache/spark/issues/9167/events","html_url":"https://github.com/apache/spark/pull/9167","id":112083603,"number":9167,"title":"[SPARK-11179] [SQL] Push filters through aggregate","user":{"login":"nitin2goyal","id":4218157,"avatar_url":"https://avatars.githubusercontent.com/u/4218157?v=3","gravatar_id":"","url":"https://api.github.com/users/nitin2goyal","html_url":"https://github.com/nitin2goyal","followers_url":"https://api.github.com/users/nitin2goyal/followers","following_url":"https://api.github.com/users/nitin2goyal/following{/other_user}","gists_url":"https://api.github.com/users/nitin2goyal/gists{/gist_id}","starred_url":"https://api.github.com/users/nitin2goyal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nitin2goyal/subscriptions","organizations_url":"https://api.github.com/users/nitin2goyal/orgs","repos_url":"https://api.github.com/users/nitin2goyal/repos","events_url":"https://api.github.com/users/nitin2goyal/events{/privacy}","received_events_url":"https://api.github.com/users/nitin2goyal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2015-10-19T06:55:38Z","updated_at":"2015-10-21T07:11:58Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/9167","html_url":"https://github.com/apache/spark/pull/9167","diff_url":"https://github.com/apache/spark/pull/9167.diff","patch_url":"https://github.com/apache/spark/pull/9167.patch"},"body":"Push conjunctive predicates though Aggregate operators when their references are a subset of the groupingExpressions.\r\n    \r\nQuery plan before optimisation :-\r\nFilter ((c#138L = 2) && (a#0 = 3))\r\n Aggregate [a#0], [a#0,count(b#1) AS c#138L]\r\n  Project [a#0,b#1]\r\n   LocalRelation [a#0,b#1,c#2]\r\n    \r\nQuery plan after optimisation :-\r\nFilter (c#138L = 2)\r\n Aggregate [a#0], [a#0,count(b#1) AS c#138L]\r\n  Filter (a#0 = 3)\r\n   Project [a#0,b#1]\r\n    LocalRelation [a#0,b#1,c#2]"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/149801005","html_url":"https://github.com/apache/spark/pull/9167#issuecomment-149801005","issue_url":"https://api.github.com/repos/apache/spark/issues/9167","id":149801005,"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-10-21T07:11:58Z","updated_at":"2015-10-21T07:11:58Z","body":"Test PASSed.\nRefer to this link for build results (access rights to CI server needed): \nhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/44041/\nTest PASSed."}}