[CALCITE-476] Support distinct aggregates in window functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0-incubating
• Fix Version/s: 1.13.0
• Assignee: Julian Hyde
• Reporter: Vladimir Sitnikov
• Created: 22/Nov/14 17:28
• Updated: 27/Feb/24 22:24
• Resolved: 24/Apr/17 22:56

Description

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?

Issue Links

• is duplicated by: CALCITE-1740 Distinct aggregate flag in window function