You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2018/07/08 21:29:00 UTC
[jira] [Commented] (CALCITE-2366) Add support for ANY_VALUE
function
[ https://issues.apache.org/jira/browse/CALCITE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16536414#comment-16536414 ]
Julian Hyde commented on CALCITE-2366:
--------------------------------------
I reviewed, and it looks good. Just a couple of things to complete it:
* Add doc to reference.md. Make a note that it is not standard SQL.
* Get it to a state that it can run a query in agg.iq. I don't care how efficient the implementation is - you could just use MinMaxImplemento, for instance.
> Add support for ANY_VALUE function
> ----------------------------------
>
> Key: CALCITE-2366
> URL: https://issues.apache.org/jira/browse/CALCITE-2366
> Project: Calcite
> Issue Type: New Feature
> Affects Versions: 1.16.0
> Reporter: Gautam Kumar Parai
> Assignee: Gautam Kumar Parai
> Priority: Major
> Fix For: 1.17.0
>
>
> We had discussions on the Apache Calcite [1] and Apache Drill [2] mailing lists regarding an equivalent for DISTINCT ON. The community seems to prefer the ANY_VALUE. This Jira is a placeholder for implementing the ANY_VALUE aggregate function in Apache Calcite.
> [1]https://lists.apache.org/thread.html/f2007a489d3a5741875bcc8a1edd8d5c3715e5114ac45058c3b3a42d@%3Cdev.calcite.apache.org%3E
> [2]https://lists.apache.org/thread.html/2517eef7410aed4e88b9515f7e4256335215c1ad39a2676a08d21cb9@%3Cdev.drill.apache.org%3E
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)