liangyongyuan

I encountered a situation where SQL contains two consecutive window functions, such as row_number() (partition by a, order by b, c) as rn1 and row_number() (partition by a, b order...

@mbasmanova ``` select a, b, c, row_number() over ( partition by c order by a, b ) as rn1, row_number() over ( partition by c, b order by a )...

`ROW_NUMBER` with `PARTITION BY` involves a shuffle, but this issue is unrelated to whether there is a shuffle or if it is within the same partition. If stable sorting is...

@mbasmanova Sorry for the late reply. You make a good point. A better solution would be to add rn1 during the second row_number sorting. The fact that the expected result...