Tell me Where to use exactly in real time scenarios of tumbling, hopping and sliding? RRS feed

  • Question

  • Hi,

    I am currently working on IoT technology, in one of my scenario I used the stream analytics concept, in that there is an option like query to filter the incoming data.

    I am not much familiar to write the SQL quires.

    I don’t know what is the usage of windowing like tumbling, hopping and sliding?

    So please tell me how to use those windowing techniques in real time scenarios and where exactly used tumbling, hopping and sliding.



    Tuesday, May 17, 2016 1:27 PM


  • Hi Pradeep,

    I guess the best point to start from would be ASA Windowing.

    In general since stream data theoretically unending, one can not simply perform aggregation computations or sorting without some way of specifying subset of this unending data stream to perform computation on.

    This is where windows come to help. One may wait forever to compute Max(field1) value in a stream, while Max(field1) value in a window of 5 minutes can be computed as soon as window closes.


    Azure Stream Analytics.

    Tuesday, May 17, 2016 4:13 PM