{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/5770","labels_url":"https://api.github.com/repos/apache/spark/issues/5770/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/5770/comments","events_url":"https://api.github.com/repos/apache/spark/issues/5770/events","html_url":"https://github.com/apache/spark/pull/5770","id":71791042,"number":5770,"title":"[SPARK-7225][SQL] CombineLimits optimizer does not work","user":{"login":"DoingDone9","id":7529754,"avatar_url":"https://avatars.githubusercontent.com/u/7529754?v=3","gravatar_id":"","url":"https://api.github.com/users/DoingDone9","html_url":"https://github.com/DoingDone9","followers_url":"https://api.github.com/users/DoingDone9/followers","following_url":"https://api.github.com/users/DoingDone9/following{/other_user}","gists_url":"https://api.github.com/users/DoingDone9/gists{/gist_id}","starred_url":"https://api.github.com/users/DoingDone9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DoingDone9/subscriptions","organizations_url":"https://api.github.com/users/DoingDone9/orgs","repos_url":"https://api.github.com/users/DoingDone9/repos","events_url":"https://api.github.com/users/DoingDone9/events{/privacy}","received_events_url":"https://api.github.com/users/DoingDone9/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-04-29T06:27:03Z","updated_at":"2015-04-30T05:23:46Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/5770","html_url":"https://github.com/apache/spark/pull/5770","diff_url":"https://github.com/apache/spark/pull/5770.diff","patch_url":"https://github.com/apache/spark/pull/5770.patch"},"body":"SQL \r\n```\r\nselect key from (select key from src limit 100) t2 limit 10\r\n```\r\nOptimized Logical Plan before modifying\r\n```\r\n== Optimized Logical Plan ==\r\nLimit 10\r\nLimit 100\r\nProject key#3\r\nMetastoreRelation default, src, None\r\n```\r\nOptimized Logical Plan after modifying\r\n```\r\n== Optimized Logical Plan ==\r\nLimit 10\r\n Project [key#1]\r\n  MetastoreRelation default, src, None\r\n```"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/97665316","html_url":"https://github.com/apache/spark/pull/5770#issuecomment-97665316","issue_url":"https://api.github.com/repos/apache/spark/issues/5770","id":97665316,"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-04-30T05:23:46Z","updated_at":"2015-04-30T05:23: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/31377/\nTest PASSed."}}