You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "eldenmoon (via GitHub)" <gi...@apache.org> on 2024/07/16 07:29:03 UTC
[PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
eldenmoon opened a new pull request, #37900:
URL: https://github.com/apache/doris/pull/37900
…e handled
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2230211528
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+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2230211759
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 unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should be handled [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2249621197
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 GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should be handled [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon merged PR #37900:
URL: https://github.com/apache/doris/pull/37900
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2230401786
<details>
<summary>ClickBench: <b>Total hot run time: 30.65 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 24cc53aea2b5aa55130bcbb88a8f1afe6127e52d, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.66 0.08 0.07
query5 0.49 0.47 0.48
query6 1.13 0.72 0.72
query7 0.02 0.01 0.02
query8 0.05 0.05 0.04
query9 0.54 0.48 0.48
query10 0.55 0.53 0.55
query11 0.15 0.11 0.11
query12 0.15 0.12 0.13
query13 0.59 0.58 0.58
query14 0.76 0.77 0.80
query15 0.85 0.81 0.82
query16 0.36 0.38 0.37
query17 1.01 1.04 1.04
query18 0.22 0.21 0.21
query19 1.88 1.75 1.78
query20 0.01 0.01 0.02
query21 15.43 0.76 0.66
query22 4.67 6.78 1.94
query23 18.24 1.35 1.32
query24 2.13 0.23 0.23
query25 0.16 0.08 0.08
query26 0.29 0.21 0.21
query27 0.46 0.22 0.22
query28 13.29 1.02 1.00
query29 12.59 3.29 3.30
query30 0.25 0.06 0.06
query31 2.85 0.38 0.38
query32 3.29 0.48 0.47
query33 2.95 2.91 2.84
query34 17.17 4.33 4.39
query35 4.42 4.38 4.42
query36 0.65 0.50 0.47
query37 0.19 0.15 0.16
query38 0.15 0.15 0.14
query39 0.05 0.04 0.03
query40 0.15 0.12 0.13
query41 0.10 0.04 0.05
query42 0.06 0.04 0.04
query43 0.05 0.04 0.04
Total cold run time: 110.35 s
Total hot run time: 30.65 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2249250268
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
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2230366954
<details>
<summary>TPC-H: <b>Total hot run time: 39930 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 24cc53aea2b5aa55130bcbb88a8f1afe6127e52d, data reload: false
------ Round 1 ----------------------------------
q1 17617 4462 4320 4320
q2 2030 193 188 188
q3 10477 1235 1084 1084
q4 10189 901 858 858
q5 7543 2726 2689 2689
q6 217 135 134 134
q7 965 607 601 601
q8 9231 2087 2110 2087
q9 8875 6565 6525 6525
q10 8866 3819 3790 3790
q11 453 233 237 233
q12 402 229 229 229
q13 17759 2999 2973 2973
q14 281 241 233 233
q15 536 470 489 470
q16 485 375 381 375
q17 985 644 718 644
q18 8071 7549 7370 7370
q19 7626 1408 1349 1349
q20 707 315 325 315
q21 4922 3177 3214 3177
q22 346 288 286 286
Total cold run time: 118583 ms
Total hot run time: 39930 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4413 4246 4245 4245
q2 364 260 278 260
q3 3078 2995 3049 2995
q4 1936 1740 1723 1723
q5 5566 5547 5489 5489
q6 227 139 142 139
q7 2205 1931 1880 1880
q8 3293 3488 3466 3466
q9 8825 8976 8903 8903
q10 4205 3807 3939 3807
q11 591 498 510 498
q12 844 639 647 639
q13 15869 3146 3207 3146
q14 322 285 293 285
q15 524 473 497 473
q16 471 445 431 431
q17 1821 1543 1503 1503
q18 8095 8026 7763 7763
q19 1795 1522 1520 1520
q20 2161 1877 1858 1858
q21 5205 4940 4711 4711
q22 620 521 489 489
Total cold run time: 72430 ms
Total hot run time: 56223 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Refactor](ShortCircuit) Conjuncts outof key columns's order should b… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37900:
URL: https://github.com/apache/doris/pull/37900#issuecomment-2230390687
<details>
<summary>TPC-DS: <b>Total hot run time: 174520 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 24cc53aea2b5aa55130bcbb88a8f1afe6127e52d, data reload: false
query1 913 372 376 372
query2 6474 1873 1763 1763
query3 6649 211 220 211
query4 28178 17591 17342 17342
query5 3588 495 484 484
query6 254 191 182 182
query7 4585 292 287 287
query8 239 192 189 189
query9 8524 2388 2370 2370
query10 439 283 276 276
query11 12575 10209 10166 10166
query12 124 88 84 84
query13 1639 383 372 372
query14 10153 7625 7887 7625
query15 232 168 172 168
query16 7740 324 336 324
query17 1804 573 549 549
query18 1987 289 291 289
query19 209 158 161 158
query20 94 87 83 83
query21 212 134 127 127
query22 4512 4080 4228 4080
query23 34213 33965 33567 33567
query24 10826 2922 2839 2839
query25 668 391 400 391
query26 709 150 147 147
query27 2278 271 287 271
query28 6211 2058 2041 2041
query29 880 682 651 651
query30 255 155 154 154
query31 971 803 770 770
query32 98 55 57 55
query33 677 302 321 302
query34 976 490 515 490
query35 699 628 599 599
query36 1160 974 958 958
query37 144 86 89 86
query38 2895 2794 2745 2745
query39 862 800 820 800
query40 211 122 124 122
query41 46 42 44 42
query42 119 104 100 100
query43 512 457 464 457
query44 1098 754 736 736
query45 194 158 157 157
query46 1081 733 734 733
query47 1838 1757 1782 1757
query48 374 301 298 298
query49 820 413 413 413
query50 791 397 413 397
query51 6949 6817 6765 6765
query52 101 93 93 93
query53 360 285 289 285
query54 872 471 446 446
query55 73 78 75 75
query56 287 257 270 257
query57 1118 1046 1046 1046
query58 247 238 266 238
query59 2814 2719 2592 2592
query60 309 271 287 271
query61 101 91 96 91
query62 810 653 650 650
query63 322 289 296 289
query64 9202 2230 1965 1965
query65 3148 3125 3118 3118
query66 741 331 323 323
query67 15647 15177 15034 15034
query68 4541 532 524 524
query69 609 398 361 361
query70 1208 1161 1177 1161
query71 414 283 281 281
query72 7027 5903 6040 5903
query73 746 324 329 324
query74 6143 5735 5711 5711
query75 3384 2716 2740 2716
query76 2126 948 1002 948
query77 424 301 313 301
query78 9776 9210 9017 9017
query79 3351 514 513 513
query80 2464 500 475 475
query81 602 271 220 220
query82 979 143 131 131
query83 312 167 164 164
query84 276 99 92 92
query85 1979 336 311 311
query86 485 284 288 284
query87 3319 3098 3110 3098
query88 4683 2474 2432 2432
query89 484 399 379 379
query90 1854 186 193 186
query91 135 101 101 101
query92 68 49 49 49
query93 5424 503 490 490
query94 1269 216 209 209
query95 445 312 312 312
query96 630 276 271 271
query97 3217 3068 2989 2989
query98 213 201 199 199
query99 1557 1262 1251 1251
Total cold run time: 285975 ms
Total hot run time: 174520 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org