{"action":"created","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/333","repository_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/333/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/333/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/333/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/333","id":192026813,"number":333,"title":"Not implemented? SQLSubqueryTableSource cannot be cast to SQLJoinTableSource","user":{"login":"elyday","id":6017390,"avatar_url":"https://avatars.githubusercontent.com/u/6017390?v=3","gravatar_id":"","url":"https://api.github.com/users/elyday","html_url":"https://github.com/elyday","followers_url":"https://api.github.com/users/elyday/followers","following_url":"https://api.github.com/users/elyday/following{/other_user}","gists_url":"https://api.github.com/users/elyday/gists{/gist_id}","starred_url":"https://api.github.com/users/elyday/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elyday/subscriptions","organizations_url":"https://api.github.com/users/elyday/orgs","repos_url":"https://api.github.com/users/elyday/repos","events_url":"https://api.github.com/users/elyday/events{/privacy}","received_events_url":"https://api.github.com/users/elyday/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-11-28T14:57:51Z","updated_at":"2016-11-30T03:26:55Z","closed_at":null,"body":"Hi\r\n\r\ni want to use two select queries in one query with ( ).\r\nThe SQL Query looks like:\r\n```\r\nSELECT * FROM (\r\n\tSELECT column, column2, column3, column4, SUM(column5) AS column6\r\n\tFROM jdbc\r\n  \tWHERE column2 >= 2016 AND column2 <= 2016 AND column3 = 'BIA' AND column4 IS NULL\r\n  \tGROUP BY column, column2, column3, column4\r\n) WHERE column6 = 13315\r\n```\r\n\r\nThe Stacktrace say this:\r\n```\r\n{\"error\":{\"root_cause\":[{\"type\":\"class_cast_exception\",\"reason\":\"com.alibaba.druid.sql.ast.statement.SQLSubqueryTableSource cannot be cast to com.alibaba.druid.sql.ast.statement.SQLJoinTableSource\"}],\"type\":\"class_cast_exception\",\"reason\":\"com.alibaba.druid.sql.ast.statement.SQLSubqueryTableSource cannot be cast to com.alibaba.druid.sql.ast.statement.SQLJoinTableSource\"},\"status\":500}\r\n```\r\n\r\nHave i an error in my sql query? Or is this not implemented yet?\r\n\r\nGreetings"},"comment":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/comments/263773222","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/333#issuecomment-263773222","issue_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/333","id":263773222,"user":{"login":"allwefantasy","id":797758,"avatar_url":"https://avatars.githubusercontent.com/u/797758?v=3","gravatar_id":"","url":"https://api.github.com/users/allwefantasy","html_url":"https://github.com/allwefantasy","followers_url":"https://api.github.com/users/allwefantasy/followers","following_url":"https://api.github.com/users/allwefantasy/following{/other_user}","gists_url":"https://api.github.com/users/allwefantasy/gists{/gist_id}","starred_url":"https://api.github.com/users/allwefantasy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/allwefantasy/subscriptions","organizations_url":"https://api.github.com/users/allwefantasy/orgs","repos_url":"https://api.github.com/users/allwefantasy/repos","events_url":"https://api.github.com/users/allwefantasy/events{/privacy}","received_events_url":"https://api.github.com/users/allwefantasy/received_events","type":"User","site_admin":false},"created_at":"2016-11-30T03:26:54Z","updated_at":"2016-11-30T03:26:54Z","body":"If  wanna sql supports join,subquery,  you may try es-hadoop project which\r\nprovide spark-sql support\r\n\r\nOn Tue, Nov 29, 2016 at 10:51 PM, Lars <notifications@github.com> wrote:\r\n\r\n> Okay, thats look really nice\r\n>\r\n> —\r\n> You are receiving this because you are subscribed to this thread.\r\n> Reply to this email directly, view it on GitHub\r\n> <https://github.com/NLPchina/elasticsearch-sql/issues/333#issuecomment-263590503>,\r\n> or mute the thread\r\n> <https://github.com/notifications/unsubscribe-auth/AAwsPkXwv0EAFfZo_1CGq4xSHEu-5h7xks5rDDv0gaJpZM4K93uX>\r\n> .\r\n>\r\n\r\n\r\n\r\n-- \r\nBest Regards\r\n_______________________________________________________________\r\n开阔视野      专注开发\r\nWilliamZhu   祝海林      zhuhl@csdn.net\r\n产品事业部-基础平台-搜索&数据挖掘\r\n手机：18601315052\r\nMSN：zhuhailin123@hotmail.com\r\n微博：@PrinceCharmingJ  http://weibo.com/PrinceCharmingJ\r\n地址：北京市朝阳区广顺北大街33号院1号楼福码大厦B座12层\r\n_______________________________________________________________\r\nhttp://www.csdn.net                              You're the One\r\n全球最大中文IT技术社区                               一切由你开始\r\n\r\nhttp://www.iteye.net\r\n程序员深度交流社区\r\n"}}
{"actor":{"display_login":"allwefantasy"}}