Partition By Query Problem

XYZ123 Apr 28, 2013 7:25 AM

Currently Being Moderated

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?

Thanks.