Support RangePartitioning with native shuffle

[andygrove]

What is the problem the feature request solves?

We do not currently support RangePartitioning with native shuffle.

Adding this support would allow us to use native shuffle for more queries, including queries where there is a global sort.

Describe the potential solution

No response

Additional context

No response

[viirya]

Since the early development of Comet shuffle, this is one item on to do list. After we finish columnar shuffle which has higher coverage and support main partitioning types, we turn our focus to other more urgent items. Because we want to increase query coverage as much as possible. Currently we can run TPC-H queries mostly native, seems we can go back to look at this as it can give us more performance gain on shuffle (because native shuffle is faster than columnar shuffle).

[viirya]

I will work on this after finishing HashJoin build right support.

[andygrove]

This would help with TPC-H performance, so I plan on taking a look at this issue soon