doris
doris copied to clipboard
apache
[test](data type)
Proposed changes
Issue Number: close #xxx
Further comments
If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
TPC-H: Total hot run time: 39861 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 53f1725753023b11ff03b9db4243c0ac6e5888a9, data reload: false
------ Round 1 ----------------------------------
q1 17617 4394 4286 4286
q2 2021 190 191 190
q3 10428 1217 1164 1164
q4 10206 779 863 779
q5 7518 2701 2666 2666
q6 216 134 138 134
q7 1025 600 586 586
q8 9223 2051 2021 2021
q9 8957 6616 6532 6532
q10 8650 3779 3730 3730
q11 449 231 244 231
q12 499 222 218 218
q13 17775 3000 2969 2969
q14 266 238 231 231
q15 516 478 472 472
q16 531 380 380 380
q17 944 677 674 674
q18 8061 7330 7352 7330
q19 5095 1491 1516 1491
q20 635 299 306 299
q21 4925 3214 3999 3214
q22 321 264 274 264
Total cold run time: 115878 ms
Total hot run time: 39861 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4366 4258 4227 4227
q2 374 257 269 257
q3 2971 2729 2746 2729
q4 1863 1629 1593 1593
q5 5287 5274 5342 5274
q6 208 125 132 125
q7 2256 1844 1840 1840
q8 3175 3339 3349 3339
q9 8561 8568 8898 8568
q10 4158 3888 3907 3888
q11 609 514 507 507
q12 785 651 658 651
q13 16140 3222 3160 3160
q14 313 270 288 270
q15 528 493 493 493
q16 529 463 452 452
q17 1819 1515 1502 1502
q18 7971 7817 7772 7772
q19 1658 1539 1623 1539
q20 2079 1868 1866 1866
q21 5233 4896 5003 4896
q22 559 488 482 482
Total cold run time: 71442 ms
Total hot run time: 55430 ms
TPC-DS: Total hot run time: 187107 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 53f1725753023b11ff03b9db4243c0ac6e5888a9, data reload: false
query1 893 362 356 356
query2 6177 2562 2323 2323
query3 6646 199 193 193
query4 23933 21541 21421 21421
query5 4173 408 412 408
query6 284 185 193 185
query7 4580 304 280 280
query8 240 186 184 184
query9 8507 2328 2330 2328
query10 417 240 243 240
query11 14786 14243 14249 14243
query12 136 87 83 83
query13 1629 365 357 357
query14 9619 6866 7630 6866
query15 258 181 189 181
query16 8176 265 257 257
query17 1930 566 562 562
query18 2076 288 273 273
query19 195 150 152 150
query20 93 83 88 83
query21 199 127 124 124
query22 5003 4773 4777 4773
query23 33653 33262 33252 33252
query24 9324 3073 3091 3073
query25 621 400 405 400
query26 705 171 168 168
query27 2376 382 372 372
query28 6142 2068 2078 2068
query29 896 626 637 626
query30 276 166 160 160
query31 1052 756 762 756
query32 94 53 57 53
query33 651 318 243 243
query34 897 480 485 480
query35 810 711 701 701
query36 1084 901 935 901
query37 111 65 66 65
query38 3472 3341 3288 3288
query39 1649 1601 1577 1577
query40 177 127 126 126
query41 41 38 38 38
query42 103 98 97 97
query43 562 539 537 537
query44 1092 746 751 746
query45 300 265 277 265
query46 1114 758 750 750
query47 2027 1913 1935 1913
query48 374 316 300 300
query49 832 407 395 395
query50 784 390 387 387
query51 6923 6902 6914 6902
query52 100 83 87 83
query53 335 274 272 272
query54 301 226 239 226
query55 76 68 73 68
query56 234 217 215 215
query57 1228 1183 1131 1131
query58 216 231 195 195
query59 3394 3142 3169 3142
query60 255 222 232 222
query61 86 88 88 88
query62 577 445 423 423
query63 296 277 275 275
query64 8126 7186 7138 7138
query65 3094 3034 3006 3006
query66 748 325 332 325
query67 15521 15008 14921 14921
query68 9145 534 546 534
query69 548 301 305 301
query70 1416 1110 1034 1034
query71 465 267 266 266
query72 8364 2613 2450 2450
query73 1617 316 316 316
query74 6946 6383 6388 6383
query75 4031 2651 2657 2651
query76 4870 1033 903 903
query77 656 260 307 260
query78 10862 10197 10285 10197
query79 9330 529 524 524
query80 1627 428 430 428
query81 502 224 222 222
query82 237 98 98 98
query83 203 163 160 160
query84 262 90 83 83
query85 847 264 261 261
query86 331 301 296 296
query87 3497 3299 3264 3264
query88 4783 2326 2319 2319
query89 506 371 377 371
query90 1864 184 181 181
query91 126 155 93 93
query92 56 45 45 45
query93 5922 502 503 502
query94 1158 178 179 178
query95 392 302 301 301
query96 608 260 258 258
query97 3152 2951 2939 2939
query98 236 209 217 209
query99 1166 862 841 841
Total cold run time: 298404 ms
Total hot run time: 187107 ms
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TeamCity be ut coverage result: Function Coverage: 35.64% (8970/25168) Line Coverage: 27.29% (74032/271250) Region Coverage: 26.52% (38235/144188) Branch Coverage: 23.32% (19491/83574) Coverage Report: http://coverage.selectdb-in.cc/coverage/773016b70527057f9499909a9a0bbc82252e06ac_773016b70527057f9499909a9a0bbc82252e06ac/report/index.html
TPC-DS: Total hot run time: 184057 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 773016b70527057f9499909a9a0bbc82252e06ac, data reload: false
query1 934 362 348 348
query2 6384 2363 2425 2363
query3 6660 206 209 206
query4 23984 21785 21911 21785
query5 3844 439 434 434
query6 272 207 187 187
query7 4544 306 307 306
query8 251 199 205 199
query9 8641 2439 2445 2439
query10 417 253 242 242
query11 11745 11161 11486 11161
query12 119 87 91 87
query13 1684 380 361 361
query14 10653 8537 7474 7474
query15 268 166 178 166
query16 8219 256 255 255
query17 1782 554 544 544
query18 2121 276 260 260
query19 314 147 149 147
query20 89 85 85 85
query21 191 123 124 123
query22 5032 4820 4885 4820
query23 33633 33334 33381 33334
query24 10718 2910 2906 2906
query25 593 370 355 355
query26 1320 152 147 147
query27 2863 318 312 312
query28 7651 2037 2024 2024
query29 856 599 610 599
query30 255 157 156 156
query31 959 728 736 728
query32 92 56 52 52
query33 741 236 248 236
query34 1028 473 469 469
query35 816 659 661 659
query36 1035 912 880 880
query37 132 63 66 63
query38 3163 3088 3004 3004
query39 1587 1636 1561 1561
query40 199 129 134 129
query41 42 39 41 39
query42 106 97 97 97
query43 586 529 549 529
query44 1264 729 743 729
query45 262 247 243 243
query46 1069 730 752 730
query47 1955 1873 1841 1841
query48 377 299 304 299
query49 856 384 390 384
query50 760 377 393 377
query51 6836 6725 6668 6668
query52 108 91 95 91
query53 347 280 286 280
query54 302 235 240 235
query55 81 71 72 71
query56 250 223 243 223
query57 1240 1146 1139 1139
query58 218 200 199 199
query59 3298 3117 3183 3117
query60 266 235 235 235
query61 87 83 85 83
query62 646 449 447 447
query63 312 283 280 280
query64 8630 7257 7251 7251
query65 3108 3067 3052 3052
query66 1356 355 350 350
query67 15486 15141 14862 14862
query68 5098 531 539 531
query69 482 312 312 312
query70 1128 1147 1115 1115
query71 430 277 279 277
query72 7765 2687 2475 2475
query73 709 321 320 320
query74 6596 6106 6014 6014
query75 3461 2658 2630 2630
query76 3246 975 975 975
query77 392 281 281 281
query78 11221 10211 10320 10211
query79 9269 521 528 521
query80 2245 456 457 456
query81 570 228 225 225
query82 1207 98 94 94
query83 320 170 167 167
query84 267 187 82 82
query85 1923 280 271 271
query86 478 304 314 304
query87 3263 3073 3039 3039
query88 5190 2329 2333 2329
query89 580 370 376 370
query90 2015 190 186 186
query91 131 98 99 98
query92 60 48 47 47
query93 7098 491 502 491
query94 1209 183 184 183
query95 386 298 298 298
query96 611 267 263 263
query97 3186 2999 2938 2938
query98 238 221 217 217
query99 1301 880 894 880
Total cold run time: 297712 ms
Total hot run time: 184057 ms
PR approved by at least one committer and no changes requested.
TeamCity be ut coverage result: Function Coverage: 35.70% (8986/25174) Line Coverage: 27.34% (74217/271415) Region Coverage: 26.59% (38362/144290) Branch Coverage: 23.38% (19556/83640) Coverage Report: http://coverage.selectdb-in.cc/coverage/773016b70527057f9499909a9a0bbc82252e06ac_773016b70527057f9499909a9a0bbc82252e06ac/report/index.html