expand: tpc-ds rollup related queries errors in nightly cluster

[AilinKid]

Bug Report

Please answer these questions before submitting your issue. Thanks!
details ref:
pingcap/tidb#45276
pingcap/tidb#45275
pingcap/tidb#45273
pingcap/tidb#45272
pingcap/tidb#45576

1. Minimal reproduce step (Required)

use the refined tpc-ds query, and run it in the nightly cluster.

2. What did you expect to see? (Required)

no error

3. What did you see instead (Required)

mpp error

4. What is your TiFlash version? (Required)

nightly

[AilinKid]

/assign @AilinKid

[AilinKid]

/label moderate

[ti-chi-bot]

@AilinKid: The label(s) moderate cannot be applied. These labels are supported: tide/merge-method-rebase, tide/merge-method-squash, tide/merge-method-merge, duplicate, first-time-contributor, good first issue, help wanted, invalid, question, wontfix, make-local-great-again, needs-cherry-pick-release-5.2, needs-cherry-pick-release-5.3, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.0, needs-cherry-pick-release-6.1, needs-cherry-pick-release-6.2, needs-cherry-pick-release-6.3, needs-cherry-pick-release-6.4, needs-cherry-pick-release-6.5, needs-cherry-pick-release-6.6, needs-cherry-pick-release-7.0, needs-cherry-pick-release-7.1, needs-cherry-pick-release-7.2, needs-rebase.

In response to this:

/label moderate

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.