I'm trying to print out for every 5 seconds; the average value of each stock's price for last 10 seconds. The query shoud look like this:
select price, avg(price) from stockInputChannel [partition by stockName range 10 slide 5]
BUT, OCEP's CQL does not suppport this kind of query. It warns me to use "partition by $partname rows $rownumber range $rangevalue slide $slidevalue". As I mentioned above I do not need row related query, parameter.. Why the CQL forces me to use that?