Windowing in SQL
1. Windowing in SQL
person: Let's move now to see how we can apply streaming concepts like windowing in SQL. We're going to see how we can implement the different types of windows for aggregations as we stream data. The first one you will remember from previous sections is the tumbling or fixed window. We can see in this gray how the tumble term is included to incorporate that type of windowing. Then for hopping or sliding windows, the same approach can be done using the hop term. In this case, including two different intervals. One defining the length of the window and the other when the new window begins. Lastly, we can see how session windows will be implemented in SQL. In this case, session will be used, including the interval of time that determines when a new session window must be created.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.