doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[fix](Nereids) some special expression should not be constant
pick from master #30305 commit id cd6a6c0de2e6a515c8b373bbdd7113edc27634d5
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
TPC-H: Total hot run time: 49657 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f1f518ab50238d1c8438f4543ed2965bb78f4e7a, data reload: false
------ Round 1 ----------------------------------
q1 17700 4345 4303 4303
q2 2034 151 139 139
q3 10436 1831 1885 1831
q4 10339 1258 1313 1258
q5 8418 3885 3943 3885
q6 230 122 121 121
q7 2012 1583 1583 1583
q8 9513 2697 2699 2697
q9 11703 10466 10333 10333
q10 8648 3497 3516 3497
q11 413 234 235 234
q12 458 306 300 300
q13 18329 3961 4063 3961
q14 354 321 334 321
q15 520 455 453 453
q16 672 595 590 590
q17 1146 963 957 957
q18 7295 6916 6976 6916
q19 1668 1567 1494 1494
q20 540 303 298 298
q21 4447 4086 4095 4086
q22 512 400 426 400
Total cold run time: 117387 ms
Total hot run time: 49657 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4312 4326 4336 4326
q2 320 220 235 220
q3 4203 4176 4146 4146
q4 2791 2760 2768 2760
q5 7348 7249 7274 7249
q6 235 120 116 116
q7 3252 2792 2885 2792
q8 4501 4651 4632 4632
q9 17356 17222 17039 17039
q10 4243 4271 4300 4271
q11 793 682 682 682
q12 1026 853 842 842
q13 7205 3778 3736 3736
q14 453 419 428 419
q15 491 465 460 460
q16 758 698 711 698
q17 3905 3883 3929 3883
q18 8686 8855 8671 8671
q19 1682 1683 1599 1599
q20 2359 2146 2149 2146
q21 8490 8440 8459 8440
q22 1048 997 947 947
Total cold run time: 85457 ms
Total hot run time: 80074 ms
TPC-DS: Total hot run time: 202067 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 f1f518ab50238d1c8438f4543ed2965bb78f4e7a, data reload: false
query1 915 384 383 383
query2 6537 2161 2000 2000
query3 6922 192 197 192
query4 20437 18477 18228 18228
query5 19716 6506 6516 6506
query6 284 214 233 214
query7 4151 290 296 290
query8 255 254 242 242
query9 3081 2652 2596 2596
query10 424 277 305 277
query11 11282 10775 10806 10775
query12 124 70 72 70
query13 5574 651 612 612
query14 17786 13642 13592 13592
query15 367 238 232 232
query16 6450 263 254 254
query17 1762 1466 877 877
query18 2303 411 409 409
query19 200 143 153 143
query20 73 84 84 84
query21 192 91 91 91
query22 5388 5232 5015 5015
query23 32578 31994 31858 31858
query24 6853 6599 6445 6445
query25 508 420 420 420
query26 520 161 153 153
query27 1855 296 290 290
query28 6059 2198 2140 2140
query29 2848 2694 2715 2694
query30 236 161 160 160
query31 912 762 743 743
query32 66 61 55 55
query33 379 238 249 238
query34 832 483 474 474
query35 1111 901 934 901
query36 1527 1365 1543 1365
query37 89 57 57 57
query38 3110 2952 2907 2907
query39 1370 1310 1324 1310
query40 191 94 98 94
query41 35 34 32 32
query42 94 81 81 81
query43 637 603 662 603
query44 1111 710 709 709
query45 240 223 228 223
query46 1233 977 967 967
query47 1746 1704 1969 1704
query48 958 665 648 648
query49 617 359 358 358
query50 876 601 586 586
query51 4742 4672 4663 4663
query52 91 92 86 86
query53 440 322 314 314
query54 2605 2459 2435 2435
query55 85 91 79 79
query56 221 210 184 184
query57 1278 1154 1098 1098
query58 204 196 186 186
query59 3428 3188 3232 3188
query60 213 192 195 192
query61 82 86 83 83
query62 814 626 497 497
query63 469 329 332 329
query64 2545 1498 1356 1356
query65 3649 3565 3568 3565
query66 758 372 352 352
query67 15832 15638 15480 15480
query68 8875 663 660 660
query69 563 343 330 330
query70 2146 1653 1691 1653
query71 410 293 314 293
query72 6528 3408 3386 3386
query73 716 305 316 305
query74 6322 5940 5863 5863
query75 5337 3622 3665 3622
query76 5464 1178 1185 1178
query77 903 248 239 239
query78 12463 11564 11548 11548
query79 8630 636 642 636
query80 1295 396 375 375
query81 480 234 233 233
query82 1743 100 100 100
query83 172 130 129 129
query84 258 69 68 68
query85 851 276 285 276
query86 415 378 381 378
query87 3298 3008 3004 3004
query88 5018 2313 2283 2283
query89 380 288 286 286
query90 1946 212 212 212
query91 147 114 113 113
query92 58 50 48 48
query93 5730 570 579 570
query94 688 206 211 206
query95 1102 1079 1038 1038
query96 631 319 329 319
query97 6409 6323 6383 6323
query98 213 171 160 160
query99 3064 849 935 849
Total cold run time: 312525 ms
Total hot run time: 202067 ms
ClickBench: Total hot run time: 30.52 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f1f518ab50238d1c8438f4543ed2965bb78f4e7a, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.23 0.04 0.04
query4 1.84 0.06 0.06
query5 0.53 0.52 0.52
query6 1.25 0.68 0.62
query7 0.02 0.02 0.02
query8 0.03 0.02 0.02
query9 0.53 0.47 0.48
query10 0.54 0.54 0.52
query11 0.12 0.09 0.09
query12 0.11 0.09 0.09
query13 0.63 0.61 0.62
query14 0.79 0.78 0.80
query15 0.78 0.76 0.75
query16 0.38 0.36 0.36
query17 1.03 1.04 1.02
query18 0.22 0.27 0.23
query19 1.84 1.88 1.85
query20 0.01 0.01 0.00
query21 15.49 0.57 0.54
query22 1.62 2.00 1.23
query23 16.92 1.04 0.92
query24 5.05 1.06 1.32
query25 1.56 0.13 0.12
query26 0.25 0.14 0.15
query27 0.10 0.11 0.11
query28 7.57 0.72 0.73
query29 12.65 2.29 2.27
query30 0.62 0.53 0.52
query31 2.81 0.39 0.38
query32 3.41 0.49 0.49
query33 3.05 3.07 3.07
query34 15.26 4.78 4.79
query35 4.88 4.82 4.87
query36 1.05 1.02 1.03
query37 0.06 0.04 0.05
query38 0.04 0.02 0.02
query39 0.01 0.01 0.01
query40 0.15 0.14 0.14
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.02 0.01 0.02
Total cold run time: 103.62 s
Total hot run time: 30.52 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit f1f518ab50238d1c8438f4543ed2965bb78f4e7a with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.2 seconds inserted 10000000 Rows, about 471K ops/s