doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[fix](nereids)the nullableFromNereids flag is lost during Expr's clone method
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: 41849 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 191ef6cad88f305617a56233f962a95dbfd25c49, data reload: false
------ Round 1 ----------------------------------
q1 17818 7500 7363 7363
q2 2014 294 279 279
q3 12265 1075 1212 1075
q4 10582 828 885 828
q5 7776 3135 3125 3125
q6 238 153 151 151
q7 1049 612 635 612
q8 10450 1993 1987 1987
q9 6689 6553 6555 6553
q10 7215 2470 2507 2470
q11 456 252 253 252
q12 424 227 228 227
q13 18797 3113 3041 3041
q14 251 220 241 220
q15 579 546 559 546
q16 917 581 607 581
q17 1221 503 519 503
q18 8758 6703 6933 6703
q19 1360 936 989 936
q20 480 189 190 189
q21 4036 3182 3203 3182
q22 1140 1026 1060 1026
Total cold run time: 114515 ms
Total hot run time: 41849 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7324 7287 7437 7287
q2 334 239 230 230
q3 3200 3083 3009 3009
q4 2072 1816 1811 1811
q5 5774 5839 5944 5839
q6 232 149 147 147
q7 2286 1892 1788 1788
q8 3397 3630 3604 3604
q9 9242 9234 9205 9205
q10 3742 3701 3650 3650
q11 604 504 506 504
q12 854 706 652 652
q13 15353 3230 3234 3230
q14 301 280 292 280
q15 584 512 530 512
q16 687 652 672 652
q17 1888 1642 1624 1624
q18 8360 7678 7969 7678
q19 1725 1544 1373 1373
q20 2147 1878 1882 1878
q21 5784 5497 5466 5466
q22 1169 1088 1072 1072
Total cold run time: 77059 ms
Total hot run time: 61491 ms
TPC-DS: Total hot run time: 192646 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 191ef6cad88f305617a56233f962a95dbfd25c49, data reload: false
query1 818 387 405 387
query2 6248 2081 2093 2081
query3 8682 193 208 193
query4 34431 23584 23635 23584
query5 4108 490 459 459
query6 267 163 161 161
query7 4183 298 290 290
query8 290 223 218 218
query9 9398 2722 2727 2722
query10 471 276 263 263
query11 18160 15243 15145 15145
query12 147 100 99 99
query13 1558 420 399 399
query14 9229 7486 7548 7486
query15 270 173 194 173
query16 8010 509 450 450
query17 1648 583 581 581
query18 2101 313 314 313
query19 371 155 155 155
query20 130 111 131 111
query21 211 113 113 113
query22 5072 4838 4666 4666
query23 35094 34255 34218 34218
query24 10547 2767 2743 2743
query25 582 426 421 421
query26 731 155 159 155
query27 2022 282 293 282
query28 6522 2453 2442 2442
query29 755 417 433 417
query30 242 157 152 152
query31 1028 803 814 803
query32 105 56 56 56
query33 677 308 293 293
query34 910 515 520 515
query35 905 743 753 743
query36 1093 935 962 935
query37 145 89 89 89
query38 4068 3921 3906 3906
query39 1500 1429 1437 1429
query40 206 100 99 99
query41 47 47 46 46
query42 118 107 98 98
query43 532 510 495 495
query44 1153 814 800 800
query45 198 166 165 165
query46 1138 723 706 706
query47 1995 1870 1863 1863
query48 419 319 326 319
query49 879 437 434 434
query50 798 399 395 395
query51 7167 7016 7037 7016
query52 103 90 90 90
query53 251 187 179 179
query54 1285 445 459 445
query55 81 76 75 75
query56 279 252 248 248
query57 1322 1167 1168 1167
query58 234 240 231 231
query59 3315 3055 2999 2999
query60 287 257 265 257
query61 105 98 102 98
query62 844 684 663 663
query63 220 189 180 180
query64 3631 639 615 615
query65 3273 3184 3198 3184
query66 750 303 309 303
query67 16005 15876 15703 15703
query68 4441 570 556 556
query69 535 292 287 287
query70 1151 1114 1089 1089
query71 394 267 281 267
query72 7695 3924 3921 3921
query73 785 363 361 361
query74 10383 9032 8928 8928
query75 3863 2662 2686 2662
query76 3138 928 906 906
query77 598 300 304 300
query78 10590 9641 9747 9641
query79 2118 584 598 584
query80 1178 436 447 436
query81 577 248 241 241
query82 688 136 141 136
query83 300 136 136 136
query84 278 69 74 69
query85 1304 298 286 286
query86 420 298 302 298
query87 4517 4315 4249 4249
query88 2990 2245 2188 2188
query89 408 289 291 289
query90 1922 186 186 186
query91 138 104 101 101
query92 60 49 48 48
query93 2495 538 531 531
query94 905 298 280 280
query95 340 246 250 246
query96 625 283 281 281
query97 3287 3192 3135 3135
query98 223 202 192 192
query99 1616 1315 1295 1295
Total cold run time: 299326 ms
Total hot run time: 192646 ms
ClickBench: Total hot run time: 33.85 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 191ef6cad88f305617a56233f962a95dbfd25c49, data reload: false
query1 0.03 0.03 0.02
query2 0.06 0.03 0.03
query3 0.22 0.07 0.07
query4 1.63 0.10 0.10
query5 0.52 0.49 0.50
query6 1.13 0.75 0.73
query7 0.02 0.02 0.02
query8 0.04 0.02 0.04
query9 0.56 0.50 0.49
query10 0.54 0.55 0.54
query11 0.14 0.10 0.10
query12 0.13 0.11 0.12
query13 0.61 0.60 0.60
query14 2.71 2.76 2.73
query15 0.89 0.83 0.84
query16 0.38 0.39 0.38
query17 1.01 1.00 1.00
query18 0.20 0.19 0.19
query19 1.95 1.81 2.00
query20 0.01 0.01 0.01
query21 15.36 0.58 0.57
query22 2.70 2.60 2.43
query23 16.87 1.21 0.82
query24 3.33 1.46 1.47
query25 0.14 0.13 0.22
query26 0.50 0.16 0.13
query27 0.03 0.04 0.03
query28 9.66 1.09 1.06
query29 12.62 3.25 3.19
query30 0.26 0.06 0.06
query31 2.87 0.38 0.38
query32 3.26 0.46 0.45
query33 2.99 3.07 3.05
query34 17.05 4.48 4.52
query35 4.57 4.57 4.57
query36 0.67 0.47 0.49
query37 0.09 0.06 0.06
query38 0.04 0.03 0.03
query39 0.03 0.03 0.02
query40 0.16 0.12 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 106.13 s
Total hot run time: 33.85 s
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!
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}