Xgc: okay wait, it works
Xgc: now, next is Iwant to select min/max from each of the groups formed
Xgc: actually the query is not giving desired groups.
if my data is like this:
Now, running partition over file_id,op order by timestamp (not shown in data above) should give me 3 groups
but it gives me 2 groups (one of "in" and other "out")
the sample data shown is ascending ordered by timestamp