You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org> on 2024/02/27 12:23:24 UTC
[PR] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
zhiqiang-hhhh opened a new pull request, #31490:
URL: https://github.com/apache/doris/pull/31490
pick #31228
--
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966493960
<details>
<summary>TPC-DS: <b>Total hot run time: 226294 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
query1 923 391 384 384
query2 6527 2289 2113 2113
query3 6921 206 211 206
query4 20889 18018 17970 17970
query5 19728 6547 6550 6547
query6 295 218 226 218
query7 4164 297 290 290
query8 246 273 231 231
query9 3127 2722 2651 2651
query10 408 280 307 280
query11 11269 10667 10707 10667
query12 115 72 73 72
query13 5583 663 623 623
query14 18154 13613 13670 13613
query15 386 230 226 226
query16 6454 273 262 262
query17 1754 1444 864 864
query18 2323 405 407 405
query19 196 146 145 145
query20 80 82 76 76
query21 186 99 91 91
query22 5455 5823 6552 5823
query23 40821 36996 36197 36197
query24 7415 7196 7093 7093
query25 636 498 500 498
query26 540 180 183 180
query27 1839 329 331 329
query28 6080 2376 2355 2355
query29 3112 3026 3009 3009
query30 276 182 193 182
query31 1015 824 903 824
query32 78 68 69 68
query33 426 286 288 286
query34 950 505 548 505
query35 1415 1188 1281 1188
query36 1754 1910 1833 1833
query37 112 84 73 73
query38 3616 3461 3407 3407
query39 1536 1455 1518 1455
query40 223 112 120 112
query41 50 41 40 40
query42 105 95 101 95
query43 653 569 626 569
query44 1230 990 842 842
query45 284 281 286 281
query46 1440 1079 1104 1079
query47 2556 2178 2108 2108
query48 1099 750 763 750
query49 666 402 421 402
query50 1030 667 685 667
query51 5543 5225 5350 5225
query52 110 92 90 90
query53 494 359 348 348
query54 3022 2655 2586 2586
query55 104 97 97 97
query56 267 235 240 235
query57 1317 1287 1254 1254
query58 246 239 213 213
query59 4038 3410 3825 3410
query60 232 238 239 238
query61 94 99 95 95
query62 787 598 505 505
query63 512 368 360 360
query64 4225 1822 1644 1644
query65 4165 4362 4526 4362
query66 990 457 417 417
query67 22742 19801 21550 19801
query68 8011 733 717 717
query69 644 421 401 401
query70 2197 1979 1820 1820
query71 446 334 326 326
query72 6804 5544 4270 4270
query73 827 353 346 346
query74 7714 7170 7438 7170
query75 5216 4461 4237 4237
query76 4637 1138 1280 1138
query77 568 289 276 276
query78 15175 15109 14100 14100
query79 7008 709 720 709
query80 2368 488 439 439
query81 565 265 273 265
query82 1253 114 109 109
query83 172 150 139 139
query84 231 75 79 75
query85 1443 318 313 313
query86 443 484 408 408
query87 3814 4725 3629 3629
query88 5402 2572 2557 2557
query89 391 335 301 301
query90 1686 222 234 222
query91 177 124 133 124
query92 64 62 53 53
query93 2278 614 628 614
query94 796 235 233 233
query95 1342 1220 1244 1220
query96 697 350 355 350
query97 7541 7440 8092 7440
query98 230 210 210 210
query99 2251 1063 1019 1019
Total cold run time: 337419 ms
Total hot run time: 226294 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #31490:
URL: https://github.com/apache/doris/pull/31490
--
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966430708
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)
--
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org>.
zhiqiang-hhhh commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966430869
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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966466834
<details>
<summary>TPC-H: <b>Total hot run time: 49835 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
------ Round 1 ----------------------------------
q1 18168 4360 4334 4334
q2 2037 149 143 143
q3 10283 1910 1914 1910
q4 10367 1233 1311 1233
q5 8502 3888 3972 3888
q6 230 122 123 122
q7 2043 1557 1586 1557
q8 9264 2683 2704 2683
q9 11137 10751 10590 10590
q10 8592 3542 3490 3490
q11 425 237 237 237
q12 456 288 299 288
q13 18339 3960 4020 3960
q14 358 327 323 323
q15 493 458 454 454
q16 702 591 585 585
q17 1110 968 963 963
q18 7137 6945 6796 6796
q19 1655 1557 1517 1517
q20 525 294 321 294
q21 4405 4120 4062 4062
q22 500 407 406 406
Total cold run time: 116728 ms
Total hot run time: 49835 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4327 4287 4342 4287
q2 312 217 233 217
q3 4141 4109 4111 4109
q4 2739 2760 2751 2751
q5 7316 7229 7214 7214
q6 231 116 114 114
q7 3240 2815 2895 2815
q8 4361 4450 4471 4450
q9 17630 17129 17191 17129
q10 4204 4292 4300 4292
q11 790 681 675 675
q12 1017 839 867 839
q13 7496 3739 3717 3717
q14 448 417 411 411
q15 500 446 457 446
q16 761 701 696 696
q17 3783 3803 3836 3803
q18 8706 8681 8829 8681
q19 1678 1696 1616 1616
q20 2409 2121 2128 2121
q21 8545 8480 8462 8462
q22 1069 979 960 960
Total cold run time: 85703 ms
Total hot run time: 79805 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966504310
<details>
<summary>ClickBench: <b>Total hot run time: 31.01 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 6dfac79655b158672bda55c36750d28c7cdf6b2f, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.03
query3 0.24 0.04 0.05
query4 1.84 0.07 0.06
query5 0.53 0.53 0.52
query6 1.33 0.66 0.62
query7 0.01 0.01 0.01
query8 0.03 0.03 0.03
query9 0.52 0.48 0.48
query10 0.54 0.54 0.53
query11 0.11 0.09 0.09
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.77 0.79 0.80
query15 0.79 0.77 0.77
query16 0.37 0.39 0.37
query17 1.01 1.00 1.02
query18 0.24 0.26 0.25
query19 1.92 1.88 1.82
query20 0.01 0.01 0.01
query21 15.50 0.59 0.55
query22 2.06 2.59 1.17
query23 17.07 1.01 1.03
query24 4.87 1.57 1.45
query25 1.58 0.11 0.10
query26 0.31 0.16 0.14
query27 0.10 0.11 0.11
query28 7.14 0.73 0.71
query29 12.66 2.32 2.27
query30 0.51 0.51 0.51
query31 2.81 0.39 0.39
query32 3.44 0.49 0.49
query33 3.06 3.06 3.08
query34 15.27 4.84 4.80
query35 4.89 4.86 4.88
query36 1.04 1.02 1.01
query37 0.05 0.05 0.04
query38 0.03 0.03 0.02
query39 0.02 0.02 0.02
query40 0.16 0.14 0.14
query41 0.06 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.01
Total cold run time: 103.75 s
Total hot run time: 31.01 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] [opt](cancel) Cancel get result future immediately if query is cancelled (pick #31228) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31490:
URL: https://github.com/apache/doris/pull/31490#issuecomment-1966510304
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 6dfac79655b158672bda55c36750d28c7cdf6b2f 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.2 seconds inserted 10000000 Rows, about 471K 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