You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2024/06/11 06:21:30 UTC
[PR] [fix](forward) set error code for query state to handle exception of … [doris]
dataroaring opened a new pull request, #36105:
URL: https://github.com/apache/doris/pull/36105
…(#31975)
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159888251
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159888473
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159954307
<details>
<summary>TPC-DS: <b>Total hot run time: 204770 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a4a65e92dc1857057f1d8f1f92dcbf1e1c498259, data reload: false
query1 938 436 380 380
query2 6528 2719 2746 2719
query3 6923 214 210 210
query4 19919 17973 17923 17923
query5 19723 6525 6590 6525
query6 289 218 237 218
query7 4185 297 310 297
query8 270 273 236 236
query9 3167 2713 2647 2647
query10 427 311 292 292
query11 11292 10773 10883 10773
query12 127 81 79 79
query13 5604 695 681 681
query14 18111 13719 13268 13268
query15 382 221 227 221
query16 6453 288 263 263
query17 1538 1471 886 886
query18 2258 411 401 401
query19 206 154 160 154
query20 71 77 82 77
query21 194 98 94 94
query22 5292 5125 5075 5075
query23 32410 31773 32126 31773
query24 7058 6509 6526 6509
query25 523 432 420 420
query26 516 166 162 162
query27 1838 292 291 291
query28 6203 2371 2317 2317
query29 2916 2647 2789 2647
query30 242 169 171 169
query31 886 752 758 752
query32 71 68 63 63
query33 411 249 260 249
query34 867 487 477 477
query35 1145 915 976 915
query36 1244 1261 1196 1196
query37 89 59 56 56
query38 3076 2922 3017 2922
query39 1370 1353 1317 1317
query40 212 99 93 93
query41 41 39 38 38
query42 88 84 88 84
query43 778 623 771 623
query44 1295 718 715 715
query45 246 235 229 229
query46 1242 970 981 970
query47 1882 1747 1867 1747
query48 1005 726 707 707
query49 606 383 383 383
query50 865 644 593 593
query51 4839 4654 4656 4654
query52 90 85 82 82
query53 449 324 312 312
query54 2641 2459 2502 2459
query55 88 93 91 91
query56 222 238 219 219
query57 1210 1098 1052 1052
query58 221 201 191 191
query59 3958 4168 3955 3955
query60 212 215 202 202
query61 98 98 101 98
query62 809 461 454 454
query63 494 339 343 339
query64 2557 1551 1514 1514
query65 3661 3540 3545 3540
query66 779 373 395 373
query67 17256 16996 15991 15991
query68 8165 670 678 670
query69 575 374 349 349
query70 1743 1449 1530 1449
query71 392 305 322 305
query72 6740 3502 3550 3502
query73 731 328 330 328
query74 6259 5895 5925 5895
query75 4540 3808 3655 3655
query76 4611 1158 1189 1158
query77 561 260 270 260
query78 12539 12444 11898 11898
query79 10752 668 645 645
query80 1640 407 411 407
query81 509 237 235 235
query82 1285 97 101 97
query83 174 134 145 134
query84 257 73 73 73
query85 1287 342 321 321
query86 353 296 314 296
query87 3274 3011 3046 3011
query88 5212 2354 2345 2345
query89 441 305 296 296
query90 1785 215 207 207
query91 182 141 143 141
query92 61 57 57 57
query93 6155 579 577 577
query94 874 214 222 214
query95 1150 1071 1070 1070
query96 658 332 333 332
query97 6530 6388 6416 6388
query98 184 179 182 179
query99 2907 915 914 914
Total cold run time: 315132 ms
Total hot run time: 204770 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36105:
URL: https://github.com/apache/doris/pull/36105
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159933896
<details>
<summary>TPC-H: <b>Total hot run time: 49927 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a4a65e92dc1857057f1d8f1f92dcbf1e1c498259, data reload: false
------ Round 1 ----------------------------------
q1 18065 4397 4353 4353
q2 2067 153 146 146
q3 10452 1851 1925 1851
q4 10314 1255 1324 1255
q5 8846 3876 3905 3876
q6 233 125 151 125
q7 2023 1585 1599 1585
q8 9277 2732 2694 2694
q9 11081 10655 10524 10524
q10 8662 3499 3507 3499
q11 417 243 255 243
q12 471 304 306 304
q13 18334 3995 4048 3995
q14 364 340 335 335
q15 511 460 468 460
q16 675 579 567 567
q17 1126 976 960 960
q18 7273 6927 7025 6927
q19 1702 1513 1456 1456
q20 544 300 313 300
q21 4429 4085 4105 4085
q22 505 387 404 387
Total cold run time: 117371 ms
Total hot run time: 49927 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4351 4308 4296 4296
q2 319 225 230 225
q3 4162 4176 4118 4118
q4 2752 2760 2776 2760
q5 7215 7174 7108 7108
q6 239 120 120 120
q7 3256 2853 2866 2853
q8 4353 4507 4472 4472
q9 17430 17098 17121 17098
q10 4260 4248 4243 4243
q11 759 690 687 687
q12 1021 869 877 869
q13 6902 3736 3758 3736
q14 466 430 427 427
q15 503 471 450 450
q16 740 670 684 670
q17 3829 3877 3800 3800
q18 8715 8829 8734 8734
q19 1703 1692 1635 1635
q20 2378 2136 2101 2101
q21 8547 8481 8594 8481
q22 1042 955 950 950
Total cold run time: 84942 ms
Total hot run time: 79833 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159963081
<details>
<summary>ClickBench: <b>Total hot run time: 30.83 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a4a65e92dc1857057f1d8f1f92dcbf1e1c498259, data reload: false
query1 0.03 0.03 0.02
query2 0.07 0.03 0.02
query3 0.25 0.04 0.04
query4 1.79 0.05 0.06
query5 0.54 0.52 0.53
query6 1.23 0.61 0.63
query7 0.01 0.02 0.01
query8 0.04 0.02 0.03
query9 0.52 0.50 0.48
query10 0.55 0.55 0.53
query11 0.12 0.08 0.08
query12 0.11 0.09 0.09
query13 0.62 0.61 0.60
query14 0.80 0.78 0.77
query15 0.77 0.77 0.76
query16 0.36 0.38 0.35
query17 0.99 1.02 1.02
query18 0.24 0.22 0.27
query19 1.94 1.87 1.84
query20 0.01 0.01 0.00
query21 15.47 0.57 0.57
query22 2.00 2.59 1.30
query23 16.89 0.97 0.93
query24 7.14 1.47 1.33
query25 0.39 0.12 0.05
query26 0.80 0.16 0.15
query27 0.03 0.05 0.04
query28 5.25 0.78 0.75
query29 12.60 2.37 2.29
query30 0.58 0.54 0.52
query31 2.81 0.38 0.37
query32 3.40 0.49 0.50
query33 3.11 3.09 3.08
query34 15.25 4.83 4.83
query35 4.91 4.86 4.88
query36 1.06 0.99 1.02
query37 0.06 0.05 0.04
query38 0.03 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.14 0.14
query41 0.06 0.02 0.01
query42 0.03 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 103.06 s
Total hot run time: 30.83 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](forward) set error code for query state to handle exception of … [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36105:
URL: https://github.com/apache/doris/pull/36105#issuecomment-2159968179
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a4a65e92dc1857057f1d8f1f92dcbf1e1c498259 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.8 seconds inserted 10000000 Rows, about 458K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org