You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XieJiann (via GitHub)" <gi...@apache.org> on 2024/02/06 02:09:50 UTC
[PR] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
XieJiann opened a new pull request, #30884:
URL: https://github.com/apache/doris/pull/30884
## Proposed changes
fix name of rule EliminateJoinByFK
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929133997
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a8b141460308f17fcf43521eac4ea2eb780b334b with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.7 seconds inserted 10000000 Rows, about 729K ops/s
```
--
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928715967
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a20c3bcb3d081b756f84ec0b80b402ef149bd716 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.9 seconds inserted 10000000 Rows, about 719K ops/s
```
--
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #30884:
URL: https://github.com/apache/doris/pull/30884
--
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929119065
<details>
<summary>TPC-DS: <b>Total hot run time: 174242 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 a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
query1 938 342 331 331
query2 6542 1944 1953 1944
query3 6695 215 208 208
query4 31833 21971 21940 21940
query5 4282 426 359 359
query6 266 174 167 167
query7 4601 284 281 281
query8 245 188 178 178
query9 8897 2287 2251 2251
query10 413 213 213 213
query11 17301 15546 15264 15264
query12 129 75 79 75
query13 1625 418 422 418
query14 8946 7282 6766 6766
query15 243 181 183 181
query16 8081 253 250 250
query17 1876 532 493 493
query18 2114 264 268 264
query19 368 149 136 136
query20 82 77 80 77
query21 194 119 122 119
query22 5157 4847 4881 4847
query23 30674 29994 30099 29994
query24 6916 2738 2748 2738
query25 518 363 357 357
query26 707 151 147 147
query27 1965 305 304 304
query28 3545 1856 1849 1849
query29 848 594 610 594
query30 258 133 143 133
query31 930 682 729 682
query32 92 57 53 53
query33 441 226 218 218
query34 812 452 469 452
query35 833 780 771 771
query36 1012 951 872 872
query37 97 58 58 58
query38 3298 3145 3094 3094
query39 1313 1273 1236 1236
query40 186 96 95 95
query41 40 35 36 35
query42 103 96 92 92
query43 535 471 455 455
query44 1031 686 707 686
query45 190 180 174 174
query46 1024 646 655 646
query47 1501 1508 1441 1441
query48 441 361 346 346
query49 844 295 289 289
query50 769 374 376 374
query51 5285 5141 5125 5125
query52 103 85 94 85
query53 337 281 269 269
query54 248 217 214 214
query55 80 79 76 76
query56 225 198 198 198
query57 967 897 913 897
query58 203 180 179 179
query59 2446 2465 2351 2351
query60 238 213 210 210
query61 87 88 84 84
query62 537 325 346 325
query63 293 276 269 269
query64 4480 3649 3443 3443
query65 3259 3265 3243 3243
query66 795 310 307 307
query67 14458 14162 14232 14162
query68 4104 529 548 529
query69 457 326 338 326
query70 1223 1257 1156 1156
query71 330 253 243 243
query72 5863 2876 2661 2661
query73 696 325 333 325
query74 6515 6323 6228 6228
query75 3036 2319 2343 2319
query76 2558 963 921 921
query77 346 232 234 232
query78 9282 8973 8610 8610
query79 2949 488 497 488
query80 2087 343 349 343
query81 514 195 199 195
query82 772 80 80 80
query83 243 126 123 123
query84 288 80 77 77
query85 1906 361 331 331
query86 501 309 266 266
query87 3336 3170 3222 3170
query88 4209 2308 2325 2308
query89 436 359 337 337
query90 1970 163 162 162
query91 158 127 121 121
query92 55 47 43 43
query93 4647 476 459 459
query94 1243 178 172 172
query95 8036 360 348 348
query96 594 272 279 272
query97 4217 4119 4127 4119
query98 220 189 195 189
query99 1131 705 705 705
Total cold run time: 279714 ms
Total hot run time: 174242 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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928699174
<details>
<summary>TPC-H: <b>Total hot run time: 37395 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 a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
------ Round 1 ----------------------------------
q1 17628 4518 4511 4511
q2 2059 152 142 142
q3 10573 938 925 925
q4 4651 770 791 770
q5 7702 2887 2843 2843
q6 184 125 125 125
q7 1186 745 735 735
q8 9277 2027 2066 2027
q9 7350 6408 6386 6386
q10 8119 2486 2417 2417
q11 413 203 199 199
q12 795 264 294 264
q13 18058 3318 3322 3318
q14 285 248 251 248
q15 536 522 492 492
q16 477 403 413 403
q17 954 609 516 516
q18 6946 6043 6016 6016
q19 1569 1360 1404 1360
q20 595 354 348 348
q21 6918 3065 3061 3061
q22 814 289 310 289
Total cold run time: 107089 ms
Total hot run time: 37395 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4437 4484 4380 4380
q2 323 238 245 238
q3 3048 2851 2866 2851
q4 1849 1628 1628 1628
q5 5222 5269 5265 5265
q6 195 116 118 116
q7 2175 1760 1796 1760
q8 3138 3280 3281 3280
q9 8414 8323 8374 8323
q10 5884 3579 3599 3579
q11 548 472 484 472
q12 738 599 562 562
q13 16890 3134 3083 3083
q14 288 253 264 253
q15 526 490 485 485
q16 497 476 477 476
q17 1858 1732 1767 1732
q18 7894 7866 7684 7684
q19 6947 1535 1559 1535
q20 2160 1946 1912 1912
q21 4784 4665 4617 4617
q22 532 452 475 452
Total cold run time: 78347 ms
Total hot run time: 54683 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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928672957
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929099065
<details>
<summary>TPC-H: <b>Total hot run time: 37079 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 a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
------ Round 1 ----------------------------------
q1 6500 4526 4451 4451
q2 1154 151 139 139
q3 4955 942 944 942
q4 1008 746 730 730
q5 2797 2789 2781 2781
q6 203 130 133 130
q7 1256 756 729 729
q8 1899 1985 2021 1985
q9 6397 6363 6320 6320
q10 7247 2420 2411 2411
q11 342 201 212 201
q12 830 284 287 284
q13 17754 3337 3337 3337
q14 288 257 249 249
q15 528 502 490 490
q16 468 402 410 402
q17 931 579 484 484
q18 6500 6023 6004 6004
q19 1551 1300 1345 1300
q20 596 360 330 330
q21 6710 3094 3078 3078
q22 807 302 304 302
Total cold run time: 70721 ms
Total hot run time: 37079 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4370 4504 4439 4439
q2 336 233 230 230
q3 2968 2871 2783 2783
q4 1891 1686 1655 1655
q5 5185 5278 5182 5182
q6 191 113 115 113
q7 2126 1741 1776 1741
q8 3123 3199 3227 3199
q9 8309 8231 8248 8231
q10 6023 3590 3619 3590
q11 552 450 463 450
q12 735 567 585 567
q13 3783 3119 3136 3119
q14 280 267 256 256
q15 532 494 499 494
q16 528 458 473 458
q17 1825 1706 1741 1706
q18 7974 7666 7533 7533
q19 10643 1543 1552 1543
q20 2523 1927 1891 1891
q21 4771 4700 4580 4580
q22 628 484 475 475
Total cold run time: 69296 ms
Total hot run time: 54235 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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929028796
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929041264
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928653403
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)
--
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928709355
<details>
<summary>TPC-DS: <b>Total hot run time: 175007 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 a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
query1 919 364 334 334
query2 6518 1895 1873 1873
query3 6709 218 218 218
query4 31684 22200 22222 22200
query5 4315 437 359 359
query6 259 168 165 165
query7 4603 293 287 287
query8 239 172 178 172
query9 8969 2289 2274 2274
query10 412 215 222 215
query11 19001 15663 15421 15421
query12 132 79 77 77
query13 1638 420 418 418
query14 9333 7093 6980 6980
query15 238 179 184 179
query16 8122 268 257 257
query17 1856 538 505 505
query18 2102 267 268 267
query19 345 144 139 139
query20 82 74 78 74
query21 198 132 126 126
query22 4979 4669 4603 4603
query23 30656 30130 30079 30079
query24 10601 2744 2750 2744
query25 544 352 345 345
query26 709 153 151 151
query27 2175 301 300 300
query28 5767 1853 1856 1853
query29 868 628 612 612
query30 285 131 141 131
query31 895 698 694 694
query32 94 53 52 52
query33 631 225 220 220
query34 822 463 455 455
query35 867 776 773 773
query36 1029 898 930 898
query37 97 54 57 54
query38 3220 3133 3080 3080
query39 1316 1271 1248 1248
query40 186 100 92 92
query41 38 35 34 34
query42 105 87 95 87
query43 497 500 457 457
query44 1101 694 712 694
query45 193 179 170 170
query46 1036 660 662 660
query47 1528 1520 1533 1520
query48 444 345 356 345
query49 1045 290 286 286
query50 775 374 381 374
query51 5194 5144 5176 5144
query52 103 84 96 84
query53 345 264 263 263
query54 292 222 223 222
query55 86 72 86 72
query56 224 201 200 200
query57 975 957 893 893
query58 196 183 187 183
query59 2423 2325 2310 2310
query60 233 217 217 217
query61 83 89 86 86
query62 634 376 362 362
query63 290 269 272 269
query64 4735 3756 3755 3755
query65 3234 3234 3231 3231
query66 805 316 303 303
query67 14296 13988 14094 13988
query68 3925 548 527 527
query69 467 322 332 322
query70 1239 1235 1207 1207
query71 321 253 254 253
query72 6274 2894 2688 2688
query73 719 320 328 320
query74 6463 6271 6260 6260
query75 3057 2369 2348 2348
query76 2557 983 902 902
query77 365 234 231 231
query78 9132 8762 8451 8451
query79 2527 487 486 486
query80 1849 364 351 351
query81 541 198 201 198
query82 759 87 77 77
query83 242 126 123 123
query84 284 82 80 80
query85 2131 367 343 343
query86 490 318 297 297
query87 3325 3201 3229 3201
query88 3710 2335 2323 2323
query89 462 366 339 339
query90 1879 169 167 167
query91 154 131 124 124
query92 59 52 47 47
query93 2570 511 462 462
query94 1283 177 174 174
query95 477 8001 362 362
query96 585 267 274 267
query97 4232 4098 4106 4098
query98 218 203 190 190
query99 1163 689 656 656
Total cold run time: 277784 ms
Total hot run time: 175007 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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929041177
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929066312
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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1929128689
<details>
<summary>ClickBench: <b>Total hot run time: 30.13 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 a8b141460308f17fcf43521eac4ea2eb780b334b, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.65 0.10 0.10
query5 0.54 0.52 0.52
query6 1.19 0.64 0.63
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.51 0.52
query10 0.57 0.55 0.55
query11 0.12 0.08 0.09
query12 0.11 0.08 0.09
query13 0.60 0.61 0.59
query14 0.76 0.81 0.80
query15 0.80 0.78 0.78
query16 0.37 0.41 0.38
query17 1.02 1.03 1.05
query18 0.24 0.26 0.24
query19 1.88 1.82 1.72
query20 0.02 0.01 0.01
query21 15.42 0.58 0.55
query22 2.34 3.24 1.71
query23 16.93 0.85 0.80
query24 2.80 1.04 0.25
query25 0.25 0.10 0.16
query26 0.47 0.15 0.14
query27 0.06 0.05 0.05
query28 12.33 0.84 0.82
query29 12.52 3.13 3.26
query30 0.59 0.54 0.52
query31 2.79 0.34 0.36
query32 3.33 0.49 0.49
query33 3.18 3.24 3.20
query34 15.73 4.30 4.28
query35 4.29 4.27 4.31
query36 1.10 1.07 1.06
query37 0.07 0.04 0.06
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.17 0.12 0.13
query41 0.08 0.01 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.37 s
Total hot run time: 30.13 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] [fix](Nereids): fix name of rule EliminateJoinByFK [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30884:
URL: https://github.com/apache/doris/pull/30884#issuecomment-1928713507
<details>
<summary>ClickBench: <b>Total hot run time: 30.71 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 a20c3bcb3d081b756f84ec0b80b402ef149bd716, data reload: false
query1 0.03 0.03 0.02
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.68 0.10 0.10
query5 0.54 0.51 0.51
query6 1.18 0.64 0.64
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.56 0.51 0.52
query10 0.57 0.56 0.55
query11 0.12 0.09 0.08
query12 0.11 0.09 0.10
query13 0.60 0.61 0.60
query14 0.80 0.80 0.79
query15 0.79 0.79 0.79
query16 0.38 0.37 0.40
query17 1.03 1.03 1.01
query18 0.24 0.25 0.23
query19 1.84 1.72 1.72
query20 0.01 0.01 0.01
query21 15.40 0.56 0.60
query22 2.50 2.71 1.52
query23 17.03 0.80 0.69
query24 2.69 1.19 0.93
query25 0.35 0.26 0.17
query26 0.51 0.14 0.14
query27 0.06 0.04 0.05
query28 11.12 0.85 0.84
query29 12.55 3.18 3.19
query30 0.64 0.55 0.53
query31 2.79 0.35 0.35
query32 3.35 0.48 0.49
query33 3.29 3.22 3.24
query34 15.92 4.31 4.33
query35 4.35 4.31 4.32
query36 1.13 1.06 1.05
query37 0.06 0.06 0.05
query38 0.03 0.03 0.02
query39 0.02 0.02 0.01
query40 0.17 0.13 0.13
query41 0.06 0.01 0.02
query42 0.03 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 104.89 s
Total hot run time: 30.71 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