The documentation of windowed aggregates is minimal, because Calcite
just follows the SQL standard. What works in standards-compliant
databases, such as Oracle and PostgreSQL, will typically work in
Calcite.
Here is an example of a time window query:
SELECT deptno,
empno,
COUNT(*) OVER (ORDER
I'm close to getting something working for the case of two tables. I don't
think it should be too challenging to extend to multiple tables. The gist
of the approach is to match a Join over two TableScans and then use
JoinToMultiJoin rule to get a MultiJoin instance. This is useful because
it's much
Thanks to everyone who has tested the release candidate and given
their comments and votes.
The tally is as follows.
4 +1s (all binding):
Alan Gates
James Taylor
Josh Elser
Julian Hyde
No 0s or -1s.
Therefore I am delighted to announce that the proposal to release
Apache Calcite 1.8.0 has passe
