SQL: How to increment a parent group number when the child window has incrementing values?

Spark SQL 3.2.0 DB Fiddle Please see the above link for a simplified example of my dataset and desired outcome. In abstract, I have a dataset with a series of related events that can be grouped by their time order and event number. When ordering by time and event number, every time the event number […]

Read More