Also this query in Calcite :
"select * from ("
+ "select s.orders.productid , avg(units) OVER (product
ROWS BETWEEN 10 PRECEDING and 5 FOLLOWING)" + " as m10, "
+ "AVG(units) OVER (product RANGE INTERVAL '7' DAY
PRECEDING) AS d7 "
Hi,
I was wondering if there is any possible way to define windows with SQl in
Calcite for queries that don't have an aggregate function? For example, I
want to define the queries from Linear Road Benchmark of the STREAM project
(http://infolab.stanford.edu/stream/cql-benchmark.html):
1)
SELECT