doris
doris copied to clipboard
apache
[Update](clucene) update clucene 2.0 commit version
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: 49556 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 20734f18d156d7290fe603bc984de6e843795f0c, data reload: false
------ Round 1 ----------------------------------
q1 17869 4396 4367 4367
q2 2029 150 147 147
q3 10485 1911 1921 1911
q4 10358 1251 1330 1251
q5 8499 3900 3930 3900
q6 237 123 129 123
q7 2016 1613 1586 1586
q8 9281 2728 2700 2700
q9 10662 10215 10266 10215
q10 8681 3444 3507 3444
q11 428 234 235 234
q12 469 304 301 301
q13 18347 3952 3984 3952
q14 351 329 332 329
q15 512 460 459 459
q16 672 563 560 560
q17 1134 928 941 928
q18 7287 6924 6788 6788
q19 1711 1591 1551 1551
q20 554 312 301 301
q21 4440 4130 4117 4117
q22 496 392 393 392
Total cold run time: 116518 ms
Total hot run time: 49556 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4283 4353 4267 4267
q2 317 228 216 216
q3 4184 4114 4144 4114
q4 2750 2746 2742 2742
q5 7186 7144 7083 7083
q6 237 121 121 121
q7 3234 2791 2854 2791
q8 4353 4471 4460 4460
q9 16811 16748 16740 16740
q10 4224 4262 4261 4261
q11 771 671 665 665
q12 1019 853 861 853
q13 7181 3776 3751 3751
q14 439 431 423 423
q15 504 460 456 456
q16 741 682 691 682
q17 3801 3900 3870 3870
q18 8755 8638 8819 8638
q19 1696 1702 1682 1682
q20 2398 2160 2118 2118
q21 8482 8445 8462 8445
q22 1005 1019 921 921
Total cold run time: 84371 ms
Total hot run time: 79299 ms
TeamCity be ut coverage result: Function Coverage: 37.80% (8078/21369) Line Coverage: 29.46% (65956/223905) Region Coverage: 28.93% (33959/117388) Branch Coverage: 24.78% (17424/70316) Coverage Report: http://coverage.selectdb-in.cc/coverage/20734f18d156d7290fe603bc984de6e843795f0c_20734f18d156d7290fe603bc984de6e843795f0c/report/index.html
TPC-DS: Total hot run time: 202606 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 20734f18d156d7290fe603bc984de6e843795f0c, data reload: false
query1 931 389 381 381
query2 6558 2777 2611 2611
query3 6921 208 205 205
query4 20745 17969 18075 17969
query5 19731 6494 6549 6494
query6 284 225 217 217
query7 4164 303 317 303
query8 275 238 243 238
query9 3134 2697 2628 2628
query10 404 305 299 299
query11 11329 10860 10690 10690
query12 121 78 73 73
query13 5582 672 672 672
query14 17733 13349 12979 12979
query15 366 211 233 211
query16 6471 271 255 255
query17 1732 1459 871 871
query18 2320 416 409 409
query19 220 146 150 146
query20 80 77 81 77
query21 197 88 95 88
query22 5264 4953 5071 4953
query23 32455 31800 31892 31800
query24 6943 6509 6536 6509
query25 516 426 422 422
query26 518 161 160 160
query27 1893 298 296 296
query28 6216 2343 2305 2305
query29 2932 2644 2874 2644
query30 246 162 161 161
query31 918 780 726 726
query32 70 58 60 58
query33 382 258 257 257
query34 843 482 485 482
query35 1093 930 951 930
query36 1536 1221 1204 1204
query37 87 60 60 60
query38 3056 2941 2982 2941
query39 1385 1318 1315 1315
query40 205 94 99 94
query41 43 35 38 35
query42 89 87 78 78
query43 720 650 727 650
query44 1122 717 712 712
query45 237 230 227 227
query46 1229 945 975 945
query47 1913 1670 1967 1670
query48 1015 712 705 705
query49 614 370 378 370
query50 854 601 610 601
query51 4771 4624 4617 4617
query52 91 87 86 86
query53 444 322 327 322
query54 2660 2474 2455 2455
query55 98 75 82 75
query56 230 209 225 209
query57 1102 1147 1121 1121
query58 216 195 194 194
query59 4153 3826 3959 3826
query60 228 192 199 192
query61 85 81 83 81
query62 813 451 496 451
query63 481 339 338 338
query64 2536 1508 1430 1430
query65 3650 3537 3546 3537
query66 783 370 361 361
query67 15708 15372 15280 15280
query68 6818 635 644 635
query69 561 356 342 342
query70 1507 1561 1422 1422
query71 409 312 320 312
query72 6444 3472 3405 3405
query73 738 325 327 325
query74 6330 5931 5847 5847
query75 4641 3809 3730 3730
query76 4382 1177 1133 1133
query77 541 249 270 249
query78 12586 11828 11836 11828
query79 7654 654 653 653
query80 1656 395 388 388
query81 512 234 236 234
query82 1516 100 96 96
query83 171 136 136 136
query84 253 66 69 66
query85 1273 299 293 293
query86 340 294 294 294
query87 3260 2974 2985 2974
query88 5093 2362 2371 2362
query89 379 287 292 287
query90 1807 215 212 212
query91 176 134 135 134
query92 59 54 52 52
query93 3593 608 601 601
query94 851 204 204 204
query95 1093 1063 1040 1040
query96 639 335 333 333
query97 6499 6312 6402 6312
query98 182 172 176 172
query99 2938 924 834 834
Total cold run time: 306642 ms
Total hot run time: 202606 ms
ClickBench: Total hot run time: 30.79 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 20734f18d156d7290fe603bc984de6e843795f0c, data reload: false
query1 0.02 0.02 0.02
query2 0.07 0.03 0.02
query3 0.25 0.05 0.04
query4 1.80 0.07 0.06
query5 0.53 0.54 0.52
query6 1.24 0.60 0.61
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.52 0.48 0.48
query10 0.54 0.53 0.54
query11 0.11 0.09 0.08
query12 0.11 0.09 0.09
query13 0.62 0.62 0.61
query14 0.79 0.79 0.79
query15 0.79 0.75 0.76
query16 0.36 0.39 0.36
query17 1.02 0.98 1.01
query18 0.22 0.26 0.24
query19 1.91 1.86 1.80
query20 0.01 0.02 0.01
query21 15.51 0.56 0.56
query22 1.96 1.93 1.64
query23 16.77 1.08 0.97
query24 6.95 0.87 1.30
query25 0.36 0.09 0.07
query26 0.78 0.14 0.15
query27 0.03 0.04 0.05
query28 6.04 0.75 0.77
query29 12.69 2.46 2.43
query30 0.60 0.53 0.53
query31 2.81 0.40 0.37
query32 3.37 0.50 0.49
query33 3.08 3.04 3.06
query34 15.26 4.81 4.79
query35 4.86 4.84 4.86
query36 1.06 1.02 1.01
query37 0.06 0.04 0.04
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.13 0.14
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 103.48 s
Total hot run time: 30.79 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 20734f18d156d7290fe603bc984de6e843795f0c 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: 21.2 seconds inserted 10000000 Rows, about 471K ops/s