[Feature]: Support table sorting process

[zhoujinsong]

Description

Currently, the self-optimizing process on the table does not sort the data in the table. If a sorting process is added, it can improve the performance of filtering queries on the sorted fields.

Use case/motivation

Support configuring sorting rules on tables. The data will be sorted according to the rules to improve the query performance of the table.

Describe the solution

• Support configuring sorting rules for table rows.
• Automatically sort the data.
• Support multiple sorting methods, such as regular sorting and z-order sorting.

Subtasks

No response

Related issues

No response

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[link3280]

@zhoujinsong I'm glad to help with this one. Please assign it to me if no one is working on it.

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions[bot]]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'

[sqd]

Is this something Amoro supports now, now that https://github.com/apache/amoro/pull/2421 has been merged?