Forum Stats

  • 3,875,482 Users
  • 2,266,929 Discussions


Partition By Query Problem

Hi everyone,

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?

This discussion has been closed.