[
https://issues.apache.org/jira/browse/CALCITE-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17368258#comment-17368258
]
Julian Hyde commented on CALCITE-4661:
--------------------------------------
That doesn’t make sense. The implementation can use sorting (or indeed hashing)
regardless of any sort order specified by the user.
I can see that user-specified sort order might be helpful in breaking ties. But
let’s keep it simple.
Snowflakes MODE function does not allow sorting, and in fact the documentation
explicitly says that sorting has no effect.
> Add MODE aggregate functions
> ----------------------------
>
> 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)
