Iceberg: improve TopN with sort on partition column

[Samrose-Ahmed]

Enhancement

e.g. query like select * from table order by ts desc limit 1 on table that is partitioned on e.g. hour(ts) feels slower than need

[kevincai]

@Samrose-Ahmed do you have a query profile that is helpful for analyzing the perf issue.

[github-actions]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

[Samrose-Ahmed]

Of course, I'll post some profile to show