doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Fix](Prepared Statment) use fixed charset to init StringLiteral
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: 50070 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit cc7b190680f7aaa8914a29979e5573e83cc3ff91, data reload: false
------ Round 1 ----------------------------------
q1 17536 4390 4335 4335
q2 2068 151 149 149
q3 10276 1884 1880 1880
q4 10100 1264 1316 1264
q5 8445 3966 3954 3954
q6 235 125 128 125
q7 2078 1616 1611 1611
q8 9325 2762 2716 2716
q9 10615 11230 10483 10483
q10 8632 3560 3490 3490
q11 427 257 247 247
q12 468 300 307 300
q13 18388 3981 4055 3981
q14 355 330 320 320
q15 515 457 472 457
q16 687 563 576 563
q17 1144 995 980 980
q18 7393 6936 6770 6770
q19 1812 1657 1632 1632
q20 575 314 287 287
q21 4438 4146 4085 4085
q22 534 441 446 441
Total cold run time: 116046 ms
Total hot run time: 50070 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4332 4321 4295 4295
q2 324 231 219 219
q3 4148 4127 4132 4127
q4 2762 2747 2733 2733
q5 7166 7081 7085 7081
q6 239 120 122 120
q7 3234 2810 2830 2810
q8 4353 4434 4434 4434
q9 16914 16829 16679 16679
q10 4245 4267 4298 4267
q11 744 687 686 686
q12 1052 883 871 871
q13 6862 3761 3713 3713
q14 447 419 422 419
q15 508 450 461 450
q16 733 686 671 671
q17 3732 3772 3826 3772
q18 8951 8751 8799 8751
q19 1726 1737 1671 1671
q20 2382 2136 2064 2064
q21 8458 8437 8413 8413
q22 1077 968 968 968
Total cold run time: 84389 ms
Total hot run time: 79214 ms
TPC-DS: Total hot run time: 203429 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 cc7b190680f7aaa8914a29979e5573e83cc3ff91, data reload: false
query1 964 395 385 385
query2 6533 2661 2727 2661
query3 6918 210 201 201
query4 21554 18097 18019 18019
query5 19738 6572 6487 6487
query6 296 216 250 216
query7 4144 304 314 304
query8 475 465 395 395
query9 3092 2655 2606 2606
query10 413 289 314 289
query11 11370 10563 10704 10563
query12 125 73 78 73
query13 5609 693 687 687
query14 17597 13724 13842 13724
query15 363 266 246 246
query16 6461 286 261 261
query17 1713 1434 865 865
query18 2342 412 411 411
query19 202 153 148 148
query20 77 79 80 79
query21 190 108 96 96
query22 5241 4957 4976 4957
query23 32533 31845 31929 31845
query24 7728 6595 6486 6486
query25 524 436 424 424
query26 727 167 167 167
query27 2194 305 302 302
query28 6188 2350 2315 2315
query29 3020 2632 2742 2632
query30 248 166 167 166
query31 909 726 729 726
query32 68 60 60 60
query33 399 280 262 262
query34 842 496 486 486
query35 1103 909 927 909
query36 1321 1191 1043 1043
query37 91 61 63 61
query38 3078 2966 2998 2966
query39 1378 1339 1320 1320
query40 309 98 89 89
query41 46 48 43 43
query42 91 83 89 83
query43 784 654 698 654
query44 1145 719 735 719
query45 245 231 231 231
query46 1222 966 999 966
query47 1864 1801 1693 1693
query48 1014 703 709 703
query49 655 380 372 372
query50 855 579 654 579
query51 4771 4661 4745 4661
query52 92 82 88 82
query53 462 332 331 331
query54 2681 2441 2428 2428
query55 87 84 85 84
query56 249 226 201 201
query57 1263 1251 1028 1028
query58 224 202 204 202
query59 4231 3951 3998 3951
query60 205 201 196 196
query61 96 101 94 94
query62 817 461 507 461
query63 487 346 349 346
query64 2803 1577 1446 1446
query65 3660 3572 3594 3572
query66 789 378 376 376
query67 15787 15274 16039 15274
query68 10166 668 663 663
query69 563 355 349 349
query70 1763 1604 1425 1425
query71 415 314 316 314
query72 6307 3526 3494 3494
query73 729 329 311 311
query74 6316 5815 5834 5815
query75 5413 3617 3707 3617
query76 6353 1151 1175 1151
query77 1108 255 262 255
query78 12574 11756 11664 11664
query79 6822 636 689 636
query80 1008 419 412 412
query81 493 230 238 230
query82 1685 105 97 97
query83 172 132 133 132
query84 262 74 75 74
query85 874 318 321 318
query86 332 289 281 281
query87 3221 3034 3011 3011
query88 4543 2301 2303 2301
query89 393 273 286 273
query90 1952 218 219 218
query91 174 139 138 138
query92 59 54 56 54
query93 5434 579 558 558
query94 711 209 218 209
query95 1133 1064 1055 1055
query96 648 330 319 319
query97 6483 6386 6301 6301
query98 183 172 169 169
query99 2878 901 877 877
Total cold run time: 315869 ms
Total hot run time: 203429 ms
ClickBench: Total hot run time: 30.41 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit cc7b190680f7aaa8914a29979e5573e83cc3ff91, data reload: false
query1 0.02 0.02 0.01
query2 0.07 0.02 0.02
query3 0.24 0.04 0.04
query4 1.79 0.07 0.07
query5 0.54 0.52 0.51
query6 1.29 0.62 0.60
query7 0.01 0.01 0.02
query8 0.03 0.02 0.02
query9 0.53 0.49 0.48
query10 0.53 0.54 0.54
query11 0.12 0.09 0.08
query12 0.11 0.09 0.10
query13 0.62 0.61 0.61
query14 0.78 0.79 0.80
query15 0.79 0.75 0.74
query16 0.36 0.39 0.36
query17 0.99 1.02 1.01
query18 0.22 0.27 0.25
query19 1.91 1.76 1.83
query20 0.01 0.00 0.00
query21 15.49 0.56 0.56
query22 2.20 2.36 1.68
query23 17.17 1.09 0.96
query24 6.29 0.82 1.31
query25 0.40 0.12 0.05
query26 0.69 0.15 0.14
query27 0.04 0.03 0.04
query28 6.74 0.72 0.70
query29 12.78 2.30 2.20
query30 0.53 0.54 0.46
query31 2.81 0.38 0.39
query32 3.38 0.50 0.49
query33 3.04 3.10 3.06
query34 15.27 4.81 4.79
query35 4.88 4.85 4.85
query36 1.05 1.01 1.02
query37 0.06 0.04 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.15 0.14 0.14
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.02 0.01 0.01
Total cold run time: 104.1 s
Total hot run time: 30.41 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit cc7b190680f7aaa8914a29979e5573e83cc3ff91 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.1 seconds inserted 10000000 Rows, about 473K ops/s