You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "englefly (via GitHub)" <gi...@apache.org> on 2024/01/30 07:51:02 UTC
[PR] [runtimefilter](nereids)push down RF into cte producer [doris]
englefly opened a new pull request, #30568:
URL: https://github.com/apache/doris/pull/30568
## 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918806538
<details>
<summary>ClickBench: <b>Total hot run time: 30.78 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
query1 0.04 0.02 0.03
query2 0.06 0.02 0.02
query3 0.23 0.07 0.06
query4 1.65 0.10 0.10
query5 0.53 0.51 0.52
query6 1.20 0.64 0.63
query7 0.02 0.02 0.01
query8 0.03 0.02 0.03
query9 0.54 0.49 0.51
query10 0.58 0.54 0.55
query11 0.12 0.08 0.08
query12 0.11 0.09 0.10
query13 0.61 0.60 0.60
query14 0.78 0.83 0.81
query15 0.81 0.78 0.78
query16 0.39 0.37 0.39
query17 0.98 0.98 1.02
query18 0.22 0.23 0.27
query19 1.90 1.75 1.78
query20 0.02 0.01 0.01
query21 15.43 0.57 0.57
query22 2.88 2.87 1.60
query23 17.40 0.86 0.92
query24 2.81 0.95 1.15
query25 0.24 0.17 0.19
query26 0.62 0.14 0.14
query27 0.05 0.06 0.04
query28 11.88 0.86 0.83
query29 12.52 3.15 3.07
query30 0.61 0.54 0.56
query31 2.79 0.36 0.35
query32 3.32 0.47 0.48
query33 3.25 3.22 3.23
query34 16.00 4.25 4.33
query35 4.31 4.31 4.32
query36 1.10 1.05 1.05
query37 0.08 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.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.45 s
Total hot run time: 30.78 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920582390
run pipelinex_p0
--
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920423709
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 14667e1b8e14aafddd8e33bd057dd63d0c796252 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 13.5 seconds inserted 10000000 Rows, about 740K 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1922749885
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920375075
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1922749861
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920582962
run pipelinex_p0
--
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918741129
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918797030
<details>
<summary>TPC-DS: <b>Total hot run time: 175847 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
query1 929 371 353 353
query2 6522 2033 1956 1956
query3 6698 200 201 200
query4 31941 22206 22254 22206
query5 4165 397 377 377
query6 265 155 153 153
query7 4615 272 263 263
query8 243 174 178 174
query9 9097 2268 2247 2247
query10 410 204 204 204
query11 18987 15596 15550 15550
query12 127 69 69 69
query13 1622 379 387 379
query14 9380 6921 7019 6921
query15 216 178 176 176
query16 7807 262 250 250
query17 1873 510 467 467
query18 2029 273 259 259
query19 176 139 129 129
query20 72 66 72 66
query21 202 139 140 139
query22 4917 4739 4732 4732
query23 31477 30402 30400 30400
query24 11872 2729 2794 2729
query25 570 314 317 314
query26 1677 140 140 140
query27 2718 295 287 287
query28 7520 1843 1824 1824
query29 2022 646 611 611
query30 299 144 144 144
query31 942 713 696 696
query32 95 54 47 47
query33 720 204 216 204
query34 1099 480 468 468
query35 872 764 767 764
query36 1289 1211 1161 1161
query37 179 58 59 58
query38 3223 3162 3164 3162
query39 1305 1272 1256 1256
query40 336 85 88 85
query41 37 35 35 35
query42 91 87 85 85
query43 520 479 487 479
query44 1086 686 685 685
query45 194 186 183 183
query46 1065 629 644 629
query47 1645 1506 1456 1456
query48 423 310 337 310
query49 1250 293 288 288
query50 716 314 306 306
query51 5327 5200 5169 5169
query52 88 82 77 77
query53 324 271 266 266
query54 270 180 188 180
query55 82 79 81 79
query56 180 161 170 161
query57 1011 901 897 897
query58 194 164 177 164
query59 2391 2361 2324 2324
query60 208 183 175 175
query61 83 86 83 83
query62 674 376 348 348
query63 279 266 266 266
query64 6159 3752 3502 3502
query65 3361 3292 3285 3285
query66 1400 312 305 305
query67 14581 14272 14154 14154
query68 4276 504 515 504
query69 446 314 299 299
query70 1474 1513 1524 1513
query71 308 217 214 214
query72 5714 3137 2815 2815
query73 695 319 321 319
query74 6760 6264 6189 6189
query75 3081 2391 2314 2314
query76 2497 903 931 903
query77 346 229 227 227
query78 9566 9052 8782 8782
query79 3055 513 515 513
query80 2230 317 309 309
query81 533 211 214 211
query82 807 89 81 81
query83 262 114 119 114
query84 287 72 80 72
query85 2435 339 317 317
query86 512 389 410 389
query87 3388 3197 3167 3167
query88 4242 2170 2160 2160
query89 438 357 363 357
query90 1949 187 183 183
query91 151 118 119 118
query92 67 44 43 43
query93 5018 434 422 422
query94 1395 166 159 159
query95 462 352 362 352
query96 664 316 306 306
query97 4297 4145 4158 4145
query98 221 197 183 183
query99 1156 705 656 656
Total cold run time: 292879 ms
Total hot run time: 175847 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920415156
<details>
<summary>TPC-DS: <b>Total hot run time: 175330 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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
query1 921 335 327 327
query2 6575 1963 1856 1856
query3 6700 202 197 197
query4 31872 22042 21969 21969
query5 4095 320 323 320
query6 254 162 154 154
query7 4689 254 254 254
query8 236 173 181 173
query9 8941 2274 2257 2257
query10 405 192 205 192
query11 18249 15380 15470 15380
query12 121 66 69 66
query13 1628 383 374 374
query14 8684 7005 7072 7005
query15 241 171 179 171
query16 7883 267 253 253
query17 1865 498 479 479
query18 2025 249 257 249
query19 282 133 129 129
query20 74 68 66 66
query21 198 130 128 128
query22 4893 4674 4676 4674
query23 31149 30458 30394 30394
query24 7139 2808 2761 2761
query25 533 320 312 312
query26 712 143 141 141
query27 1985 289 281 281
query28 3680 1860 1832 1832
query29 912 615 615 615
query30 283 132 135 132
query31 915 713 712 712
query32 94 53 46 46
query33 530 213 206 206
query34 1604 461 484 461
query35 891 818 806 806
query36 1400 1317 1279 1279
query37 100 63 68 63
query38 3463 3259 3245 3245
query39 1336 1308 1322 1308
query40 208 91 85 85
query41 40 37 38 37
query42 98 84 87 84
query43 541 524 523 523
query44 1058 719 719 719
query45 205 196 192 192
query46 1074 650 645 645
query47 1780 1673 1496 1496
query48 372 304 298 298
query49 1112 279 280 279
query50 702 314 319 314
query51 5381 5235 5173 5173
query52 98 78 76 76
query53 326 255 261 255
query54 216 176 188 176
query55 82 77 90 77
query56 178 177 154 154
query57 960 895 914 895
query58 188 159 158 158
query59 2333 2317 2374 2317
query60 583 202 170 170
query61 89 81 81 81
query62 723 361 353 353
query63 284 260 260 260
query64 4465 3717 3367 3367
query65 3258 3244 3210 3210
query66 930 318 312 312
query67 14550 14256 14166 14166
query68 5431 495 483 483
query69 472 313 292 292
query70 1614 1578 1585 1578
query71 326 233 213 213
query72 6209 3156 2855 2855
query73 678 310 306 306
query74 6678 6178 6234 6178
query75 3053 2292 2352 2292
query76 2999 932 904 904
query77 378 227 228 227
query78 9326 8690 8591 8591
query79 2246 510 498 498
query80 1041 319 312 312
query81 535 194 192 192
query82 962 85 81 81
query83 226 109 121 109
query84 233 81 69 69
query85 2046 341 336 336
query86 523 387 429 387
query87 3356 3247 3232 3232
query88 3925 2152 2157 2152
query89 421 354 371 354
query90 1900 188 186 186
query91 152 115 118 115
query92 54 43 43 43
query93 2726 456 412 412
query94 1365 161 156 156
query95 479 354 345 345
query96 627 321 320 320
query97 4251 4096 4082 4082
query98 203 201 181 181
query99 995 710 710 710
Total cold run time: 274821 ms
Total hot run time: 175330 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920420964
<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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.02
query3 0.24 0.06 0.06
query4 1.65 0.10 0.09
query5 0.52 0.51 0.52
query6 1.18 0.63 0.64
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.55 0.49 0.50
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.58 0.62
query14 0.79 0.78 0.79
query15 0.79 0.77 0.78
query16 0.38 0.37 0.40
query17 1.04 1.03 0.96
query18 0.24 0.28 0.24
query19 1.80 1.79 1.77
query20 0.01 0.01 0.01
query21 15.40 0.57 0.57
query22 2.64 2.63 2.39
query23 17.24 0.75 0.86
query24 2.68 1.54 0.89
query25 0.30 0.26 0.15
query26 0.51 0.13 0.15
query27 0.05 0.04 0.05
query28 11.29 0.84 0.84
query29 12.70 3.16 3.21
query30 0.55 0.51 0.52
query31 2.79 0.35 0.35
query32 3.33 0.48 0.49
query33 3.22 3.22 3.20
query34 15.89 4.29 4.32
query35 4.31 4.35 4.40
query36 1.10 1.06 1.07
query37 0.06 0.04 0.04
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.14 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918811831
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d5d4f782c688b987c6df42f9e95b9f0221b102d1 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: 13.2 seconds inserted 10000000 Rows, about 757K 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920405352
<details>
<summary>TPC-H: <b>Total hot run time: 36601 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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
------ Round 1 ----------------------------------
q1 17662 4474 4424 4424
q2 2036 138 128 128
q3 10685 909 928 909
q4 4640 659 701 659
q5 7673 2740 2718 2718
q6 184 120 120 120
q7 1123 713 711 711
q8 9273 1990 1996 1990
q9 7229 6312 6265 6265
q10 8118 2383 2405 2383
q11 410 211 209 209
q12 823 277 279 277
q13 18003 3308 3310 3308
q14 271 247 242 242
q15 520 499 484 484
q16 496 397 400 397
q17 927 618 479 479
q18 6721 5941 5896 5896
q19 1544 1360 1420 1360
q20 568 318 336 318
q21 6706 3069 3037 3037
q22 812 300 287 287
Total cold run time: 106424 ms
Total hot run time: 36601 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4486 4321 4417 4321
q2 333 237 223 223
q3 2964 2833 2805 2805
q4 1873 1676 1581 1581
q5 5090 5210 5207 5207
q6 194 115 115 115
q7 2180 1775 1768 1768
q8 3103 3218 3250 3218
q9 8236 8270 8300 8270
q10 5910 3569 3558 3558
q11 552 462 467 462
q12 752 576 568 568
q13 11628 3097 3044 3044
q14 282 268 260 260
q15 536 482 487 482
q16 520 447 463 447
q17 1838 1735 1700 1700
q18 7788 7770 7510 7510
q19 10231 1571 1545 1545
q20 2131 1930 1906 1906
q21 4808 4679 4602 4602
q22 568 474 523 474
Total cold run time: 76003 ms
Total hot run time: 54066 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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918737554
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920513053
run pipelinx_p0
--
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920373933
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1920576980
run pipelinx_p0
--
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly merged PR #30568:
URL: https://github.com/apache/doris/pull/30568
--
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] [runtimefilter](nereids)push down RF into cte producer [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30568:
URL: https://github.com/apache/doris/pull/30568#issuecomment-1918776529
<details>
<summary>TPC-H: <b>Total hot run time: 37024 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
------ Round 1 ----------------------------------
q1 17728 4571 4471 4471
q2 2602 139 131 131
q3 11866 932 938 932
q4 4961 749 734 734
q5 8027 2829 2740 2740
q6 183 120 121 120
q7 1149 714 705 705
q8 9240 1990 1996 1990
q9 7246 6362 6308 6308
q10 8132 2453 2416 2416
q11 420 198 195 195
q12 778 275 273 273
q13 18008 3313 3289 3289
q14 285 252 263 252
q15 531 492 482 482
q16 463 404 408 404
q17 937 479 513 479
q18 6859 6087 6037 6037
q19 1599 1447 1380 1380
q20 625 360 321 321
q21 7019 3064 3057 3057
q22 823 321 308 308
Total cold run time: 109481 ms
Total hot run time: 37024 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4433 4305 4396 4305
q2 320 238 228 228
q3 2978 2889 2822 2822
q4 1834 1626 1572 1572
q5 5187 5252 5257 5252
q6 189 114 115 114
q7 2138 1822 1784 1784
q8 3074 3209 3262 3209
q9 8327 8327 8262 8262
q10 5928 3565 3554 3554
q11 538 467 453 453
q12 745 577 580 577
q13 15493 3069 3085 3069
q14 286 251 261 251
q15 530 492 485 485
q16 527 469 468 468
q17 1815 1681 1749 1681
q18 7837 7793 7746 7746
q19 6940 1502 1547 1502
q20 2122 1930 1903 1903
q21 4785 4502 4539 4502
q22 558 474 458 458
Total cold run time: 76584 ms
Total hot run time: 54197 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