Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-24 Thread via GitHub
924060929 merged PR #44586: URL: https://github.com/apache/doris/pull/44586 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.ap

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-24 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2560804158 ClickBench: Total hot run time: 32.55 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2560798837 TPC-DS: Total hot run time: 190328 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2560787578 TPC-H: Total hot run time: 39820 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2560769639 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559313184 PR approved by at least one committer and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHu

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559255639 ClickBench: Total hot run time: 32.06 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559246156 TPC-DS: Total hot run time: 190521 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559226245 TPC-H: Total hot run time: 40120 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559151503 > should we add some UTs? the exists UT/RT is enough and it already made me find some bugs -- This is an automated message from the Apache Git Service. To respond to the message

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559151736 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-23 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2559115405 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the UR

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-22 Thread via GitHub
morrySnow commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1895308368 ## fe/fe-core/src/main/java/org/apache/doris/common/cache/NereidsSortedPartitionsCacheManager.java: ## @@ -0,0 +1,191 @@ +// Licensed to the Apache Software Foundatio

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-21 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2558079159 ClickBench: Total hot run time: 33.04 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-21 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2558077792 TPC-DS: Total hot run time: 190276 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-21 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2558075254 TPC-H: Total hot run time: 40369 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-21 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2558070726 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2557223558 ClickBench: Total hot run time: 33.1 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools C

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2557214108 TPC-DS: Total hot run time: 190054 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2557192467 TPC-H: Total hot run time: 40019 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2557125229 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2556529920 ClickBench: Total hot run time: 33.33 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2556521762 TPC-DS: Total hot run time: 196789 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-20 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2556504127 TPC-H: Total hot run time: 39878 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-19 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-255648 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-19 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2556407765 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
924060929 commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1891044459 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/MultiColumnBound.java: ## @@ -0,0 +1,54 @@ +// Licensed to the Apache Software Foundation

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
924060929 commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1891044459 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/MultiColumnBound.java: ## @@ -0,0 +1,54 @@ +// Licensed to the Apache Software Foundation

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551786369 `sh-checker report` To get the full details, please check in the [job]("https://github.com/apache/doris/actions/runs/12397305848";) output. shellcheck er

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551785776 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551295757 `sh-checker report` To get the full details, please check in the [job]("https://github.com/apache/doris/actions/runs/12393726562";) output. shellcheck er

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551294599 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551273259 `sh-checker report` To get the full details, please check in the [job]("https://github.com/apache/doris/actions/runs/12393541131";) output. shellcheck er

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-18 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2551271996 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-17 Thread via GitHub
github-actions[bot] commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2550356328 `sh-checker report` To get the full details, please check in the [job]("https://github.com/apache/doris/actions/runs/1238687";) output. shellcheck er

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-17 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2550355689 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-17 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2548397617 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-17 Thread via GitHub
924060929 commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1888388219 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/PartitionItemToRange.java: ## @@ -0,0 +1,78 @@ +// Licensed to the Apache Software Foundat

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-17 Thread via GitHub
924060929 commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1888388219 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/PartitionItemToRange.java: ## @@ -0,0 +1,78 @@ +// Licensed to the Apache Software Foundat

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-02 Thread via GitHub
feiniaofeiafei commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1866997179 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/PartitionPruner.java: ## @@ -134,39 +143,111 @@ public static List prune(List parti

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-12-02 Thread via GitHub
feiniaofeiafei commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1866951021 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/PruneOlapScanPartition.java: ## @@ -76,10 +81,18 @@ public Rule build() {

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-11-28 Thread via GitHub
morrySnow commented on code in PR #44586: URL: https://github.com/apache/doris/pull/44586#discussion_r1862302951 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/MultiColumnBound.java: ## @@ -0,0 +1,54 @@ +// Licensed to the Apache Software Foundation

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-11-25 Thread via GitHub
924060929 commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2499544562 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To un

Re: [PR] [opt](nereids) use binary search to prune partitions [doris]

2024-11-25 Thread via GitHub
doris-robot commented on PR #44586: URL: https://github.com/apache/doris/pull/44586#issuecomment-2499516549 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+proce

[PR] [opt](nereids) use binary search to prune partitions [doris]

2024-11-25 Thread via GitHub
924060929 opened a new pull request, #44586: URL: https://github.com/apache/doris/pull/44586 ### What problem does this PR solve? use binary search to speed up prune partitions. test: datetime partition column, range from 2020-07-02 to 2024-11-13, one date for one partition, th