[ 
https://issues.apache.org/jira/browse/CALCITE-476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde resolved CALCITE-476.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.13.0

Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/aed5bca7. 
(Includes parser and SQL-to-RelNode support, but engines including 
EnumerableWindow currently ignore the flag.)

Thanks for the PR, [~rtudoran]!

Duplicated by CALCITE-1740.

> Support distinct aggregates in window functions
> -----------------------------------------------
>
>                 Key: CALCITE-476
>                 URL: https://issues.apache.org/jira/browse/CALCITE-476
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.0.0-incubating
>            Reporter: Vladimir Sitnikov
>            Assignee: Julian Hyde
>             Fix For: 1.13.0
>
>
> Migrated from https://groups.google.com/forum/#!topic/optiq-dev/8xE3PriKXmI
> Does Optiq support Windowing func with Distinct?
> Ex: select avg(distinct c_int) over(PARTITION BY key ORDER BY value ROWS 
> BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as p from t1;
> Hive support Windowing functions with "Distinct" (UDAF with Distinct).
> I am using "m_cluster.getRexBuilder().makeOver" to build window.
> Optiq doesn't seems to support distinct on Windowing Functions.
> Am i missing something?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to