doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Fix](Status) Handle returned Status correctly
Proposed changes
Issue Number: #28160
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
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In build.sh line 285:
local submodule_path=$1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 286:
local submodule_name=$2
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 287:
local archive_url=$3
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 289:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 290:
cd "${DORIS_HOME}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 291:
echo "Update ${submodule_name} submodule ..."
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 292:
git submodule update --init --recursive "${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 293:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 294:
if [[ "${exit_code}" -eq 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 295:
cd "${submodule_path}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 296:
submodule_commit_id=$(git rev-parse HEAD)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 297:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 298:
expect_submodule_commit_id=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 299:
echo "Current commit ID of ${submodule_name} submodule: ${submodule_commit_id}, expected is ${expect_submodule_commit_id}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 301:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 302:
if [[ "${exit_code}" -ne 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 303:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 305:
submodule_commit=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 306:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 307:
if [[ "${exit_code}" = "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 308:
commit_specific_url=$(echo "${archive_url}" | sed "s/refs\/heads/${submodule_commit}/")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 310:
commit_specific_url="${archive_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 312:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 313:
echo "Update ${submodule_name} submodule failed, start to download and extract ${commit_specific_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 315:
mkdir -p "${DORIS_HOME}/${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 316:
curl -L "${commit_specific_url}" | tar -xz -C "${DORIS_HOME}/${submodule_path}" --strip-components=1
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In build.sh line 285:
local submodule_path=$1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 286:
local submodule_name=$2
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 287:
local archive_url=$3
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 289:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 290:
cd "${DORIS_HOME}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 291:
echo "Update ${submodule_name} submodule ..."
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 292:
git submodule update --init --recursive "${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 293:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 294:
if [[ "${exit_code}" -eq 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 295:
cd "${submodule_path}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 296:
submodule_commit_id=$(git rev-parse HEAD)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 297:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 298:
expect_submodule_commit_id=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 299:
echo "Current commit ID of ${submodule_name} submodule: ${submodule_commit_id}, expected is ${expect_submodule_commit_id}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 301:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 302:
if [[ "${exit_code}" -ne 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 303:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 305:
submodule_commit=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 306:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 307:
if [[ "${exit_code}" = "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 308:
commit_specific_url=$(echo "${archive_url}" | sed "s/refs\/heads/${submodule_commit}/")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 310:
commit_specific_url="${archive_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 312:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 313:
echo "Update ${submodule_name} submodule failed, start to download and extract ${commit_specific_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 315:
mkdir -p "${DORIS_HOME}/${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 316:
curl -L "${commit_specific_url}" | tar -xz -C "${DORIS_HOME}/${submodule_path}" --strip-components=1
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In build.sh line 285:
local submodule_path=$1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 286:
local submodule_name=$2
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 287:
local archive_url=$3
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 289:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 290:
cd "${DORIS_HOME}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 291:
echo "Update ${submodule_name} submodule ..."
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 292:
git submodule update --init --recursive "${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 293:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 294:
if [[ "${exit_code}" -eq 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 295:
cd "${submodule_path}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 296:
submodule_commit_id=$(git rev-parse HEAD)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 297:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 298:
expect_submodule_commit_id=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 299:
echo "Current commit ID of ${submodule_name} submodule: ${submodule_commit_id}, expected is ${expect_submodule_commit_id}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 301:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 302:
if [[ "${exit_code}" -ne 0 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 303:
set +e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 305:
submodule_commit=$(git ls-tree HEAD "${submodule_path}" | awk '{print $3}')
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 306:
exit_code=$?
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 307:
if [[ "${exit_code}" = "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 308:
commit_specific_url=$(echo "${archive_url}" | sed "s/refs\/heads/${submodule_commit}/")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 310:
commit_specific_url="${archive_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 312:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 313:
echo "Update ${submodule_name} submodule failed, start to download and extract ${commit_specific_url}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 315:
mkdir -p "${DORIS_HOME}/${submodule_path}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In build.sh line 316:
curl -L "${commit_specific_url}" | tar -xz -C "${DORIS_HOME}/${submodule_path}" --strip-components=1
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.
TPC-H: Total hot run time: 41120 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 19a166a50c07f95d4dc562aed63398a500dac294, data reload: false
------ Round 1 ----------------------------------
q1 17723 4963 4851 4851
q2 2038 140 135 135
q3 10580 989 982 982
q4 4652 981 974 974
q5 7616 3164 3203 3164
q6 204 133 132 132
q7 1253 790 766 766
q8 9243 2084 2068 2068
q9 7482 6626 6619 6619
q10 8316 2650 2643 2643
q11 410 222 215 215
q12 756 325 331 325
q13 17915 3650 3589 3589
q14 284 256 265 256
q15 626 508 505 505
q16 473 426 410 410
q17 930 850 816 816
q18 7504 6661 6805 6661
q19 1532 1500 1500 1500
q20 549 276 274 274
q21 6583 3905 3979 3905
q22 866 349 330 330
Total cold run time: 107535 ms
Total hot run time: 41120 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4821 4817 4806 4806
q2 293 190 185 185
q3 3600 3590 3577 3577
q4 2545 2542 2530 2530
q5 5778 5728 5780 5728
q6 209 126 124 124
q7 2245 1690 1649 1649
q8 3037 3081 3124 3081
q9 8787 8696 8718 8696
q10 6786 4257 4237 4237
q11 516 361 373 361
q12 773 555 562 555
q13 4290 3394 3420 3394
q14 266 263 240 240
q15 637 533 503 503
q16 496 447 431 431
q17 1691 1612 1623 1612
q18 8408 7798 7681 7681
q19 1640 1645 1639 1639
q20 2124 1833 1842 1833
q21 6562 6183 6190 6183
q22 570 508 498 498
Total cold run time: 66074 ms
Total hot run time: 59543 ms
TPC-DS: Total hot run time: 176758 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 19a166a50c07f95d4dc562aed63398a500dac294, data reload: false
query1 934 343 354 343
query2 6525 1822 1736 1736
query3 6693 208 209 208
query4 23043 21177 21078 21078
query5 4255 375 367 367
query6 258 169 166 166
query7 4595 294 291 291
query8 244 196 217 196
query9 8437 2751 2742 2742
query10 408 230 219 219
query11 15037 14630 14622 14622
query12 150 81 85 81
query13 1691 410 419 410
query14 9338 7684 7631 7631
query15 212 188 191 188
query16 7639 257 242 242
query17 1453 534 508 508
query18 1942 261 260 260
query19 188 146 144 144
query20 85 84 81 81
query21 189 120 123 120
query22 4847 4841 4708 4708
query23 32482 31475 31566 31475
query24 12501 3413 3405 3405
query25 640 365 356 356
query26 1847 151 168 151
query27 3051 326 311 311
query28 6616 1832 1811 1811
query29 1104 606 603 603
query30 278 137 148 137
query31 927 753 761 753
query32 98 57 64 57
query33 726 232 226 226
query34 1076 486 491 486
query35 927 830 827 827
query36 1012 878 890 878
query37 163 61 62 61
query38 3285 3166 3160 3160
query39 1379 1323 1323 1323
query40 278 101 105 101
query41 38 36 36 36
query42 110 100 97 97
query43 475 450 460 450
query44 1067 684 695 684
query45 200 177 186 177
query46 1045 769 760 760
query47 1706 1551 1560 1551
query48 423 361 347 347
query49 1194 298 297 297
query50 771 368 362 362
query51 4453 4320 4321 4320
query52 111 96 96 96
query53 390 307 298 298
query54 284 225 221 221
query55 87 76 79 76
query56 221 199 208 199
query57 1069 939 1026 939
query58 207 187 197 187
query59 2394 2129 2280 2129
query60 230 221 207 207
query61 81 89 80 80
query62 601 371 390 371
query63 333 286 285 285
query64 6347 3066 3118 3066
query65 3268 3265 3249 3249
query66 1341 328 318 318
query67 14769 14429 14397 14397
query68 5067 548 560 548
query69 518 345 355 345
query70 1297 1224 1275 1224
query71 427 255 256 255
query72 6456 2787 2602 2602
query73 705 307 312 307
query74 6861 6398 6390 6390
query75 3241 2555 2555 2555
query76 3285 1134 1211 1134
query77 370 244 232 232
query78 9383 8816 8789 8789
query79 969 516 496 496
query80 503 343 350 343
query81 432 201 208 201
query82 162 89 80 80
query83 136 126 118 118
query84 224 76 77 76
query85 1001 349 339 339
query86 306 307 315 307
query87 3476 3277 3317 3277
query88 2677 2295 2297 2295
query89 434 372 360 360
query90 1844 164 158 158
query91 152 130 129 129
query92 52 49 51 49
query93 1012 505 494 494
query94 1152 176 172 172
query95 428 340 342 340
query96 574 262 262 262
query97 4432 4305 4319 4305
query98 216 202 197 197
query99 1101 735 718 718
Total cold run time: 268661 ms
Total hot run time: 176758 ms
ClickBench: Total hot run time: 30.02 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 19a166a50c07f95d4dc562aed63398a500dac294, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.23 0.07 0.07
query4 1.67 0.09 0.08
query5 0.48 0.49 0.48
query6 1.33 0.62 0.60
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.51 0.45 0.45
query10 0.49 0.48 0.49
query11 0.13 0.10 0.10
query12 0.12 0.10 0.10
query13 0.58 0.59 0.58
query14 0.76 0.79 0.77
query15 0.82 0.79 0.78
query16 0.33 0.32 0.33
query17 0.90 0.87 0.90
query18 0.17 0.17 0.16
query19 1.69 1.65 1.60
query20 0.01 0.01 0.01
query21 15.40 0.63 0.60
query22 3.52 3.44 1.52
query23 17.12 1.04 0.97
query24 2.07 0.57 0.49
query25 0.63 0.07 0.05
query26 0.19 0.13 0.12
query27 0.06 0.06 0.06
query28 11.80 0.83 0.80
query29 12.72 3.39 3.28
query30 0.56 0.49 0.48
query31 2.78 0.36 0.36
query32 3.35 0.47 0.47
query33 3.12 3.17 3.12
query34 15.37 4.48 4.47
query35 4.50 4.47 4.48
query36 1.06 0.95 0.96
query37 0.08 0.05 0.05
query38 0.04 0.03 0.03
query39 0.01 0.02 0.01
query40 0.17 0.14 0.15
query41 0.07 0.02 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.01
Total cold run time: 105.03 s
Total hot run time: 30.02 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 19a166a50c07f95d4dc562aed63398a500dac294 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 16.1 seconds inserted 10000000 Rows, about 621K ops/s
TeamCity be ut coverage result: Function Coverage: 35.71% (8548/23937) Line Coverage: 27.53% (69360/251986) Region Coverage: 26.68% (35981/134852) Branch Coverage: 23.49% (18391/78296) Coverage Report: http://coverage.selectdb-in.cc/coverage/133ec7489428849a68f50dd1e02659986caf34f5_133ec7489428849a68f50dd1e02659986caf34f5/report/index.html
TPC-H: Total hot run time: 41331 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 133ec7489428849a68f50dd1e02659986caf34f5, data reload: false
------ Round 1 ----------------------------------
q1 18811 5044 4939 4939
q2 2036 137 130 130
q3 11463 996 1675 996
q4 4659 964 1003 964
q5 7751 3304 3266 3266
q6 208 138 138 138
q7 1282 822 818 818
q8 10218 2045 2053 2045
q9 8662 6668 6668 6668
q10 10733 2629 2620 2620
q11 415 215 219 215
q12 781 324 331 324
q13 17932 3610 3603 3603
q14 289 256 253 253
q15 586 535 534 534
q16 470 402 409 402
q17 912 860 870 860
q18 7422 6606 6586 6586
q19 1542 1479 1502 1479
q20 552 263 264 263
q21 6841 3912 3955 3912
q22 858 343 316 316
Total cold run time: 114423 ms
Total hot run time: 41331 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4868 4867 4854 4854
q2 292 184 182 182
q3 3608 3580 3582 3580
q4 2510 2520 2511 2511
q5 5728 5731 5736 5731
q6 211 126 125 125
q7 2235 1639 1656 1639
q8 2984 3091 3087 3087
q9 8705 8691 8602 8602
q10 6767 4241 4228 4228
q11 512 399 371 371
q12 785 547 532 532
q13 6115 3425 3385 3385
q14 276 236 231 231
q15 596 498 509 498
q16 473 427 435 427
q17 1630 1619 1615 1615
q18 8251 7702 7652 7652
q19 1629 1627 1631 1627
q20 2115 1827 1834 1827
q21 6564 6163 6299 6163
q22 583 525 524 524
Total cold run time: 67437 ms
Total hot run time: 59391 ms
TPC-DS: Total hot run time: 175943 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 133ec7489428849a68f50dd1e02659986caf34f5, data reload: false
query1 929 348 345 345
query2 6526 1785 1708 1708
query3 6704 209 202 202
query4 23128 21023 21047 21023
query5 4254 370 372 370
query6 267 166 164 164
query7 4602 289 297 289
query8 252 190 217 190
query9 8457 2747 2756 2747
query10 427 228 219 219
query11 14970 14558 14425 14425
query12 140 82 86 82
query13 1708 414 422 414
query14 8939 7539 7480 7480
query15 214 181 186 181
query16 7357 251 247 247
query17 1432 542 512 512
query18 1951 265 262 262
query19 186 142 150 142
query20 89 79 87 79
query21 187 115 121 115
query22 4880 4840 4785 4785
query23 32440 31596 31599 31596
query24 12712 3436 3444 3436
query25 637 361 349 349
query26 1878 157 152 152
query27 3054 318 310 310
query28 6668 1789 1789 1789
query29 1154 604 609 604
query30 281 138 144 138
query31 934 728 764 728
query32 99 59 58 58
query33 718 234 223 223
query34 1063 488 487 487
query35 939 823 820 820
query36 1000 857 917 857
query37 165 59 63 59
query38 3293 3200 3194 3194
query39 1368 1337 1311 1311
query40 286 104 103 103
query41 37 39 36 36
query42 106 97 101 97
query43 477 459 444 444
query44 1053 681 688 681
query45 196 175 184 175
query46 1035 779 751 751
query47 1662 1614 1541 1541
query48 415 348 341 341
query49 1214 306 302 302
query50 760 370 366 366
query51 4427 4307 4348 4307
query52 107 91 93 91
query53 395 298 306 298
query54 288 214 223 214
query55 91 75 82 75
query56 218 190 193 190
query57 1078 947 928 928
query58 210 195 196 195
query59 2276 2183 2142 2142
query60 241 204 234 204
query61 89 84 80 80
query62 608 390 378 378
query63 315 279 291 279
query64 6413 3045 3094 3045
query65 3294 3260 3220 3220
query66 1352 326 315 315
query67 14545 14586 14088 14088
query68 5040 524 545 524
query69 520 356 357 356
query70 1256 1198 1216 1198
query71 397 276 261 261
query72 6318 2756 2594 2594
query73 700 311 309 309
query74 6894 6469 6429 6429
query75 3204 2570 2538 2538
query76 3267 1117 1210 1117
query77 363 238 237 237
query78 9396 8847 8809 8809
query79 960 509 533 509
query80 553 360 332 332
query81 433 207 204 204
query82 163 89 86 86
query83 142 122 128 122
query84 221 77 78 77
query85 1029 345 342 342
query86 304 316 295 295
query87 3472 3252 3242 3242
query88 2685 2282 2276 2276
query89 434 362 350 350
query90 1960 166 163 163
query91 151 127 131 127
query92 55 50 49 49
query93 1010 506 489 489
query94 1144 174 175 174
query95 433 334 338 334
query96 574 260 263 260
query97 4461 4283 4234 4234
query98 226 207 203 203
query99 1052 751 725 725
Total cold run time: 268007 ms
Total hot run time: 175943 ms
ClickBench: Total hot run time: 30.42 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 133ec7489428849a68f50dd1e02659986caf34f5, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.23 0.07 0.07
query4 1.65 0.09 0.08
query5 0.48 0.48 0.48
query6 1.39 0.60 0.60
query7 0.01 0.01 0.02
query8 0.05 0.02 0.02
query9 0.52 0.45 0.45
query10 0.48 0.49 0.49
query11 0.13 0.10 0.09
query12 0.13 0.10 0.10
query13 0.60 0.60 0.58
query14 0.76 0.79 0.79
query15 0.82 0.79 0.79
query16 0.32 0.32 0.33
query17 0.86 0.89 0.91
query18 0.18 0.17 0.18
query19 1.72 1.68 1.68
query20 0.02 0.01 0.01
query21 15.42 0.65 0.57
query22 3.03 4.60 1.93
query23 17.48 1.01 0.92
query24 1.99 0.77 0.39
query25 0.62 0.07 0.05
query26 0.15 0.14 0.13
query27 0.06 0.05 0.06
query28 11.83 0.84 0.82
query29 12.58 3.28 3.35
query30 0.52 0.50 0.46
query31 2.78 0.37 0.36
query32 3.35 0.47 0.48
query33 3.13 3.13 3.17
query34 15.36 4.50 4.49
query35 4.48 4.53 4.48
query36 1.07 0.94 0.95
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.18 0.14 0.14
query41 0.07 0.01 0.02
query42 0.02 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 104.72 s
Total hot run time: 30.42 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 133ec7489428849a68f50dd1e02659986caf34f5 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 16.8 seconds inserted 10000000 Rows, about 595K ops/s