You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhangstar333 (via GitHub)" <gi...@apache.org> on 2024/01/04 09:23:46 UTC
[PR] array_zip function [doris]
zhangstar333 opened a new pull request, #29534:
URL: https://github.com/apache/doris/pull/29534
## 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876777137
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878654756
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 c27fa771dc44a91ff3d8c9df7b0b90b10c682ff2, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 925 344 339 339
query2 6407 1874 1832 1832
query3 6654 209 201 201
query4 25914 22503 22289 22289
query5 4990 562 497 497
query6 268 173 175 173
query7 4576 264 270 264
query8 234 201 221 201
query9 8338 2642 2606 2606
query10 463 239 253 239
query11 16156 15534 15588 15534
query12 136 76 76 76
query13 1646 331 328 328
query14 11947 7099 7034 7034
query15 220 189 188 188
query16 6293 268 262 262
query17 1819 500 483 483
query18 1902 276 258 258
query19 193 137 130 130
query20 77 76 80 76
query21 188 97 95 95
query22 5149 4587 4522 4522
query23 32056 31113 31324 31113
query24 11930 2839 2828 2828
query25 604 332 341 332
query26 1739 142 146 142
query27 2879 266 280 266
query28 7100 1926 1914 1914
query29 2015 391 396 391
query30 296 138 141 138
query31 986 781 783 781
query32 87 54 54 54
query33 726 270 251 251
query34 926 441 442 441
query35 902 799 807 799
query36 1277 1270 1265 1265
query37 181 64 65 64
query38 3378 3289 3253 3253
query39 1321 1274 1297 1274
query40 302 88 86 86
query41 41 36 34 34
query42 94 87 79 79
query43 500 483 476 476
query44 1032 700 707 700
query45 191 189 179 179
query46 1055 640 623 623
query47 1625 1544 1521 1521
query48 323 257 262 257
query49 1194 317 317 317
query50 748 358 326 326
query51 5440 5367 5292 5292
query52 98 80 86 80
query53 210 151 142 142
query54 1329 564 576 564
query55 92 78 77 77
query56 191 185 188 185
query57 1055 1000 1004 1000
query58 214 192 203 192
query59 2778 2554 2523 2523
query60 225 215 210 210
query61 85 81 82 81
query62 725 452 460 452
query63 163 146 148 146
query64 5755 1773 1704 1704
query65 3321 3246 3250 3246
query66 1301 334 335 334
query67 15577 15512 15012 15012
query68 11100 525 534 525
query69 503 250 269 250
query70 1659 1522 1435 1435
query71 501 198 220 198
query72 5589 3525 3512 3512
query73 2140 342 309 309
query74 7038 6372 6469 6372
query75 4918 2280 2240 2240
query76 6238 1077 1054 1054
query77 673 246 255 246
query78 9137 8834 8555 8555
query79 1301 498 493 493
query80 632 336 335 335
query81 454 212 208 208
query82 205 95 96 95
query83 162 132 142 132
query84 239 53 50 50
query85 931 274 265 265
query86 388 382 396 382
query87 3604 3409 3394 3394
query88 3030 2218 2215 2215
query89 334 261 248 248
query90 1907 191 187 187
query91 116 87 87 87
query92 58 50 54 50
query93 2962 445 499 445
query94 824 179 175 175
query95 447 413 399 399
query96 622 317 312 312
query97 4292 4192 4200 4192
query98 204 189 191 189
query99 1141 797 802 797
Total cold run time: 291911 ms
Total hot run time: 178117 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876768123
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880479927
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878462443
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878492235
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 362c84006fd1cdde400a920eb40581d04457fdcc, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 922 345 341 341
query2 4355 1813 1834 1813
query3 6566 202 198 198
query4 27902 22375 22356 22356
query5 3444 508 510 508
query6 259 178 179 178
query7 4550 270 263 263
query8 222 194 192 192
query9 8045 2636 2661 2636
query10 376 251 270 251
query11 16107 15514 15524 15514
query12 125 74 76 74
query13 1601 334 326 326
query14 10120 7072 7074 7072
query15 214 180 195 180
query16 4704 261 259 259
query17 1761 492 478 478
query18 1551 264 259 259
query19 186 137 133 133
query20 78 72 74 72
query21 166 94 94 94
query22 5090 4588 4781 4588
query23 32550 31270 31330 31270
query24 12083 2814 2842 2814
query25 580 345 345 345
query26 1640 136 138 136
query27 2886 276 286 276
query28 7135 1950 1936 1936
query29 1377 386 400 386
query30 266 140 143 140
query31 1007 788 776 776
query32 63 58 55 55
query33 726 264 245 245
query34 1107 447 449 447
query35 883 711 762 711
query36 1289 1162 1239 1162
query37 156 69 72 69
query38 3392 3327 3324 3324
query39 1316 1288 1281 1281
query40 259 86 83 83
query41 45 34 36 34
query42 86 84 94 84
query43 503 494 461 461
query44 1048 694 712 694
query45 189 186 185 185
query46 1064 619 644 619
query47 1579 1617 1531 1531
query48 340 256 268 256
query49 1180 315 306 306
query50 743 331 328 328
query51 5410 5308 5248 5248
query52 94 87 87 87
query53 210 150 146 146
query54 1496 577 558 558
query55 100 89 79 79
query56 183 176 194 176
query57 1057 961 969 961
query58 220 195 204 195
query59 2765 2561 2529 2529
query60 235 213 200 200
query61 83 84 84 84
query62 630 439 444 439
query63 166 143 152 143
query64 5068 1742 1756 1742
query65 3353 3251 3253 3251
query66 1356 332 337 332
query67 15964 15643 15100 15100
query68 12311 542 521 521
query69 483 233 242 233
query70 1704 1465 1468 1465
query71 492 219 221 219
query72 5779 3508 3541 3508
query73 2825 318 310 310
query74 7521 6473 6401 6401
query75 5589 2244 2273 2244
query76 6151 1142 1069 1069
query77 689 252 250 250
query78 9066 8631 8614 8614
query79 1026 502 497 497
query80 529 357 345 345
query81 458 205 210 205
query82 191 95 88 88
query83 162 135 132 132
query84 246 51 54 51
query85 974 282 264 264
query86 376 373 393 373
query87 3596 3416 3392 3392
query88 3146 2243 2255 2243
query89 334 245 257 245
query90 1943 196 192 192
query91 124 96 90 90
query92 59 49 51 49
query93 1573 453 438 438
query94 903 177 178 177
query95 458 405 411 405
query96 623 322 318 318
query97 4308 4159 4178 4159
query98 210 194 192 192
query99 1083 860 792 792
Total cold run time: 287158 ms
Total hot run time: 178490 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878546432
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 362c84006fd1cdde400a920eb40581d04457fdcc, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5479 5087 5147 5087
q2 388 165 158 158
q3 1475 1211 1124 1124
q4 1092 866 812 812
q5 3117 3132 3066 3066
q6 222 136 135 135
q7 965 535 531 531
q8 2147 2232 2303 2232
q9 6703 6718 6689 6689
q10 3185 3136 3169 3136
q11 347 216 239 216
q12 386 225 230 225
q13 4383 3606 3657 3606
q14 247 215 218 215
q15 585 540 535 535
q16 478 391 415 391
q17 1062 568 501 501
q18 7104 6736 6836 6736
q19 1641 1453 1596 1453
q20 545 361 334 334
q21 2896 2496 2472 2472
q22 387 339 337 337
Total cold run time: 44834 ms
Total hot run time: 39991 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5128 5093 5056 5056
q2 341 231 232 231
q3 3377 3316 3308 3308
q4 2153 2080 2054 2054
q5 6049 5927 5923 5923
q6 225 126 128 126
q7 2429 1904 1937 1904
q8 3573 3664 3685 3664
q9 9127 9016 9000 9000
q10 3841 3948 3908 3908
q11 601 477 469 469
q12 798 627 635 627
q13 3879 3189 3177 3177
q14 315 275 287 275
q15 589 538 536 536
q16 533 502 497 497
q17 2033 1859 1830 1830
q18 8706 8362 8506 8362
q19 1741 1693 1704 1693
q20 2279 1991 1973 1973
q21 5778 5287 5325 5287
q22 562 491 521 491
Total cold run time: 64057 ms
Total hot run time: 60391 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876823626
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 ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 931 340 326 326
query2 6423 1850 1938 1850
query3 6667 210 202 202
query4 26348 22589 22537 22537
query5 3895 506 503 503
query6 265 185 182 182
query7 4579 268 261 261
query8 233 216 203 203
query9 8256 2534 2540 2534
query10 439 230 243 230
query11 16139 15605 15483 15483
query12 126 76 74 74
query13 1632 314 314 314
query14 11355 6997 6968 6968
query15 219 189 207 189
query16 6404 268 260 260
query17 1890 494 487 487
query18 1963 266 264 264
query19 197 138 138 138
query20 77 74 76 74
query21 180 99 96 96
query22 5045 4586 4730 4586
query23 32230 31397 31147 31147
query24 12044 2781 2773 2773
query25 610 349 344 344
query26 1753 133 137 133
query27 2933 266 274 266
query28 7073 1866 1852 1852
query29 2088 399 385 385
query30 286 145 146 145
query31 970 762 781 762
query32 93 57 60 57
query33 731 255 266 255
query34 902 448 441 441
query35 877 802 747 747
query36 1271 1260 1285 1260
query37 182 70 69 69
query38 3438 3289 3299 3289
query39 1312 1267 1287 1267
query40 306 85 82 82
query41 37 36 40 36
query42 85 86 91 86
query43 533 508 497 497
query44 1080 684 713 684
query45 205 187 178 178
query46 1072 622 609 609
query47 1630 1585 1561 1561
query48 322 260 266 260
query49 1216 317 317 317
query50 742 352 362 352
query51 5364 5265 5246 5246
query52 88 93 81 81
query53 215 149 150 149
query54 1360 547 554 547
query55 90 84 85 84
query56 196 196 189 189
query57 1016 943 905 905
query58 219 199 195 195
query59 2750 2632 2590 2590
query60 223 205 215 205
query61 93 91 91 91
query62 623 461 464 461
query63 168 140 147 140
query64 5953 1754 1712 1712
query65 3335 3251 3242 3242
query66 1399 342 332 332
query67 15512 15071 15329 15071
query68 10952 507 502 502
query69 505 259 255 255
query70 1704 1518 1453 1453
query71 493 216 202 202
query72 5728 3646 3671 3646
query73 2093 314 305 305
query74 7002 6437 6386 6386
query75 4851 2308 2294 2294
query76 6303 1074 1128 1074
query77 668 240 254 240
query78 9057 8714 8570 8570
query79 1055 497 498 497
query80 570 356 348 348
query81 452 210 217 210
query82 200 92 87 87
query83 171 139 136 136
query84 244 55 55 55
query85 953 312 285 285
query86 459 385 413 385
query87 3532 3375 3385 3375
query88 3100 2236 2229 2229
query89 341 264 253 253
query90 1869 196 192 192
query91 123 92 107 92
query92 62 49 52 49
query93 2855 422 479 422
query94 832 183 179 179
query95 450 419 397 397
query96 620 315 318 315
query97 4269 4125 4153 4125
query98 210 197 195 195
query99 1116 832 832 832
Total cold run time: 290727 ms
Total hot run time: 178440 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878493897
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.47 seconds
stream load tsv: 566 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: 27.5 seconds inserted 10000000 Rows, about 363K ops/s
storage size: 17183829857 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880474742
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878455721
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880401301
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.62 seconds
stream load tsv: 562 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: 26.4 seconds inserted 10000000 Rows, about 378K ops/s
storage size: 17188317153 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880347062
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876807821
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 ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5542 5180 5121 5121
q2 393 168 161 161
q3 1453 1221 1168 1168
q4 1091 783 757 757
q5 3150 3071 3103 3071
q6 227 138 136 136
q7 980 563 530 530
q8 2152 2194 2196 2194
q9 6726 6673 6651 6651
q10 3156 3050 3157 3050
q11 342 220 210 210
q12 383 240 244 240
q13 4431 3711 3675 3675
q14 248 218 220 218
q15 579 539 520 520
q16 463 408 405 405
q17 1050 510 466 466
q18 7122 6732 6776 6732
q19 1652 1497 1629 1497
q20 582 347 349 347
q21 2904 2491 2454 2454
q22 396 326 327 326
Total cold run time: 45022 ms
Total hot run time: 39929 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5170 5001 5074 5001
q2 339 239 238 238
q3 3374 3330 3317 3317
q4 2163 2070 2006 2006
q5 5945 5971 5935 5935
q6 220 127 128 127
q7 2365 1905 1936 1905
q8 3574 3692 3683 3683
q9 9077 8977 8988 8977
q10 3839 3894 3906 3894
q11 568 472 477 472
q12 798 638 647 638
q13 3879 3208 3208 3208
q14 311 276 276 276
q15 596 531 530 530
q16 559 514 503 503
q17 2024 1789 1829 1789
q18 8725 8312 8359 8312
q19 1759 1686 1686 1686
q20 2256 1969 2001 1969
q21 5736 5332 5253 5253
q22 560 480 487 480
Total cold run time: 63837 ms
Total hot run time: 60199 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878641593
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 c27fa771dc44a91ff3d8c9df7b0b90b10c682ff2, data reload: false
------ Round 1 ----------------------------------
q1 18548 5245 5086 5086
q2 2046 157 145 145
q3 10621 1105 1147 1105
q4 10263 771 731 731
q5 7874 3000 2781 2781
q6 221 132 133 132
q7 919 512 548 512
q8 9283 2041 2011 2011
q9 6833 6447 6423 6423
q10 8302 3023 3017 3017
q11 426 219 221 219
q12 388 232 232 232
q13 18006 3618 3621 3618
q14 246 209 214 209
q15 556 521 525 521
q16 442 392 395 392
q17 969 531 469 469
q18 7467 6783 6686 6686
q19 1582 1346 1415 1346
q20 687 365 349 349
q21 2899 2379 2441 2379
q22 381 324 340 324
Total cold run time: 108959 ms
Total hot run time: 38687 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5103 5075 5035 5035
q2 336 233 235 233
q3 3297 3305 3281 3281
q4 2134 2033 2064 2033
q5 5829 5771 5767 5767
q6 217 123 128 123
q7 2347 1933 1933 1933
q8 3386 3431 3440 3431
q9 8866 8817 8742 8742
q10 3764 3826 3844 3826
q11 587 488 500 488
q12 811 623 618 618
q13 5811 3197 3165 3165
q14 298 265 262 262
q15 591 515 515 515
q16 553 475 477 475
q17 1920 1780 1787 1780
q18 8802 8436 8309 8309
q19 1617 1593 1591 1591
q20 2190 1965 1933 1933
q21 5657 5237 5329 5237
q22 537 546 501 501
Total cold run time: 64653 ms
Total hot run time: 59278 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 closed pull request #29534: [opt](function) change array_zip function null literal to array<null>
URL: https://github.com/apache/doris/pull/29534
--
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878478927
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 362c84006fd1cdde400a920eb40581d04457fdcc, data reload: false
------ Round 1 ----------------------------------
q1 18091 5169 5118 5118
q2 2012 157 142 142
q3 10613 1113 1135 1113
q4 10192 802 786 786
q5 7802 2939 2851 2851
q6 220 131 131 131
q7 916 565 498 498
q8 9262 2020 2020 2020
q9 6876 6435 6382 6382
q10 8221 3013 3035 3013
q11 439 224 227 224
q12 381 227 216 216
q13 17994 3640 3646 3640
q14 244 212 223 212
q15 558 520 517 517
q16 440 423 410 410
q17 978 530 480 480
q18 7445 6769 6752 6752
q19 1566 1329 1388 1329
q20 690 328 309 309
q21 2791 2351 2459 2351
q22 378 323 333 323
Total cold run time: 108109 ms
Total hot run time: 38817 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5151 5175 5100 5100
q2 341 234 242 234
q3 3291 3281 3288 3281
q4 2107 1997 1974 1974
q5 5794 5783 5776 5776
q6 214 123 126 123
q7 2362 1966 1905 1905
q8 3367 3446 3492 3446
q9 8860 8765 8769 8765
q10 3780 3832 3831 3831
q11 561 482 473 473
q12 785 642 622 622
q13 9380 3179 3200 3179
q14 282 269 276 269
q15 597 520 512 512
q16 542 511 509 509
q17 1959 1746 1772 1746
q18 8822 8323 8387 8323
q19 1620 1593 1588 1588
q20 2206 1963 1914 1914
q21 5591 5191 5233 5191
q22 541 460 458 458
Total cold run time: 68153 ms
Total hot run time: 59219 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878627270
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880343164
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880509924
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.1 seconds
stream load tsv: 575 seconds loaded 74807831229 Bytes, about 124 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: 27.0 seconds inserted 10000000 Rows, about 370K ops/s
storage size: 17184058535 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878656496
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.77 seconds
stream load tsv: 565 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: 27.2 seconds inserted 10000000 Rows, about 367K ops/s
storage size: 17183288997 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876811191
TeamCity be ut coverage result:
Function Coverage: 36.64% (8617/23517)
Line Coverage: 28.68% (70037/244189)
Region Coverage: 27.66% (36249/131075)
Branch Coverage: 24.34% (18512/76042)
Coverage Report: http://coverage.selectdb-in.cc/coverage/ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1_ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1/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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878642036
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 c27fa771dc44a91ff3d8c9df7b0b90b10c682ff2, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5439 5114 5156 5114
q2 384 169 159 159
q3 1497 1119 1197 1119
q4 1087 817 839 817
q5 3054 3072 3150 3072
q6 218 133 133 133
q7 950 543 536 536
q8 2154 2285 2218 2218
q9 6662 6661 6656 6656
q10 3178 3193 3137 3137
q11 350 222 223 222
q12 389 228 230 228
q13 4373 3642 3605 3605
q14 253 212 214 212
q15 600 543 539 539
q16 461 395 385 385
q17 1046 516 487 487
q18 7099 6734 6792 6734
q19 1667 1540 1507 1507
q20 594 316 330 316
q21 2864 2468 2449 2449
q22 397 325 337 325
Total cold run time: 44716 ms
Total hot run time: 39970 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5149 5101 5030 5030
q2 346 232 232 232
q3 3344 3337 3315 3315
q4 2142 2038 2018 2018
q5 5946 5929 5938 5929
q6 223 125 127 125
q7 2402 1912 1936 1912
q8 3556 3658 3707 3658
q9 9051 8986 9052 8986
q10 3856 3885 3895 3885
q11 586 482 483 482
q12 804 613 624 613
q13 3930 3176 3199 3176
q14 308 278 264 264
q15 586 530 527 527
q16 532 515 528 515
q17 2031 1824 1802 1802
q18 8755 8314 8331 8314
q19 1738 1662 1721 1662
q20 2256 1986 1990 1986
q21 5688 5346 5281 5281
q22 561 477 496 477
Total cold run time: 63790 ms
Total hot run time: 60189 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880526076
TeamCity be ut coverage result:
Function Coverage: 36.66% (8637/23562)
Line Coverage: 28.65% (70173/244960)
Region Coverage: 27.60% (36287/131493)
Branch Coverage: 24.27% (18537/76366)
Coverage Report: http://coverage.selectdb-in.cc/coverage/9e9e819102cde564f0bc2b1c63e96955e2c18bfe_9e9e819102cde564f0bc2b1c63e96955e2c18bfe/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] [opt](function) change array_zip function null literal to array [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on code in PR #29534:
URL: https://github.com/apache/doris/pull/29534#discussion_r1441590944
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/FunctionCallExpr.java:
##########
@@ -1895,8 +1895,9 @@ && collectChildReturnTypes()[0].isDecimalV3()) {
// array_zip varargs special case array_zip(array1, array2, ...)
// we only specialize array_zip with first array type, next type we same with custom type
if (i >= args.length && (fnName.getFunction().equalsIgnoreCase("array_zip"))) {
- if (argTypes[i].isNull()) {
- uncheckedCastChild(args[i - 1], i);
+ if (argTypes[i].isNull()) { //select array_zip(['a', 'b', 'c'], NULL, [11, 22, 33]);
Review Comment:
Do not use the way to solve problem
--
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876806657
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 ac4a1b5ac5a01209719322d10ff88bdf1e9c06e1, data reload: false
------ Round 1 ----------------------------------
q1 17655 5143 5100 5100
q2 2030 154 138 138
q3 10535 1111 1085 1085
q4 10192 761 807 761
q5 7790 2886 2930 2886
q6 216 134 137 134
q7 886 497 539 497
q8 9311 1952 1977 1952
q9 6796 6393 6329 6329
q10 8244 3007 2999 2999
q11 429 224 208 208
q12 381 229 228 228
q13 17986 3611 3597 3597
q14 247 209 214 209
q15 563 529 513 513
q16 450 390 389 389
q17 943 489 445 445
q18 7284 6675 6635 6635
q19 1573 1382 1258 1258
q20 679 340 345 340
q21 2736 2347 2355 2347
q22 365 332 319 319
Total cold run time: 107291 ms
Total hot run time: 38369 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5118 5080 5028 5028
q2 339 234 231 231
q3 3270 3269 3227 3227
q4 2100 2009 1985 1985
q5 5781 5705 5731 5705
q6 214 126 128 126
q7 2294 1893 1913 1893
q8 3367 3413 3412 3412
q9 8717 8704 8681 8681
q10 3767 3837 3813 3813
q11 565 482 477 477
q12 805 634 615 615
q13 7813 3161 3183 3161
q14 288 268 267 267
q15 576 523 508 508
q16 549 467 490 467
q17 1954 1750 1751 1750
q18 8593 8343 8216 8216
q19 1615 1559 1572 1559
q20 2173 1954 1935 1935
q21 5566 5209 5200 5200
q22 539 482 521 482
Total cold run time: 66003 ms
Total hot run time: 58738 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1876813461
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.36 seconds
stream load tsv: 575 seconds loaded 74807831229 Bytes, about 124 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: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 27.4 seconds inserted 10000000 Rows, about 364K ops/s
storage size: 17184000806 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1878619333
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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880504243
<details>
<summary>TPC-DS: <b>Total hot run time: 183077 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 9e9e819102cde564f0bc2b1c63e96955e2c18bfe, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 930 345 332 332
query2 6508 1991 1863 1863
query3 6638 225 223 223
query4 25897 22489 22436 22436
query5 5366 573 578 573
query6 318 190 201 190
query7 4614 313 291 291
query8 253 234 212 212
query9 8764 2953 2980 2953
query10 525 319 316 316
query11 16324 15523 15564 15523
query12 155 95 92 92
query13 1673 346 352 346
query14 12661 7502 7594 7502
query15 274 254 225 225
query16 6316 333 342 333
query17 1668 513 500 500
query18 1940 310 304 304
query19 329 159 154 154
query20 109 93 105 93
query21 186 91 93 91
query22 4967 4856 4954 4856
query23 32280 31015 31418 31015
query24 11870 2930 2917 2917
query25 610 361 367 361
query26 1597 169 170 169
query27 2807 310 305 305
query28 6727 2187 2195 2187
query29 1606 393 394 393
query30 267 142 146 142
query31 1045 832 824 824
query32 116 85 82 82
query33 843 357 324 324
query34 892 450 472 450
query35 981 865 844 844
query36 1452 1259 1269 1259
query37 171 91 97 91
query38 3442 3351 3381 3351
query39 1360 1282 1303 1282
query40 287 84 83 83
query41 39 36 35 35
query42 106 104 103 103
query43 542 519 502 502
query44 1365 815 820 815
query45 207 201 207 201
query46 1064 702 720 702
query47 1759 1669 1653 1653
query48 379 283 292 283
query49 1009 303 311 303
query50 787 321 331 321
query51 5541 5274 5331 5274
query52 105 98 99 98
query53 226 166 162 162
query54 1199 663 662 662
query55 104 95 98 95
query56 272 230 245 230
query57 1036 983 983 983
query58 289 255 245 245
query59 3000 2928 2795 2795
query60 331 291 286 286
query61 145 150 142 142
query62 566 495 481 481
query63 186 175 167 167
query64 5251 1792 1717 1717
query65 3409 3351 3313 3313
query66 1223 386 359 359
query67 15590 15722 15059 15059
query68 14025 534 554 534
query69 635 322 323 322
query70 1795 1613 1545 1545
query71 590 299 312 299
query72 5435 3416 3439 3416
query73 3371 339 340 339
query74 7118 6551 6520 6520
query75 5798 2283 2260 2260
query76 6662 1022 1231 1022
query77 787 344 346 344
query78 9138 8580 8567 8567
query79 2244 526 526 526
query80 556 332 336 332
query81 469 210 213 210
query82 224 109 103 103
query83 205 140 143 140
query84 254 56 58 56
query85 884 273 261 261
query86 454 406 455 406
query87 3660 3451 3508 3451
query88 3027 2494 2496 2494
query89 385 290 300 290
query90 2098 227 223 223
query91 119 89 93 89
query92 93 85 73 73
query93 1363 442 435 435
query94 909 238 247 238
query95 593 493 498 493
query96 638 339 326 326
query97 4316 4304 4218 4218
query98 235 222 230 222
query99 1187 850 857 850
Total cold run time: 299765 ms
Total hot run time: 183077 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] [opt](function) change array_zip function null literal to array [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29534:
URL: https://github.com/apache/doris/pull/29534#issuecomment-1880493591
<details>
<summary>TPC-H: <b>Total hot run time: 38700 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 9e9e819102cde564f0bc2b1c63e96955e2c18bfe, data reload: false
------ Round 1 ----------------------------------
q1 17659 4961 4972 4961
q2 2027 160 144 144
q3 10772 1132 1135 1132
q4 10540 774 801 774
q5 7795 2967 2994 2967
q6 199 123 124 123
q7 928 516 514 514
q8 9501 2010 2019 2010
q9 6868 6373 6348 6348
q10 8260 3052 3094 3052
q11 453 225 211 211
q12 390 224 227 224
q13 18021 3386 3390 3386
q14 248 222 202 202
q15 537 509 498 498
q16 496 402 402 402
q17 965 731 584 584
q18 7332 6724 6675 6675
q19 1603 1535 1516 1516
q20 752 327 329 327
q21 2740 2449 2346 2346
q22 347 304 320 304
Total cold run time: 108433 ms
Total hot run time: 38700 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4901 4883 4881 4881
q2 340 244 233 233
q3 3292 3295 3272 3272
q4 2091 2008 2019 2008
q5 5817 5792 5795 5792
q6 208 115 115 115
q7 2322 1921 1883 1883
q8 3372 3443 3517 3443
q9 8936 8812 8911 8812
q10 3827 3836 3989 3836
q11 549 436 431 431
q12 789 636 638 636
q13 4021 3213 3176 3176
q14 292 265 259 259
q15 549 499 501 499
q16 524 484 507 484
q17 1864 1865 1846 1846
q18 8654 8474 8276 8276
q19 1584 1634 1636 1634
q20 2176 1948 1934 1934
q21 5539 5271 5211 5211
q22 519 461 469 461
Total cold run time: 62166 ms
Total hot run time: 59122 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