You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/03/01 09:39:45 UTC
[PR] [fix](Nereids) check slot from children may produce wrong format err … [doris]
morrySnow opened a new pull request, #31670:
URL: https://github.com/apache/doris/pull/31670
…(#31638)
pick from master #31638
commit id 8a1bc8b82f966b6de63809667c7255afb84f95b9
## 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1975652110
<details>
<summary>ClickBench: <b>Total hot run time: 26.16 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 1d1e38162cc2703c605ee52006faa25480d11a38, data reload: false
query1 0.04 0.03 0.03
query2 0.10 0.04 0.03
query3 0.28 0.05 0.06
query4 1.70 0.08 0.07
query5 0.41 0.41 0.39
query6 1.45 0.94 0.92
query7 0.02 0.02 0.01
query8 0.06 0.04 0.03
query9 0.62 0.59 0.58
query10 0.64 0.64 0.61
query11 0.19 0.14 0.14
query12 0.19 0.14 0.14
query13 0.44 0.46 0.45
query14 0.76 0.79 0.76
query15 0.81 0.79 0.80
query16 0.39 0.40 0.40
query17 1.20 1.28 1.40
query18 0.24 0.28 0.24
query19 2.40 2.35 2.30
query20 0.02 0.01 0.02
query21 15.46 0.83 0.84
query22 0.50 0.50 0.50
query23 13.76 0.51 0.54
query24 0.96 0.47 0.47
query25 0.09 0.06 0.07
query26 0.21 0.19 0.21
query27 0.07 0.06 0.07
query28 1.05 0.69 0.68
query29 12.70 3.31 3.32
query30 1.00 0.90 0.90
query31 0.95 0.44 0.41
query32 3.30 0.43 0.42
query33 2.68 2.59 2.56
query34 2.32 2.38 2.28
query35 2.36 2.35 2.31
query36 1.19 1.18 1.15
query37 0.06 0.04 0.04
query38 0.04 0.03 0.03
query39 0.03 0.02 0.03
query40 0.14 0.14 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 70.97 s
Total hot run time: 26.16 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) check slot from children may produce wrong format err … [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1972845889
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) check slot from children may produce wrong format err … [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #31670:
URL: https://github.com/apache/doris/pull/31670
--
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) check slot from children may produce wrong format err … [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1975568133
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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1972931038
<details>
<summary>ClickBench: <b>Total hot run time: 25.73 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 c37798ec65f7ce3c6c5d031039c83a9d12c897c7, data reload: false
query1 0.04 0.03 0.04
query2 0.10 0.04 0.03
query3 0.26 0.06 0.06
query4 1.71 0.08 0.08
query5 0.40 0.41 0.41
query6 1.37 0.91 0.91
query7 0.02 0.01 0.02
query8 0.05 0.03 0.04
query9 0.54 0.59 0.55
query10 0.64 0.61 0.61
query11 0.17 0.13 0.13
query12 0.16 0.13 0.13
query13 0.44 0.43 0.42
query14 0.75 0.72 0.71
query15 0.79 0.76 0.78
query16 0.39 0.41 0.40
query17 1.17 1.20 1.21
query18 0.25 0.27 0.25
query19 2.37 2.25 2.28
query20 0.02 0.01 0.02
query21 15.41 0.82 0.83
query22 0.52 0.53 0.52
query23 13.68 0.54 0.54
query24 0.81 0.57 0.47
query25 0.08 0.06 0.07
query26 0.23 0.20 0.22
query27 0.06 0.05 0.05
query28 0.96 0.75 0.71
query29 12.71 3.33 3.35
query30 0.90 0.82 0.82
query31 0.93 0.44 0.42
query32 3.28 0.41 0.43
query33 2.63 2.62 2.59
query34 2.21 2.22 2.18
query35 2.25 2.18 2.22
query36 1.18 1.18 1.19
query37 0.06 0.05 0.04
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.13 0.13 0.12
query41 0.07 0.02 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 69.84 s
Total hot run time: 25.73 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1972923481
<details>
<summary>TPC-DS: <b>Total hot run time: 199270 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 c37798ec65f7ce3c6c5d031039c83a9d12c897c7, data reload: false
query1 1010 448 448 448
query2 6599 2820 2589 2589
query3 6932 268 275 268
query4 18337 13163 13257 13163
query5 19922 3110 2878 2878
query6 355 278 283 278
query7 4149 420 431 420
query8 380 361 367 361
query9 4336 3943 3891 3891
query10 569 482 496 482
query11 9260 8864 8858 8858
query12 169 115 104 104
query13 5585 847 882 847
query14 17976 14248 14495 14248
query15 320 303 304 303
query16 5195 360 348 348
query17 1486 1108 951 951
query18 2172 509 503 503
query19 259 222 216 216
query20 108 107 110 107
query21 209 139 136 136
query22 6037 5893 5812 5812
query23 24518 23935 23554 23554
query24 6763 5327 5225 5225
query25 580 600 527 527
query26 518 219 208 208
query27 901 420 411 411
query28 4585 3491 3453 3453
query29 8508 8483 8800 8483
query30 276 195 189 189
query31 965 849 811 811
query32 104 91 84 84
query33 435 356 325 325
query34 956 664 675 664
query35 1322 1225 1159 1159
query36 2190 1940 1840 1840
query37 111 89 89 89
query38 3102 2984 2978 2978
query39 1194 1206 1153 1153
query40 230 135 137 135
query41 53 59 51 51
query42 141 138 134 134
query43 879 858 907 858
query44 1278 1069 1076 1069
query45 292 281 279 279
query46 1050 891 910 891
query47 2561 2381 2470 2381
query48 1022 828 841 828
query49 602 447 403 403
query50 698 501 474 474
query51 4247 4119 4090 4090
query52 128 118 132 118
query53 413 379 378 378
query54 2281 2026 2013 2013
query55 133 130 127 127
query56 339 277 313 277
query57 1581 1288 1352 1288
query58 351 324 317 317
query59 4814 4704 4442 4442
query60 292 306 297 297
query61 138 123 147 123
query62 769 644 616 616
query63 414 388 378 378
query64 1984 1345 1340 1340
query65 3451 3455 3401 3401
query66 968 482 442 442
query67 18267 18056 18448 18056
query68 3269 711 718 711
query69 601 505 509 505
query70 2333 2927 2353 2353
query71 412 428 420 420
query72 3807 3091 3050 3050
query73 819 473 472 472
query74 5905 5564 5768 5564
query75 3911 3168 3403 3168
query76 2170 710 684 684
query77 508 369 366 366
query78 10298 9704 8902 8902
query79 1132 769 749 749
query80 612 535 563 535
query81 472 268 266 266
query82 183 126 141 126
query83 213 198 217 198
query84 243 102 102 102
query85 662 405 405 405
query86 527 505 529 505
query87 3362 3035 2948 2948
query88 3812 3472 3502 3472
query89 432 396 443 396
query90 1379 245 216 216
query91 189 169 177 169
query92 77 75 76 75
query93 905 554 555 554
query94 530 243 242 242
query95 1393 1250 1258 1250
query96 773 489 494 489
query97 5576 5420 5568 5420
query98 234 248 238 238
query99 1800 1150 1224 1150
Total cold run time: 276308 ms
Total hot run time: 199270 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1972902126
<details>
<summary>TPC-H: <b>Total hot run time: 37188 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 c37798ec65f7ce3c6c5d031039c83a9d12c897c7, data reload: false
------ Round 1 ----------------------------------
q1 18080 5025 4832 4832
q2 2125 206 213 206
q3 10183 1108 1059 1059
q4 10197 756 730 730
q5 8474 2543 2310 2310
q6 163 98 108 98
q7 1707 1440 1438 1438
q8 9367 2012 2016 2012
q9 9362 7977 7415 7415
q10 8084 2138 2079 2079
q11 457 319 321 319
q12 442 317 336 317
q13 18410 3089 3016 3016
q14 351 356 296 296
q15 393 334 354 334
q16 600 596 585 585
q17 864 482 479 479
q18 5964 5327 5345 5327
q19 1381 1003 896 896
q20 660 483 464 464
q21 3150 2536 2492 2492
q22 583 484 510 484
Total cold run time: 110997 ms
Total hot run time: 37188 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4830 4837 4835 4835
q2 324 305 262 262
q3 2762 2497 2488 2488
q4 1808 1571 1551 1551
q5 7987 7525 7714 7525
q6 150 89 93 89
q7 3797 3714 3714 3714
q8 6757 6703 6918 6703
q9 10656 10173 10090 10090
q10 3076 2704 2619 2619
q11 1163 1105 1230 1105
q12 943 828 838 828
q13 3250 2752 2763 2752
q14 414 352 387 352
q15 357 325 340 325
q16 722 699 715 699
q17 6062 5317 5392 5317
q18 6597 5982 6019 5982
q19 1466 1058 1050 1050
q20 2130 2087 1952 1952
q21 8868 8627 8509 8509
q22 966 922 933 922
Total cold run time: 75085 ms
Total hot run time: 69669 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1975648637
<details>
<summary>TPC-DS: <b>Total hot run time: 201185 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 1d1e38162cc2703c605ee52006faa25480d11a38, data reload: false
query1 990 435 425 425
query2 6564 2835 2744 2744
query3 6932 272 267 267
query4 18418 13650 13391 13391
query5 19920 2917 2672 2672
query6 335 270 276 270
query7 4133 410 441 410
query8 360 371 307 307
query9 4242 3852 3811 3811
query10 576 414 441 414
query11 9630 9225 9153 9153
query12 161 99 100 99
query13 5572 860 843 843
query14 18104 14047 14364 14047
query15 330 299 293 293
query16 4973 335 336 335
query17 1465 987 959 959
query18 2176 489 488 488
query19 247 212 221 212
query20 108 105 101 101
query21 209 142 144 142
query22 6289 5772 6086 5772
query23 24958 23973 24474 23973
query24 5793 4565 4490 4490
query25 559 528 484 484
query26 519 220 198 198
query27 910 405 416 405
query28 4610 3423 3349 3349
query29 6379 6286 6360 6286
query30 265 191 195 191
query31 1001 880 906 880
query32 95 85 80 80
query33 441 319 316 316
query34 936 655 670 655
query35 1222 1219 1245 1219
query36 2252 1835 2063 1835
query37 91 87 86 86
query38 3207 3167 3079 3079
query39 1221 1203 1215 1203
query40 230 134 137 134
query41 53 49 52 49
query42 119 119 127 119
query43 976 837 772 772
query44 1254 1035 1067 1035
query45 286 279 273 273
query46 1029 907 901 901
query47 2457 2490 2536 2490
query48 1019 825 821 821
query49 626 455 412 412
query50 721 471 462 462
query51 4150 4075 4142 4075
query52 122 116 122 116
query53 412 377 381 377
query54 1863 1730 1426 1426
query55 111 115 122 115
query56 296 304 296 296
query57 1525 1558 1418 1418
query58 312 303 307 303
query59 4857 4881 4809 4809
query60 304 262 299 262
query61 133 126 123 123
query62 711 611 740 611
query63 408 377 371 371
query64 1892 1334 1283 1283
query65 3344 3258 3200 3200
query66 941 454 470 454
query67 18098 20280 22476 20280
query68 3321 673 725 673
query69 603 511 484 484
query70 2349 2529 2439 2439
query71 397 379 391 379
query72 3826 3292 3264 3264
query73 831 487 475 475
query74 6336 6031 6130 6031
query75 4192 3355 3373 3355
query76 2127 680 681 680
query77 526 369 373 369
query78 10578 9878 9816 9816
query79 1116 769 775 769
query80 611 543 560 543
query81 484 284 280 280
query82 173 132 132 132
query83 214 198 198 198
query84 262 101 97 97
query85 696 404 401 401
query86 548 533 558 533
query87 3668 3317 3382 3317
query88 4165 3514 3486 3486
query89 438 440 414 414
query90 1416 214 208 208
query91 178 173 167 167
query92 77 76 75 75
query93 990 558 610 558
query94 540 255 242 242
query95 1350 1294 1276 1276
query96 746 500 508 500
query97 5905 5677 5841 5677
query98 237 251 230 230
query99 2181 1249 1246 1246
Total cold run time: 275523 ms
Total hot run time: 201185 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1975640344
<details>
<summary>TPC-H: <b>Total hot run time: 36632 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 1d1e38162cc2703c605ee52006faa25480d11a38, data reload: false
------ Round 1 ----------------------------------
q1 18111 4975 4769 4769
q2 2096 204 206 204
q3 10192 1122 1135 1122
q4 10151 739 739 739
q5 8274 2584 2338 2338
q6 143 95 96 95
q7 1653 1484 1432 1432
q8 9333 1780 1737 1737
q9 9097 8167 7367 7367
q10 8126 2200 2168 2168
q11 465 301 310 301
q12 442 301 313 301
q13 18310 3056 2991 2991
q14 315 314 301 301
q15 399 362 352 352
q16 610 600 587 587
q17 904 390 392 390
q18 5922 5689 5179 5179
q19 1198 961 886 886
q20 632 456 428 428
q21 3095 2536 2451 2451
q22 566 494 505 494
Total cold run time: 110034 ms
Total hot run time: 36632 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4737 4759 4752 4752
q2 319 246 263 246
q3 2601 2455 2390 2390
q4 1779 1574 1605 1574
q5 6326 6054 6116 6054
q6 137 85 91 85
q7 3421 3233 3230 3230
q8 5042 5282 5172 5172
q9 11105 10278 10237 10237
q10 3215 2666 2786 2666
q11 896 840 862 840
q12 961 845 875 845
q13 3217 2796 2778 2778
q14 390 352 357 352
q15 370 335 336 335
q16 723 715 708 708
q17 4500 4192 4144 4144
q18 6498 6139 5891 5891
q19 1397 1005 977 977
q20 2048 1996 2039 1996
q21 7820 7661 7421 7421
q22 1052 982 1013 982
Total cold run time: 68554 ms
Total hot run time: 63675 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) check slot from children may produce wrong format err … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31670:
URL: https://github.com/apache/doris/pull/31670#issuecomment-1972845894
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