0 Replies Latest reply on Apr 28, 2013 2:25 PM by XYZ123

    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?