Description
When parsing queries such as
SELECT B1, SUM(DISTINCT B2) OVER (ORDER BY B4 RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) FROM T
The aggregates in the LogicalWindow do not have any marker of being distinct.
isDistinct() flag is not set. Probably some rule(s) silently swallow the DISTINCT keyword
The LogicalWindow object that result is
LogicalWindow(window#0=[window(partition {} order by [2] range between $3 PRECEDING and CURRENT ROW aggs [COUNT($1), $SUM0($1)])])
Attachments
Issue Links
- duplicates
-
CALCITE-476 Support distinct aggregates in window functions
-
- Closed
-