[Feature] Refactor TopN Aggregation Result Query Process

[hanahmily]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

Description

This issue aims to address the refactoring of the TopN aggregation result query process to improve the efficiency and accuracy of aggregations.

Tasks

1. Custom Version Control: Refactor the Measure's last-win version control to a custom version control. This new system should allow for different query types to utilize their respective version controls. While most measures will continue to use last-win, we need to implement a custom merge strategy specifically for TopN relevant measures.

2. Merging TopN Lists: Modify the query and merge process to ensure that TopN lists are merged correctly.

   • Compare the version of each data point sharing the same key.
   • Retain the most recent value based on the version.
   • Generate the final list based on filtered data points.

3. Two Layer Merge: The local and distributed query processor both perform the merging process.

4. Result List Optimization: Remove the node ID from the entity of the result list to streamline the data structure.

Use case

No response

Related issues

No response

Are you willing to submit a pull request to implement this on your own?

• Yes I am willing to submit a pull request on my own!

Code of Conduct

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