You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2021/01/26 09:27:02 UTC
[GitHub] [druid] dbsd11 opened a new issue #10800: Do druid.io sql query support group_concat?
dbsd11 opened a new issue #10800:
URL: https://github.com/apache/druid/issues/10800
Try to build single result of group by result on string column, but it doesn't works and reports error: No match found for function signature group_count(< CHARACTER >)
Query sql example is below:
select group_concat(b) from (select 'aa' as a, 'bb' as b UNION ALL (select 'aa' as a, 'bbb' as b)) group by a;
Error: Unknown exception
org.apache.calcite.runtime.CalciteContextException: From line 5, column 8 to line 5, column 22: No match found for function signature group_concat(<CHARACTER>)
org.apache.calcite.tools.ValidationException
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] jihoonson commented on issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
jihoonson commented on issue #10800:
URL: https://github.com/apache/druid/issues/10800#issuecomment-767973731
Hi @dbsd11, `group_concat` is not supported yet as @abhishekagarwal87 mentioned. You can see what functions are supported in https://druid.apache.org/docs/latest/querying/sql.html.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] abhishekagarwal87 commented on issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
abhishekagarwal87 commented on issue #10800:
URL: https://github.com/apache/druid/issues/10800#issuecomment-767517328
There is no support from the `group_concat` function as of today. One challenge with implementing such a function is that size of the aggregated value is not constant across rows. Users can pass a maximum size as input but that can lead to inefficient usage of memory since druid also doesn't support growable buffers as of yet.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dbsd11 closed issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
dbsd11 closed issue #10800:
URL: https://github.com/apache/druid/issues/10800
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dbsd11 commented on issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
dbsd11 commented on issue #10800:
URL: https://github.com/apache/druid/issues/10800#issuecomment-767995423
I see. Thank you for your answer. Can I implement this through custom aggregation plugin?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dbsd11 closed issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
dbsd11 closed issue #10800:
URL: https://github.com/apache/druid/issues/10800
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dbsd11 commented on issue #10800: Does druid.io sql query support group_concat?
Posted by GitBox <gi...@apache.org>.
dbsd11 commented on issue #10800:
URL: https://github.com/apache/druid/issues/10800#issuecomment-770691206
I implement druid.io group_concat by custom avatia client. Firstly, execute sql without group_concat. Then, group_concat results at client. Can druid.io avatica server implement this function, rather than by user client?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org