0 Replies Latest reply: Apr 28, 2013 9:25 AM by XYZ123 RSS

    Partition By Query Problem

    XYZ123
      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.