{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/9123","labels_url":"https://api.github.com/repos/apache/spark/issues/9123/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/9123/comments","events_url":"https://api.github.com/repos/apache/spark/issues/9123/events","html_url":"https://github.com/apache/spark/pull/9123","id":111506418,"number":9123,"title":"[SPARK-10534][SQL] ORDER BY clause allows only columns that are present in the select projection list","user":{"login":"dilipbiswal","id":14225158,"avatar_url":"https://avatars.githubusercontent.com/u/14225158?v=3","gravatar_id":"","url":"https://api.github.com/users/dilipbiswal","html_url":"https://github.com/dilipbiswal","followers_url":"https://api.github.com/users/dilipbiswal/followers","following_url":"https://api.github.com/users/dilipbiswal/following{/other_user}","gists_url":"https://api.github.com/users/dilipbiswal/gists{/gist_id}","starred_url":"https://api.github.com/users/dilipbiswal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dilipbiswal/subscriptions","organizations_url":"https://api.github.com/users/dilipbiswal/orgs","repos_url":"https://api.github.com/users/dilipbiswal/repos","events_url":"https://api.github.com/users/dilipbiswal/events{/privacy}","received_events_url":"https://api.github.com/users/dilipbiswal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-10-14T22:25:01Z","updated_at":"2015-10-15T18:53:44Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/9123","html_url":"https://github.com/apache/spark/pull/9123","diff_url":"https://github.com/apache/spark/pull/9123.diff","patch_url":"https://github.com/apache/spark/pull/9123.patch"},"body":"Find out the missing attributes by recursively looking\r\nat the sort order expression and rest of the code\r\ntakes care of projecting them out.\r\n\r\nAdded description from @cloud-fan \r\n\r\nI wanna explain a bit more about this bug.\r\n\r\nWhen we resolve sort ordering, we will use a special method, which only resolves UnresolvedAttributes and UnresolvedExtractValue. However, for something like Floor('a), even the 'a is resolved, the floor expression may still being unresolved as data type mismatch(for example, 'a is string type and Floor need double type), thus can't pass this filter, and we can't push down this missing attribute 'a"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/148487314","html_url":"https://github.com/apache/spark/pull/9123#issuecomment-148487314","issue_url":"https://api.github.com/repos/apache/spark/issues/9123","id":148487314,"user":{"login":"SparkQA","id":8108735,"avatar_url":"https://avatars.githubusercontent.com/u/8108735?v=3","gravatar_id":"","url":"https://api.github.com/users/SparkQA","html_url":"https://github.com/SparkQA","followers_url":"https://api.github.com/users/SparkQA/followers","following_url":"https://api.github.com/users/SparkQA/following{/other_user}","gists_url":"https://api.github.com/users/SparkQA/gists{/gist_id}","starred_url":"https://api.github.com/users/SparkQA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SparkQA/subscriptions","organizations_url":"https://api.github.com/users/SparkQA/orgs","repos_url":"https://api.github.com/users/SparkQA/repos","events_url":"https://api.github.com/users/SparkQA/events{/privacy}","received_events_url":"https://api.github.com/users/SparkQA/received_events","type":"User","site_admin":false},"created_at":"2015-10-15T18:53:44Z","updated_at":"2015-10-15T18:53:44Z","body":"  [Test build #43802 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/43802/consoleFull) for   PR 9123 at commit [`4f162ed`](https://github.com/apache/spark/commit/4f162edae1201179817067a2fef1d469e45283a6)."}}