You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "hqx871 (via GitHub)" <gi...@apache.org> on 2024/01/03 12:53:55 UTC
[PR] [fix](array) fix reserve nested column when filter array column [doris]
hqx871 opened a new pull request, #29485:
URL: https://github.com/apache/doris/pull/29485
## 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](array) fix reserve nested column when filter array column [doris]
Posted by "hqx871 (via GitHub)" <gi...@apache.org>.
hqx871 commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876208579
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](array) fix reserve nested column when filter array column [doris]
Posted by "hqx871 (via GitHub)" <gi...@apache.org>.
hqx871 commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875329772
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](array) fix reserve nested column when filter array column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875369673
clang-tidy review says "All clean, LGTM! :+1:"
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875337397
clang-tidy review says "All clean, LGTM! :+1:"
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875355626
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 10f394694e5e3f8a85f7a64e9ddc3d639683aab5, data reload: false
------ Round 1 ----------------------------------
q1 17688 5241 5120 5120
q2 2018 157 144 144
q3 10619 1166 1104 1104
q4 10281 817 798 798
q5 7836 2961 2975 2961
q6 212 136 142 136
q7 925 524 561 524
q8 9308 2005 2016 2005
q9 6821 6440 6338 6338
q10 8257 3007 3048 3007
q11 426 236 223 223
q12 394 236 237 236
q13 18006 3680 3691 3680
q14 250 217 220 217
q15 560 518 517 517
q16 468 401 422 401
q17 972 501 521 501
q18 7419 6801 6684 6684
q19 1582 1431 1345 1345
q20 674 367 324 324
q21 2795 2385 2445 2385
q22 359 317 347 317
Total cold run time: 107870 ms
Total hot run time: 38967 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5113 5061 5082 5061
q2 336 243 236 236
q3 3319 3287 3260 3260
q4 2137 2028 2040 2028
q5 5801 5781 5782 5781
q6 213 128 130 128
q7 2312 1885 1944 1885
q8 3382 3483 3473 3473
q9 8830 8826 8757 8757
q10 3815 3813 3830 3813
q11 578 491 485 485
q12 796 639 624 624
q13 9880 3245 3242 3242
q14 295 286 267 267
q15 578 517 510 510
q16 560 494 498 494
q17 1984 1780 1767 1767
q18 8687 8200 8231 8200
q19 1619 1606 1585 1585
q20 2186 1950 1955 1950
q21 5651 5294 5291 5291
q22 527 475 471 471
Total cold run time: 68599 ms
Total hot run time: 59308 ms
```
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876236069
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 512f420ded56656585b2bbeb46122173be0e06ec, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5452 5118 5090 5090
q2 398 185 149 149
q3 1455 1186 1188 1186
q4 1085 822 858 822
q5 3154 3074 3090 3074
q6 222 138 132 132
q7 965 533 518 518
q8 2163 2297 2286 2286
q9 6723 6671 6663 6663
q10 3161 3107 3120 3107
q11 357 229 208 208
q12 378 235 246 235
q13 4433 3655 3619 3619
q14 247 214 215 214
q15 584 550 521 521
q16 461 407 406 406
q17 1045 535 503 503
q18 7140 7047 6837 6837
q19 1651 1519 1628 1519
q20 538 348 338 338
q21 2838 2492 2542 2492
q22 378 317 323 317
Total cold run time: 44828 ms
Total hot run time: 40236 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5097 5045 5019 5019
q2 339 237 238 237
q3 3356 3333 3290 3290
q4 2137 2019 2023 2019
q5 5955 5933 5950 5933
q6 221 124 125 124
q7 2370 1951 1909 1909
q8 3595 3676 3683 3676
q9 9063 8994 8977 8977
q10 3864 3910 3911 3910
q11 586 476 483 476
q12 802 647 638 638
q13 3898 3250 3166 3166
q14 299 282 270 270
q15 590 536 530 530
q16 545 497 526 497
q17 2018 1798 1824 1798
q18 8784 8376 8334 8334
q19 1765 1718 1716 1716
q20 2281 1967 1982 1967
q21 5820 5375 5438 5375
q22 552 502 482 482
Total cold run time: 63937 ms
Total hot run time: 60343 ms
```
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876226002
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 512f420ded56656585b2bbeb46122173be0e06ec, data reload: false
------ Round 1 ----------------------------------
q1 17686 5284 5106 5106
q2 2023 157 142 142
q3 10639 1092 1221 1092
q4 10409 796 750 750
q5 7797 2941 2922 2922
q6 219 136 135 135
q7 926 509 529 509
q8 9299 2019 2011 2011
q9 6808 6417 6361 6361
q10 8240 3137 3020 3020
q11 431 218 205 205
q12 390 225 228 225
q13 17987 3683 3688 3683
q14 233 216 208 208
q15 562 523 509 509
q16 444 403 394 394
q17 966 427 462 427
q18 7307 6688 6701 6688
q19 1585 1394 1406 1394
q20 713 341 354 341
q21 2794 2285 2403 2285
q22 379 309 325 309
Total cold run time: 107837 ms
Total hot run time: 38716 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5133 5113 5070 5070
q2 335 241 244 241
q3 3299 3282 3288 3282
q4 2121 2033 2040 2033
q5 5786 5759 5756 5756
q6 212 128 126 126
q7 2316 1899 1922 1899
q8 3401 3418 3450 3418
q9 8856 8779 8757 8757
q10 3776 3860 3873 3860
q11 565 469 476 469
q12 804 635 641 635
q13 9560 3176 3210 3176
q14 284 274 275 274
q15 580 520 503 503
q16 533 495 514 495
q17 1935 1828 1752 1752
q18 8622 8349 8176 8176
q19 1638 1565 1574 1565
q20 2177 1973 1957 1957
q21 5611 5202 5218 5202
q22 532 520 475 475
Total cold run time: 68076 ms
Total hot run time: 59121 ms
```
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875369128
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 10f394694e5e3f8a85f7a64e9ddc3d639683aab5, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 962 352 342 342
query2 6344 2098 2063 2063
query3 6646 209 202 202
query4 26497 22451 22390 22390
query5 3816 515 481 481
query6 268 179 185 179
query7 4585 285 272 272
query8 244 204 197 197
query9 8247 2539 2549 2539
query10 386 243 235 235
query11 16107 15451 15521 15451
query12 133 75 77 75
query13 1628 325 328 325
query14 11485 7067 7098 7067
query15 219 188 180 180
query16 6256 266 261 261
query17 1881 501 475 475
query18 1929 269 266 266
query19 192 133 134 133
query20 84 76 77 76
query21 184 99 95 95
query22 4970 4844 4604 4604
query23 32203 31169 31486 31169
query24 11957 2819 2810 2810
query25 595 344 334 334
query26 1560 144 138 138
query27 2902 280 277 277
query28 7014 1921 1889 1889
query29 1676 382 378 378
query30 280 139 139 139
query31 1006 782 746 746
query32 78 58 56 56
query33 726 252 271 252
query34 866 461 440 440
query35 882 789 805 789
query36 1363 1254 1227 1227
query37 153 67 71 67
query38 3381 3324 3258 3258
query39 1311 1296 1308 1296
query40 289 91 84 84
query41 38 36 40 36
query42 91 77 88 77
query43 510 511 483 483
query44 1092 702 708 702
query45 191 190 191 190
query46 1044 654 656 654
query47 1567 1517 1512 1512
query48 329 259 264 259
query49 1119 309 316 309
query50 746 345 369 345
query51 5369 5317 5298 5298
query52 88 86 87 86
query53 218 153 147 147
query54 1236 539 578 539
query55 103 92 90 90
query56 209 191 186 186
query57 1000 961 983 961
query58 202 201 204 201
query59 2826 2643 2588 2588
query60 231 238 217 217
query61 86 85 83 83
query62 686 464 450 450
query63 155 150 147 147
query64 5542 1713 1706 1706
query65 3308 3236 3252 3236
query66 1238 360 328 328
query67 15715 15090 15192 15090
query68 10603 541 535 535
query69 502 249 251 249
query70 1684 1474 1484 1474
query71 501 212 210 210
query72 5453 3535 3492 3492
query73 2126 320 310 310
query74 6958 6444 6433 6433
query75 5236 2292 2278 2278
query76 6400 1011 956 956
query77 659 251 248 248
query78 9153 8846 8582 8582
query79 1022 511 499 499
query80 520 352 347 347
query81 469 207 213 207
query82 211 94 90 90
query83 158 135 135 135
query84 248 54 51 51
query85 876 273 266 266
query86 456 429 379 379
query87 3590 3410 3367 3367
query88 2951 2270 2259 2259
query89 323 257 249 249
query90 1931 198 190 190
query91 117 98 99 98
query92 56 46 50 46
query93 1106 503 500 500
query94 754 172 182 172
query95 450 404 401 401
query96 624 324 317 317
query97 4281 4124 4193 4124
query98 220 205 184 184
query99 1146 833 831 831
Total cold run time: 287028 ms
Total hot run time: 178656 ms
```
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875377679
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.51 seconds
stream load tsv: 563 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.4 seconds inserted 10000000 Rows, about 352K ops/s
storage size: 17183838295 Bytes
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875367308
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 10f394694e5e3f8a85f7a64e9ddc3d639683aab5, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5529 5102 5107 5102
q2 393 181 147 147
q3 1472 1169 1096 1096
q4 1106 775 830 775
q5 3142 3098 3130 3098
q6 220 138 132 132
q7 977 546 513 513
q8 2150 2269 2282 2269
q9 6672 6691 6702 6691
q10 3164 3084 3086 3084
q11 359 217 213 213
q12 383 236 230 230
q13 4393 3598 3627 3598
q14 253 211 223 211
q15 583 537 522 522
q16 456 393 401 393
q17 1045 520 531 520
q18 7089 6706 6748 6706
q19 1739 1540 1393 1393
q20 574 354 330 330
q21 2863 2403 2448 2403
q22 403 329 334 329
Total cold run time: 44965 ms
Total hot run time: 39755 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5118 5097 5055 5055
q2 341 227 232 227
q3 3356 3326 3325 3325
q4 2146 2036 2053 2036
q5 5947 5910 5867 5867
q6 221 125 127 125
q7 2360 1907 1928 1907
q8 3565 3650 3656 3650
q9 8994 8925 9009 8925
q10 3849 3923 3899 3899
q11 587 474 490 474
q12 805 632 649 632
q13 3868 3180 3195 3180
q14 311 262 266 262
q15 588 522 540 522
q16 566 507 491 491
q17 2036 1833 1821 1821
q18 8796 8347 8370 8347
q19 1738 1698 1701 1698
q20 2257 2006 1968 1968
q21 5642 5317 5315 5315
q22 565 512 503 503
Total cold run time: 63656 ms
Total hot run time: 60229 ms
```
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876235692
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.18 seconds
stream load tsv: 577 seconds loaded 74807831229 Bytes, about 123 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.2 seconds inserted 10000000 Rows, about 354K ops/s
storage size: 17183904784 Bytes
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-2204751166
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #29485: [fix](array) fix reserve nested column when filter array column
URL: https://github.com/apache/doris/pull/29485
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1875377080
TeamCity be ut coverage result:
Function Coverage: 36.66% (8622/23518)
Line Coverage: 28.71% (70088/244141)
Region Coverage: 27.69% (36283/131025)
Branch Coverage: 24.39% (18535/76000)
Coverage Report: http://coverage.selectdb-in.cc/coverage/10f394694e5e3f8a85f7a64e9ddc3d639683aab5_10f394694e5e3f8a85f7a64e9ddc3d639683aab5/report/index.html
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876228337
TeamCity be ut coverage result:
Function Coverage: 36.67% (8624/23517)
Line Coverage: 28.71% (70106/244150)
Region Coverage: 27.70% (36293/131039)
Branch Coverage: 24.39% (18537/76012)
Coverage Report: http://coverage.selectdb-in.cc/coverage/512f420ded56656585b2bbeb46122173be0e06ec_512f420ded56656585b2bbeb46122173be0e06ec/report/index.html
--
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](array) fix reserve nested column when filter array column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29485:
URL: https://github.com/apache/doris/pull/29485#issuecomment-1876233573
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 512f420ded56656585b2bbeb46122173be0e06ec, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 927 346 338 338
query2 6422 2054 1987 1987
query3 6655 216 211 211
query4 27191 22370 22413 22370
query5 3897 513 516 513
query6 278 189 179 179
query7 4583 280 269 269
query8 222 205 197 197
query9 8285 2607 2556 2556
query10 425 231 254 231
query11 16138 15466 15388 15388
query12 134 82 72 72
query13 1623 328 326 326
query14 11554 7127 7186 7127
query15 213 182 190 182
query16 6124 274 269 269
query17 1815 496 485 485
query18 1810 268 274 268
query19 185 144 135 135
query20 82 76 79 76
query21 187 100 98 98
query22 5021 4725 4498 4498
query23 32228 31202 31162 31162
query24 12042 2841 2821 2821
query25 616 348 329 329
query26 1814 145 149 145
query27 2898 273 280 273
query28 7013 1889 1882 1882
query29 2226 383 399 383
query30 286 141 146 141
query31 997 767 772 767
query32 98 58 60 58
query33 734 254 269 254
query34 900 464 452 452
query35 912 779 798 779
query36 1311 1269 1200 1200
query37 155 68 69 68
query38 3434 3301 3283 3283
query39 1346 1290 1277 1277
query40 306 93 88 88
query41 38 36 41 36
query42 84 81 79 79
query43 517 507 480 480
query44 1107 703 716 703
query45 200 190 182 182
query46 1057 651 631 631
query47 1705 1572 1554 1554
query48 341 268 263 263
query49 1214 310 324 310
query50 736 361 326 326
query51 5462 5303 5410 5303
query52 93 89 85 85
query53 213 151 148 148
query54 1388 549 563 549
query55 103 90 81 81
query56 185 191 196 191
query57 1030 944 945 944
query58 224 203 196 196
query59 2880 2598 2692 2598
query60 226 225 229 225
query61 87 86 89 86
query62 611 461 456 456
query63 164 145 145 145
query64 5921 1736 1768 1736
query65 3303 3254 3258 3254
query66 1398 350 348 348
query67 15693 15339 15109 15109
query68 11019 537 556 537
query69 530 243 251 243
query70 1727 1506 1496 1496
query71 490 214 222 214
query72 5660 3620 3583 3583
query73 2222 311 309 309
query74 7013 6454 6366 6366
query75 4801 2279 2306 2279
query76 6262 1129 1135 1129
query77 667 290 284 284
query78 9117 8858 8463 8463
query79 1066 504 503 503
query80 548 352 350 350
query81 475 209 209 209
query82 208 97 93 93
query83 161 150 144 144
query84 244 55 52 52
query85 916 304 275 275
query86 413 391 396 391
query87 3542 3428 3330 3330
query88 2790 2278 2261 2261
query89 339 250 254 250
query90 1888 200 194 194
query91 119 96 95 95
query92 57 51 48 48
query93 2144 434 434 434
query94 852 180 179 179
query95 456 413 427 413
query96 640 323 314 314
query97 4271 4171 4182 4171
query98 211 192 190 190
query99 1094 811 766 766
Total cold run time: 291009 ms
Total hot run time: 178720 ms
```
--
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