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/01/23 09:47:43 UTC
[PR] [fix](Nereids): when predicate contains right output, don't convert outer to anti join [doris]
XieJiann opened a new pull request, #30276:
URL: https://github.com/apache/doris/pull/30276
## Proposed changes
Issue Number: close #xxx
<!--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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907268986
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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1905775374
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 0c9b68c662b6475a8ee88c93d5cc7c9539f3a631 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 15.0 seconds inserted 10000000 Rows, about 666K 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1908053352
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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907265538
<details>
<summary>ClickBench: <b>Total hot run time: 30.68 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 49defe1cd2917bd483631fda73a0686b5fdf6e2b, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.22 0.04 0.05
query4 1.70 0.06 0.07
query5 0.53 0.52 0.53
query6 1.24 0.64 0.66
query7 0.02 0.01 0.02
query8 0.03 0.03 0.03
query9 0.53 0.50 0.48
query10 0.55 0.55 0.54
query11 0.12 0.08 0.09
query12 0.11 0.10 0.09
query13 0.61 0.61 0.61
query14 0.78 0.84 0.81
query15 0.79 0.78 0.76
query16 0.36 0.38 0.37
query17 1.03 1.02 1.04
query18 0.22 0.27 0.23
query19 1.84 1.81 1.77
query20 0.02 0.01 0.01
query21 15.42 0.62 0.57
query22 2.48 2.49 1.58
query23 17.13 0.78 1.04
query24 2.48 1.71 1.10
query25 0.40 0.19 0.17
query26 0.65 0.14 0.14
query27 0.05 0.06 0.06
query28 11.15 0.76 0.77
query29 12.52 3.09 3.20
query30 0.55 0.47 0.47
query31 2.77 0.34 0.35
query32 3.37 0.48 0.48
query33 3.23 3.21 3.22
query34 16.13 4.27 4.23
query35 4.42 4.36 4.25
query36 1.12 1.08 1.09
query37 0.06 0.05 0.05
query38 0.03 0.03 0.03
query39 0.02 0.01 0.01
query40 0.16 0.13 0.14
query41 0.07 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.01
Total cold run time: 105.04 s
Total hot run time: 30.68 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907301988
<details>
<summary>TPC-DS: <b>Total hot run time: 187685 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 aeffefc57a841369b07a163dce30d06f741b419b, data reload: false
query1 937 337 335 335
query2 6543 2096 2016 2016
query3 6700 201 200 200
query4 31763 22347 22443 22347
query5 6190 462 380 380
query6 245 158 167 158
query7 5157 267 259 259
query8 221 181 178 178
query9 8368 2565 2535 2535
query10 418 232 236 232
query11 17147 15748 15782 15748
query12 144 79 75 75
query13 1713 399 406 399
query14 10787 7337 7273 7273
query15 232 214 195 195
query16 6135 324 267 267
query17 2482 484 499 484
query18 3530 261 260 260
query19 438 139 148 139
query20 68 89 87 87
query21 605 140 148 140
query22 4915 4854 4633 4633
query23 31738 30827 30868 30827
query24 12535 2838 2880 2838
query25 577 322 310 310
query26 1803 148 149 148
query27 3166 292 290 290
query28 7251 1830 1819 1819
query29 1876 640 613 613
query30 284 145 140 140
query31 926 738 744 738
query32 84 54 49 49
query33 703 219 217 217
query34 1121 466 485 466
query35 893 782 789 782
query36 1295 1293 1191 1191
query37 95 57 62 57
query38 3402 3245 3260 3245
query39 1313 1265 1270 1265
query40 341 91 84 84
query41 37 36 35 35
query42 89 80 91 80
query43 497 482 488 482
query44 1141 685 688 685
query45 200 179 176 176
query46 1064 676 646 646
query47 1570 1572 1557 1557
query48 396 332 323 323
query49 1192 289 288 288
query50 701 314 327 314
query51 5359 5231 5176 5176
query52 89 77 78 77
query53 329 258 267 258
query54 241 178 183 178
query55 77 75 79 75
query56 181 168 170 168
query57 1020 938 921 921
query58 200 164 169 164
query59 2827 2787 2827 2787
query60 215 182 184 182
query61 81 83 81 81
query62 609 373 351 351
query63 293 267 269 267
query64 6115 1804 1805 1804
query65 3330 3267 3260 3260
query66 1273 324 319 319
query67 15408 15263 14837 14837
query68 13036 523 520 520
query69 632 303 297 297
query70 1885 1542 1544 1542
query71 10510 10208 10201 10201
query72 4991 2820 2852 2820
query73 3126 318 324 318
query74 7113 6412 6415 6412
query75 5722 2329 2305 2305
query76 6779 1042 1042 1042
query77 1008 238 234 234
query78 9683 8707 8502 8502
query79 1570 504 519 504
query80 654 335 311 311
query81 456 214 202 202
query82 203 79 80 79
query83 212 127 119 119
query84 278 68 69 68
query85 1113 322 327 322
query86 392 401 362 362
query87 3558 3376 3341 3341
query88 3108 2190 2197 2190
query89 441 383 365 365
query90 2262 193 185 185
query91 163 123 123 123
query92 53 48 47 47
query93 1350 466 443 443
query94 1426 166 157 157
query95 508 450 449 449
query96 642 329 318 318
query97 4274 4120 4205 4120
query98 198 189 179 179
query99 1064 746 698 698
Total cold run time: 317085 ms
Total hot run time: 187685 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1905770352
<details>
<summary>ClickBench: <b>Total hot run time: 31.47 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 0c9b68c662b6475a8ee88c93d5cc7c9539f3a631, data reload: false
query1 0.03 0.02 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.52 0.52 0.52
query6 1.28 0.64 0.63
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.56 0.52 0.50
query10 0.57 0.56 0.55
query11 0.11 0.10 0.09
query12 0.11 0.10 0.09
query13 0.62 0.60 0.61
query14 0.77 0.83 0.81
query15 0.79 0.78 0.77
query16 0.37 0.37 0.37
query17 1.04 1.01 1.06
query18 0.24 0.26 0.24
query19 1.81 1.78 1.80
query20 0.01 0.01 0.01
query21 15.44 0.60 0.56
query22 2.76 1.86 2.43
query23 17.30 0.81 0.77
query24 2.40 1.60 1.67
query25 0.43 0.31 0.10
query26 0.60 0.14 0.13
query27 0.06 0.05 0.05
query28 10.59 0.79 0.75
query29 12.53 3.11 3.06
query30 0.58 0.51 0.49
query31 2.78 0.36 0.36
query32 3.35 0.48 0.48
query33 3.24 3.17 3.30
query34 15.78 4.33 4.25
query35 4.33 4.30 4.31
query36 1.12 1.07 1.08
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.16 0.13 0.13
query41 0.07 0.02 0.02
query42 0.02 0.01 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.54 s
Total hot run time: 31.47 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1905684754
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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907305515
<details>
<summary>ClickBench: <b>Total hot run time: 30.86 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 aeffefc57a841369b07a163dce30d06f741b419b, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.05
query4 1.67 0.06 0.08
query5 0.53 0.52 0.53
query6 1.30 0.64 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.55 0.50 0.50
query10 0.55 0.56 0.56
query11 0.12 0.09 0.08
query12 0.11 0.10 0.08
query13 0.62 0.60 0.60
query14 0.78 0.81 0.83
query15 0.79 0.80 0.77
query16 0.36 0.36 0.37
query17 1.02 1.00 1.01
query18 0.24 0.24 0.24
query19 1.83 1.73 1.75
query20 0.01 0.02 0.01
query21 15.40 0.58 0.55
query22 2.93 2.40 1.63
query23 17.33 0.78 0.86
query24 2.66 1.42 1.09
query25 0.51 0.16 0.08
query26 0.48 0.14 0.15
query27 0.04 0.05 0.06
query28 10.72 0.81 0.79
query29 12.57 3.25 3.21
query30 0.54 0.50 0.52
query31 2.78 0.36 0.36
query32 3.32 0.48 0.49
query33 3.20 3.23 3.27
query34 15.69 4.29 4.31
query35 4.33 4.25 4.33
query36 1.11 1.08 1.07
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.12 0.12
query41 0.07 0.02 0.02
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 104.88 s
Total hot run time: 30.86 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907294742
<details>
<summary>TPC-H: <b>Total hot run time: 39047 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 aeffefc57a841369b07a163dce30d06f741b419b, data reload: false
------ Round 1 ----------------------------------
q1 17695 5331 5302 5302
q2 2038 138 129 129
q3 10738 1140 1157 1140
q4 10266 770 758 758
q5 7743 3206 3134 3134
q6 202 122 122 122
q7 853 501 497 497
q8 9222 1897 1938 1897
q9 7268 6405 6482 6405
q10 8304 3128 3147 3128
q11 423 225 207 207
q12 360 196 198 196
q13 18556 3371 3357 3357
q14 245 217 217 217
q15 546 537 495 495
q16 429 378 380 378
q17 932 558 479 479
q18 7502 6980 6870 6870
q19 1552 1306 1402 1306
q20 605 288 284 284
q21 2760 2458 2442 2442
q22 390 304 320 304
Total cold run time: 108629 ms
Total hot run time: 39047 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5512 5218 5286 5218
q2 336 223 211 211
q3 3341 3236 3190 3190
q4 2101 2084 2091 2084
q5 5854 5867 5907 5867
q6 198 118 122 118
q7 2324 1904 1842 1842
q8 3252 3373 3406 3373
q9 8991 9001 8811 8811
q10 3977 3822 3829 3822
q11 551 453 458 453
q12 791 609 626 609
q13 16915 3144 3131 3131
q14 290 246 287 246
q15 544 513 508 508
q16 519 447 460 447
q17 1850 1874 1781 1781
q18 9547 19145 9580 9580
q19 24470 1551 1535 1535
q20 4632 1932 1923 1923
q21 14490 5449 5355 5355
q22 1003 554 595 554
Total cold run time: 111488 ms
Total hot run time: 60658 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907252203
<details>
<summary>TPC-H: <b>Total hot run time: 39513 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 49defe1cd2917bd483631fda73a0686b5fdf6e2b, data reload: false
------ Round 1 ----------------------------------
q1 17840 5250 5392 5250
q2 2026 141 130 130
q3 11164 1167 1208 1167
q4 10510 750 848 750
q5 7732 3174 3169 3169
q6 196 121 121 121
q7 872 501 487 487
q8 9222 1913 1959 1913
q9 7336 6391 6424 6391
q10 8252 3052 3088 3052
q11 428 210 209 209
q12 357 187 194 187
q13 19003 3628 3556 3556
q14 257 226 220 220
q15 558 534 521 521
q16 502 403 406 403
q17 982 613 537 537
q18 7936 7253 7037 7037
q19 7497 1426 1420 1420
q20 600 337 295 295
q21 2747 2401 2417 2401
q22 344 303 297 297
Total cold run time: 116361 ms
Total hot run time: 39513 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5417 5469 5350 5350
q2 327 219 217 217
q3 3322 3238 3220 3220
q4 2073 2014 2018 2014
q5 6025 5911 5828 5828
q6 200 116 115 115
q7 2308 1927 1903 1903
q8 3226 3372 3389 3372
q9 8965 9012 9067 9012
q10 3848 3878 3903 3878
q11 564 441 451 441
q12 798 620 631 620
q13 16939 3185 3175 3175
q14 293 267 251 251
q15 559 506 518 506
q16 513 472 466 466
q17 1864 1824 1891 1824
q18 9529 13512 9422 9422
q19 25945 1545 1549 1545
q20 4610 1924 1940 1924
q21 15641 5446 5280 5280
q22 1472 551 489 489
Total cold run time: 114438 ms
Total hot run time: 60852 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener merged PR #30276:
URL: https://github.com/apache/doris/pull/30276
--
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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907261615
<details>
<summary>TPC-DS: <b>Total hot run time: 186849 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 49defe1cd2917bd483631fda73a0686b5fdf6e2b, data reload: false
query1 929 337 333 333
query2 6561 1962 1904 1904
query3 6701 204 198 198
query4 28629 22078 22214 22078
query5 4459 372 461 372
query6 247 154 161 154
query7 4602 268 259 259
query8 216 172 177 172
query9 8435 2550 2536 2536
query10 418 240 235 235
query11 16622 15659 15452 15452
query12 119 69 66 66
query13 1678 368 373 368
query14 10473 6973 7040 6973
query15 216 184 178 178
query16 5783 253 248 248
query17 955 472 463 463
query18 1779 260 256 256
query19 174 133 129 129
query20 69 69 67 67
query21 189 131 133 131
query22 5190 4898 5012 4898
query23 31605 30920 30909 30909
query24 12505 2862 2798 2798
query25 568 300 297 297
query26 1803 143 142 142
query27 3212 282 284 282
query28 7228 1816 1805 1805
query29 2050 634 632 632
query30 290 140 138 138
query31 938 738 783 738
query32 88 56 47 47
query33 720 220 215 215
query34 1139 451 460 451
query35 858 749 782 749
query36 1278 1254 1247 1247
query37 94 57 64 57
query38 3384 3240 3291 3240
query39 1312 1246 1269 1246
query40 344 87 80 80
query41 37 35 35 35
query42 87 83 86 83
query43 507 498 454 454
query44 1120 680 688 680
query45 193 174 179 174
query46 1065 651 667 651
query47 1672 1584 1572 1572
query48 396 327 311 311
query49 1208 289 280 280
query50 683 300 311 300
query51 5253 5160 5160 5160
query52 95 71 83 71
query53 320 260 252 252
query54 245 182 192 182
query55 84 77 73 73
query56 184 156 163 156
query57 1033 925 943 925
query58 195 160 166 160
query59 2898 2752 2722 2722
query60 208 184 181 181
query61 80 79 80 79
query62 577 372 356 356
query63 280 264 260 260
query64 6109 1765 1731 1731
query65 3344 3299 3253 3253
query66 1399 323 311 311
query67 15943 15244 15366 15244
query68 12023 529 492 492
query69 593 302 293 293
query70 1699 1475 1439 1439
query71 10454 10209 10204 10204
query72 4826 2853 2829 2829
query73 2389 317 308 308
query74 6881 6427 6400 6400
query75 4763 2327 2311 2311
query76 6498 1019 973 973
query77 649 235 231 231
query78 9142 8989 8700 8700
query79 995 492 493 492
query80 590 315 313 313
query81 449 211 202 202
query82 207 79 78 78
query83 140 127 121 121
query84 268 69 68 68
query85 1104 333 309 309
query86 393 373 373 373
query87 3533 3381 3330 3330
query88 2822 2199 2193 2193
query89 431 346 343 343
query90 1987 186 183 183
query91 157 131 130 130
query92 51 43 49 43
query93 2141 416 395 395
query94 1330 156 159 156
query95 502 461 457 457
query96 616 322 318 318
query97 4301 4175 4124 4124
query98 211 200 185 185
query99 1008 657 687 657
Total cold run time: 302228 ms
Total hot run time: 186849 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1905741219
<details>
<summary>TPC-H: <b>Total hot run time: 38800 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 0c9b68c662b6475a8ee88c93d5cc7c9539f3a631, data reload: false
------ Round 1 ----------------------------------
q1 17640 5251 5226 5226
q2 2033 141 129 129
q3 10644 1166 1158 1158
q4 10216 783 828 783
q5 7780 3174 3122 3122
q6 201 118 120 118
q7 847 501 474 474
q8 9231 1949 1958 1949
q9 7219 6346 6375 6346
q10 8178 3078 3016 3016
q11 415 217 210 210
q12 356 185 191 185
q13 18003 3345 3372 3345
q14 248 226 205 205
q15 536 510 506 506
q16 460 387 386 386
q17 941 547 526 526
q18 7389 6897 6742 6742
q19 1566 1379 1378 1378
q20 604 304 289 289
q21 2779 2404 2471 2404
q22 361 323 303 303
Total cold run time: 107647 ms
Total hot run time: 38800 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5399 5227 5252 5227
q2 327 222 218 218
q3 3310 3188 3180 3180
q4 2082 2044 2052 2044
q5 6034 5919 5877 5877
q6 194 115 114 114
q7 2267 1819 1908 1819
q8 3194 3359 3380 3359
q9 8934 8969 8766 8766
q10 4255 3788 3888 3788
q11 545 468 471 468
q12 843 619 622 619
q13 16955 3144 3132 3132
q14 302 266 262 262
q15 548 512 510 510
q16 509 478 457 457
q17 1899 1800 1802 1800
q18 9615 9644 15667 9644
q19 23795 1557 1525 1525
q20 4593 1950 1926 1926
q21 14224 5478 5405 5405
q22 1008 467 536 467
Total cold run time: 110832 ms
Total hot run time: 60607 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1905761305
<details>
<summary>TPC-DS: <b>Total hot run time: 187267 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 0c9b68c662b6475a8ee88c93d5cc7c9539f3a631, data reload: false
query1 950 333 332 332
query2 6547 2155 1910 1910
query3 6691 207 201 201
query4 31541 22078 22335 22078
query5 4449 378 368 368
query6 241 152 153 152
query7 4606 270 263 263
query8 217 177 179 177
query9 8389 2539 2490 2490
query10 443 224 237 224
query11 16962 15532 15585 15532
query12 125 70 64 64
query13 1695 377 385 377
query14 10479 7006 6929 6929
query15 213 186 184 184
query16 5800 268 255 255
query17 1198 479 477 477
query18 1787 250 257 250
query19 171 137 136 136
query20 71 73 64 64
query21 188 130 125 125
query22 4918 4851 4785 4785
query23 31652 31002 30940 30940
query24 11541 2797 2831 2797
query25 569 311 315 311
query26 1614 148 143 143
query27 3222 292 289 289
query28 7133 1846 1821 1821
query29 1426 635 624 624
query30 283 140 139 139
query31 943 750 761 750
query32 78 52 50 50
query33 695 222 213 213
query34 1134 456 463 456
query35 869 784 788 784
query36 1314 1233 1221 1221
query37 96 57 58 57
query38 3391 3240 3226 3226
query39 1333 1276 1271 1271
query40 203 87 88 87
query41 35 35 35 35
query42 97 81 85 81
query43 534 491 490 490
query44 1090 696 695 695
query45 200 179 172 172
query46 1070 658 648 648
query47 1664 1556 1563 1556
query48 389 310 313 310
query49 1135 291 293 291
query50 677 315 311 311
query51 5293 5241 5155 5155
query52 101 85 79 79
query53 324 260 258 258
query54 240 185 186 185
query55 83 74 75 74
query56 183 169 168 168
query57 978 937 920 920
query58 193 162 165 162
query59 2934 2791 2757 2757
query60 215 181 199 181
query61 80 83 82 82
query62 581 335 369 335
query63 289 252 264 252
query64 4970 1810 1741 1741
query65 3336 3267 3247 3247
query66 1250 315 322 315
query67 15714 15425 15441 15425
query68 12747 533 523 523
query69 623 295 314 295
query70 1709 1493 1517 1493
query71 10477 10200 10202 10200
query72 4995 2824 2826 2824
query73 2799 322 329 322
query74 7708 6402 6372 6372
query75 5213 2280 2302 2280
query76 6732 1084 1035 1035
query77 655 238 234 234
query78 9028 8665 8589 8589
query79 1091 526 513 513
query80 566 326 318 318
query81 468 208 200 200
query82 199 79 79 79
query83 140 121 120 120
query84 272 68 69 68
query85 1066 345 332 332
query86 389 381 359 359
query87 3460 3352 3314 3314
query88 3144 2207 2200 2200
query89 433 366 362 362
query90 1998 191 188 188
query91 167 130 136 130
query92 53 44 45 44
query93 1473 442 433 433
query94 1231 157 155 155
query95 498 458 455 455
query96 624 323 325 323
query97 4269 4142 4225 4142
query98 202 199 179 179
query99 973 709 715 709
Total cold run time: 304234 ms
Total hot run time: 187267 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907228875
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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907267686
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 49defe1cd2917bd483631fda73a0686b5fdf6e2b with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.4 seconds inserted 10000000 Rows, about 694K 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1907307414
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit aeffefc57a841369b07a163dce30d06f741b419b with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 14.1 seconds inserted 10000000 Rows, about 709K 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): when predicate contains right output, don't convert outer to anti join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30276:
URL: https://github.com/apache/doris/pull/30276#issuecomment-1908053297
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