{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/presto/issues/2878","labels_url":"https://api.github.com/repos/facebook/presto/issues/2878/labels{/name}","comments_url":"https://api.github.com/repos/facebook/presto/issues/2878/comments","events_url":"https://api.github.com/repos/facebook/presto/issues/2878/events","html_url":"https://github.com/facebook/presto/issues/2878","id":73912357,"number":2878,"title":"Add support for scalar subqueries","user":{"login":"lvxin1986","id":8586309,"avatar_url":"https://avatars.githubusercontent.com/u/8586309?v=3","gravatar_id":"","url":"https://api.github.com/users/lvxin1986","html_url":"https://github.com/lvxin1986","followers_url":"https://api.github.com/users/lvxin1986/followers","following_url":"https://api.github.com/users/lvxin1986/following{/other_user}","gists_url":"https://api.github.com/users/lvxin1986/gists{/gist_id}","starred_url":"https://api.github.com/users/lvxin1986/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvxin1986/subscriptions","organizations_url":"https://api.github.com/users/lvxin1986/orgs","repos_url":"https://api.github.com/users/lvxin1986/repos","events_url":"https://api.github.com/users/lvxin1986/events{/privacy}","received_events_url":"https://api.github.com/users/lvxin1986/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/facebook/presto/labels/enhancement","name":"enhancement","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-05-07T09:20:27Z","updated_at":"2015-10-29T14:06:03Z","closed_at":null,"body":"Scalar sub queries are not supported.  For example:\r\n```sql\r\nSELECT *\r\nFROM nation\r\nWHERE nation KEY >= (SELECT nation KEY FROM nation WHERE NAME ='ALGERIA' LIMIT 1)\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/facebook/presto/issues/comments/152191254","html_url":"https://github.com/facebook/presto/issues/2878#issuecomment-152191254","issue_url":"https://api.github.com/repos/facebook/presto/issues/2878","id":152191254,"user":{"login":"kokosing","id":7569403,"avatar_url":"https://avatars.githubusercontent.com/u/7569403?v=3","gravatar_id":"","url":"https://api.github.com/users/kokosing","html_url":"https://github.com/kokosing","followers_url":"https://api.github.com/users/kokosing/followers","following_url":"https://api.github.com/users/kokosing/following{/other_user}","gists_url":"https://api.github.com/users/kokosing/gists{/gist_id}","starred_url":"https://api.github.com/users/kokosing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kokosing/subscriptions","organizations_url":"https://api.github.com/users/kokosing/orgs","repos_url":"https://api.github.com/users/kokosing/repos","events_url":"https://api.github.com/users/kokosing/events{/privacy}","received_events_url":"https://api.github.com/users/kokosing/received_events","type":"User","site_admin":false},"created_at":"2015-10-29T14:06:03Z","updated_at":"2015-10-29T14:06:03Z","body":"It looks like a workaround, I am not sure about performance (execution) of it as join order may have importance here."}}