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 describe your use case in more detail, we might be able to point you to some constructs in Siddhi language that would let you achieve the 'order by' characteristics of a standard SQL query. [1] https://docs.wso2.com/display/CEP400/Inbuilt+Windows#InbuiltWindows-sortsort [2] https://github.com/wso2/siddhi/blob/master/modules/siddhi-core/src/test/java/org/wso2/siddhi/core/query/window/SortWindowTestCase.java Thanks, Lasantha On 24 September 2015 at 18:13, Maheshakya Wijewardena <[email protected]> wrote: > 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: [email protected] > Mobile: +94711228855 > > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Lasantha Fernando* Senior Software Engineer - Data Technologies Team WSO2 Inc. http://wso2.com email: [email protected] mobile: (+94) 71 5247551
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
