feat(query): refactor window spill

[Dousir9]

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/

Summary

Performance Test (Databend Cloud Small) (TPC-H SF100)

Spill Query Duration: 98s → 58s (68%) No Spill Query Duration(set window_partition_spilling_memory_ratio = 0): 25s -> 25s

Full Test Script

set max_memory_usage = 34359738368; -- 32GB
set window_partition_spilling_memory_ratio = 60;
SELECT
    l_orderkey,
    l_partkey,
    l_quantity,
    l_extendedprice,
    ROW_NUMBER() OVER (PARTITION BY l_orderkey ORDER BY l_extendedprice DESC) AS row_num,
    RANK() OVER (PARTITION BY l_orderkey ORDER BY l_extendedprice DESC) AS rank_num,
    SUM(l_extendedprice) OVER (PARTITION BY l_orderkey ORDER BY l_extendedprice DESC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_sum
FROM
    lineitem ignore_result;

Tests

• [ ] Unit Test
• [x] Logic Test
• [ ] Benchmark Test
• [ ] No Test - Explain why

Type of change

• [ ] Bug Fix (non-breaking change which fixes an issue)
• [ ] New Feature (non-breaking change which adds functionality)
• [ ] Breaking Change (fix or feature that could cause existing functionality not to work as expected)
• [ ] Documentation Update
• [x] Refactoring
• [ ] Performance Improvement
• [ ] Other (please describe):

---

This change is 

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-4fb4473-1726412751

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-7ef2e23-1726490205

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-65cb372-1726576067

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-75873d2-1726637620

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-f7eb84b-1726645364

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-f7eb84b-1726645433

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-f7eb84b-1726645433

note: this image tag is only available for internal use, please check the internal doc for more details.

[Dousir9]

Thanks to @zhang2014 for helping fix the pipeline.

[github-actions[bot]]

Docker Image for PR

• tag: pr-16448-d40dab8-1726713037

note: this image tag is only available for internal use, please check the internal doc for more details.