You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "jackwener (via GitHub)" <gi...@apache.org> on 2024/02/06 03:27:57 UTC
[PR] [fix](Nereids): fix wrong case in TransposeSemiJoinLogicalJoinProject… [doris]
jackwener opened a new pull request, #30885:
URL: https://github.com/apache/doris/pull/30885
… (#30874)
(cherry picked from commit f8ab1d6dac9d425eb7bb3441c7184b987862e8d0)
## 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): fix wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #30885:
URL: https://github.com/apache/doris/pull/30885
--
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 wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928733577
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 wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928751838
<details>
<summary>TPC-H: <b>Total hot run time: 50023 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 ae653afa14e20604342ea328ee16662d9d59f121, data reload: false
------ Round 1 ----------------------------------
q1 17652 4413 4394 4394
q2 2028 150 140 140
q3 10283 1889 1934 1889
q4 10161 1256 1330 1256
q5 8395 4284 4008 4008
q6 224 120 120 120
q7 2044 1585 1611 1585
q8 9295 2721 2725 2721
q9 10852 10695 10434 10434
q10 8654 3550 3534 3534
q11 424 235 233 233
q12 467 299 306 299
q13 18398 3944 3999 3944
q14 351 324 316 316
q15 518 458 467 458
q16 682 595 598 595
q17 1136 953 974 953
q18 7387 6863 6802 6802
q19 1699 1526 1521 1521
q20 534 321 297 297
q21 4451 4153 4130 4130
q22 496 394 396 394
Total cold run time: 116131 ms
Total hot run time: 50023 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4346 4307 4327 4307
q2 321 217 222 217
q3 4180 4140 4200 4140
q4 2764 2778 2754 2754
q5 7279 7220 7182 7182
q6 234 121 116 116
q7 3273 2890 2864 2864
q8 4347 4442 4468 4442
q9 17178 16984 16909 16909
q10 4240 4268 4268 4268
q11 781 701 671 671
q12 1047 835 841 835
q13 7057 3709 3728 3709
q14 450 414 418 414
q15 499 462 450 450
q16 756 705 707 705
q17 3820 3894 3806 3806
q18 8776 8777 8771 8771
q19 1717 1700 1672 1672
q20 2365 2167 2141 2141
q21 8493 8477 8514 8477
q22 1013 922 966 922
Total cold run time: 84936 ms
Total hot run time: 79772 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 wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928762132
<details>
<summary>TPC-DS: <b>Total hot run time: 238563 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 ae653afa14e20604342ea328ee16662d9d59f121, data reload: false
query1 902 391 375 375
query2 6520 2138 2281 2138
query3 6914 200 205 200
query4 20251 18003 17888 17888
query5 19727 6260 6242 6242
query6 277 210 231 210
query7 4149 310 295 295
query8 250 255 262 255
query9 3127 2727 2654 2654
query10 404 276 294 276
query11 11426 10860 10693 10693
query12 121 75 68 68
query13 5639 654 625 625
query14 17495 13298 13239 13239
query15 395 230 229 229
query16 6446 260 266 260
query17 3228 870 892 870
query18 2274 404 396 396
query19 206 146 138 138
query20 75 75 77 75
query21 185 95 97 95
query22 5265 5094 5084 5084
query23 32562 31713 31690 31690
query24 6919 6592 6461 6461
query25 527 427 410 410
query26 521 164 159 159
query27 1882 292 292 292
query28 6026 2254 2222 2222
query29 2936 2793 2736 2736
query30 237 162 158 158
query31 887 725 732 725
query32 63 56 47 47
query33 397 255 248 248
query34 834 461 470 461
query35 1111 951 926 926
query36 1574 1540 1632 1540
query37 86 57 56 56
query38 3118 2893 2904 2893
query39 1351 1330 1323 1323
query40 200 96 95 95
query41 35 32 34 32
query42 90 84 81 81
query43 617 603 548 548
query44 1096 720 708 708
query45 238 234 221 221
query46 1235 961 983 961
query47 1856 1837 1870 1837
query48 957 667 676 667
query49 607 365 367 365
query50 863 603 598 598
query51 5620 5395 5390 5390
query52 87 75 74 74
query53 432 315 309 309
query54 2431 2236 2234 2234
query55 85 79 82 79
query56 214 181 189 181
query57 1262 1112 1123 1112
query58 206 191 202 191
query59 3446 3122 3065 3065
query60 196 188 191 188
query61 80 82 79 79
query62 827 491 531 491
query63 466 326 325 325
query64 1962 1276 1246 1246
query65 3688 3626 3669 3626
query66 799 374 364 364
query67 15813 14808 15455 14808
query68 8461 660 699 660
query69 555 344 355 344
query70 2285 1739 1652 1652
query71 417 302 298 298
query72 4532 3272 3284 3272
query73 716 317 304 304
query74 6354 5974 5911 5911
query75 4306 3499 3521 3499
query76 4799 1184 1213 1184
query77 671 239 263 239
query78 31777 55243 49070 49070
query79 16689 629 630 629
query80 5410 380 372 372
query81 559 237 231 231
query82 1504 96 92 92
query83 419 132 131 131
query84 253 65 71 65
query85 2627 270 270 270
query86 486 398 427 398
query87 3258 3035 3017 3017
query88 7425 2327 2285 2285
query89 500 294 279 279
query90 2551 212 206 206
query91 158 119 112 112
query92 67 52 55 52
query93 7446 605 578 578
query94 1850 197 206 197
query95 1104 1050 1042 1042
query96 642 324 323 323
query97 6494 6307 6372 6307
query98 199 179 157 157
query99 3941 860 954 860
Total cold run time: 350170 ms
Total hot run time: 238563 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 wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928765953
<details>
<summary>ClickBench: <b>Total hot run time: 31.12 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 ae653afa14e20604342ea328ee16662d9d59f121, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.03 0.02
query3 0.24 0.05 0.07
query4 1.84 0.07 0.07
query5 0.53 0.52 0.52
query6 1.30 0.63 0.62
query7 0.01 0.01 0.01
query8 0.03 0.02 0.03
query9 0.54 0.49 0.49
query10 0.55 0.53 0.53
query11 0.11 0.08 0.09
query12 0.12 0.09 0.09
query13 0.61 0.62 0.62
query14 0.80 0.77 0.80
query15 0.78 0.77 0.78
query16 0.37 0.36 0.37
query17 1.00 1.00 0.96
query18 0.23 0.26 0.26
query19 1.96 1.87 1.86
query20 0.02 0.01 0.01
query21 15.48 0.54 0.55
query22 2.49 2.27 1.47
query23 17.17 0.93 0.88
query24 4.45 4.05 1.38
query25 1.51 0.12 0.11
query26 0.35 0.15 0.13
query27 0.10 0.11 0.11
query28 6.22 0.71 0.73
query29 12.77 2.32 2.30
query30 0.61 0.52 0.52
query31 2.83 0.37 0.38
query32 3.41 0.49 0.49
query33 3.06 3.07 3.10
query34 15.26 4.81 4.80
query35 4.84 4.85 4.84
query36 1.05 1.02 1.01
query37 0.06 0.05 0.04
query38 0.03 0.02 0.02
query39 0.01 0.02 0.01
query40 0.16 0.14 0.14
query41 0.06 0.02 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 103.08 s
Total hot run time: 31.12 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 wrong case in TransposeSemiJoinLogicalJoinProject (#30874) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928768278
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ae653afa14e20604342ea328ee16662d9d59f121 with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 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: 21.4 seconds inserted 10000000 Rows, about 467K 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 wrong case in TransposeSemiJoinLogicalJoinProject… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30885:
URL: https://github.com/apache/doris/pull/30885#issuecomment-1928719037
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