You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "duan xiong (Jira)" <ji...@apache.org> on 2021/06/23 23:40:00 UTC
[jira] [Comment Edited] (CALCITE-4661) Add MODE aggregate function
[ https://issues.apache.org/jira/browse/CALCITE-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17368300#comment-17368300 ]
duan xiong edited comment on CALCITE-4661 at 6/23/21, 11:39 PM:
----------------------------------------------------------------
Ok. If let's keep it simple, This MODE function becomes a normal(Still an AggFunction) function. SQL examples
like
{code:java}
select mode(columnName) from table.
{code}
and return the common value in the column. If no other mistakes, I will do it this way.
was (Author: nobigo):
Ok. If we let's keep it simple, This MODE function becomes a normal(Still an AggFunction) function. SQL examples
like
{code:java}
select mode(columnName) from table.
{code}
and return the common value in the column. If no other mistakes, I will do it this way.
> Add MODE aggregate function
> ---------------------------
>
> Key: CALCITE-4661
> URL: https://issues.apache.org/jira/browse/CALCITE-4661
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: duan xiong
> Assignee: duan xiong
> Priority: Major
>
> Add MODE functions in the operator table which returns the most frequent input value (arbitrarily choosing the first one if there are multiple equally-frequent results)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)