[Dev] [CEP] "order by" clause in SiddhiQL

Hi, Does SiddhiQL support "ORDER BY" statement? I couldn't find that in the documentation[1]. Best regards, [1] https://docs.wso2.com/display/CEP400/SiddhiQL+Guide+3.0 -- Pruthuvi Maheshakya Wijewardena Software Engineer WSO2 : http://wso2.com/ Email: mahesha...@wso2.com Mobile: +94711228855

Re: [Dev] [CEP] "order by" clause in SiddhiQL

Hi Maheshakya, Ordering of events for real-time analytics need to be done within a time frame or an event frame. Siddhi does have a sort window processor that can be used to sort events within the window itself. You can find the documentation at [1] or refer to our test cases at [2]. If you can

Re: [Dev] [CEP] "order by" clause in SiddhiQL

Hi Lasantha, Thank you for the references. What I want to is something similar to the following: Suppose you have an input stream and there are multiple number of processing logics. Each logic will generate a result after consuming the events the stream. What I'm trying to do is obtaining the

Re: [Dev] [CEP] "order by" clause in SiddhiQL

> > An approach to do this is: first group by each result, then order by the > descending order of the count of each result and finally retrieving the > first entry from that. > Sorry, the approach should be as follows: First group by result, then order by the descending order of the count of

Re: [Dev] [CEP] "order by" clause in SiddhiQL

I think this can be achieved using https://docs.wso2.com/display/CEP400/Inbuilt+Windows#InbuiltWindows-sortsort As this will collect sort and output the max or min value. Suho On Thu, Sep 24, 2015 at 9:58 PM, Maheshakya Wijewardena wrote: > An approach to do this is: