-
Notifications
You must be signed in to change notification settings - Fork 1.5k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Not implemented? SQLSubqueryTableSource cannot be cast to SQLJoinTableSource #333
Comments
Hey , |
Is this on a todo list or it isn't planed to implement this? |
For the more generic idea there is none (we are not planing querying data not by elasticsearch) |
Okay, thats look really nice |
If wanna sql supports join,subquery, you may try es-hadoop project which
provide spark-sql support
…On Tue, Nov 29, 2016 at 10:51 PM, Lars ***@***.***> wrote:
Okay, thats look really nice
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#333 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AAwsPkXwv0EAFfZo_1CGq4xSHEu-5h7xks5rDDv0gaJpZM4K93uX>
.
--
Best Regards
_______________________________________________________________
开阔视野 专注开发
WilliamZhu 祝海林 zhuhl@csdn.net
产品事业部-基础平台-搜索&数据挖掘
手机:18601315052
MSN:zhuhailin123@hotmail.com
微博:@PrinceCharmingJ http://weibo.com/PrinceCharmingJ
地址:北京市朝阳区广顺北大街33号院1号楼福码大厦B座12层
_______________________________________________________________
http://www.csdn.net You're the One
全球最大中文IT技术社区 一切由你开始
http://www.iteye.net
程序员深度交流社区
|
crate这个项目底层用的也是es,看它的document,支持了sub query、group by...having以及join,希望[ealsticsearch-sql]也能赶上 |
Do we have support for HAVING clause now? I wish to run the following SQL:- select CUSTMR_ID.keyword, count(1) as count from engaged where ACTION = 'OPEN' group by CUSTMR_ID.keyword having count(1) > 4 Right now am trying to run this instead:- select * from (select CUSTMR_ID.keyword, count(1) as count from engaged where ACTION = 'OPEN' group by CUSTMR_ID.keyword) a where a.count > 4 and am getting same exception as:- {"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} |
I wish to run the following SQL: and I getting same exception as: is this not implemented yet? |
SELECT name FROM people GROUP BY name |
I wish to run the following SQL: |
Hi
i want to use two select queries in one query with ( ).
The SQL Query looks like:
The Stacktrace say this:
Have i an error in my sql query? Or is this not implemented yet?
Greetings
The text was updated successfully, but these errors were encountered: