You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2025/05/28 06:13:45 UTC
[PR] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
github-actions[bot] opened a new pull request, #51317:
URL: https://github.com/apache/doris/pull/51317
Cherry-picked from #51285
--
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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51317:
URL: https://github.com/apache/doris/pull/51317#issuecomment-2915309308
<details>
<summary>TPC-H: <b>Total hot run time: 39865 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 be58abd55b5b4cef4f4d2ab828208023d0163d35, data reload: false
------ Round 1 ----------------------------------
q1 17585 6858 6648 6648
q2 2076 176 164 164
q3 10594 1091 1168 1091
q4 10570 704 716 704
q5 7760 2854 2765 2765
q6 218 136 137 136
q7 996 619 611 611
q8 9384 1951 2080 1951
q9 6711 6431 6466 6431
q10 6989 2226 2288 2226
q11 464 262 260 260
q12 401 212 215 212
q13 17810 2963 3025 2963
q14 230 207 203 203
q15 502 460 473 460
q16 500 376 378 376
q17 981 609 614 609
q18 7490 6753 6776 6753
q19 1415 1020 1085 1020
q20 494 209 207 207
q21 4242 3268 3124 3124
q22 1097 951 1005 951
Total cold run time: 108509 ms
Total hot run time: 39865 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6638 6615 6580 6580
q2 340 233 240 233
q3 2937 2806 2985 2806
q4 1997 1801 1826 1801
q5 5878 5757 5756 5756
q6 217 132 135 132
q7 2254 1780 1841 1780
q8 3402 3596 3557 3557
q9 8956 8839 8878 8839
q10 3587 3529 3506 3506
q11 586 504 514 504
q12 809 638 623 623
q13 8540 3144 3207 3144
q14 288 248 280 248
q15 504 476 466 466
q16 489 443 457 443
q17 1829 1653 1620 1620
q18 8443 7726 7784 7726
q19 1704 1459 1548 1459
q20 2100 1788 1814 1788
q21 5525 5409 5455 5409
q22 1129 1038 1009 1009
Total cold run time: 68152 ms
Total hot run time: 59429 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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51317:
URL: https://github.com/apache/doris/pull/51317#issuecomment-2915343612
<details>
<summary>TPC-DS: <b>Total hot run time: 196570 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 be58abd55b5b4cef4f4d2ab828208023d0163d35, data reload: false
query1 1317 931 915 915
query2 6336 1902 1837 1837
query3 10780 4248 4420 4248
query4 60788 30219 23569 23569
query5 5165 447 442 442
query6 396 171 160 160
query7 5473 323 330 323
query8 306 211 209 209
query9 8666 2590 2585 2585
query10 433 272 266 266
query11 17841 15101 15582 15101
query12 157 102 102 102
query13 1474 454 444 444
query14 10714 7024 7158 7024
query15 205 182 186 182
query16 7132 491 507 491
query17 1182 572 565 565
query18 1867 315 330 315
query19 222 152 173 152
query20 116 120 110 110
query21 201 99 98 98
query22 4681 4480 4733 4480
query23 34817 34503 33839 33839
query24 6295 2996 2952 2952
query25 544 428 420 420
query26 652 174 168 168
query27 1730 365 368 365
query28 3789 2174 2192 2174
query29 708 472 458 458
query30 246 154 159 154
query31 989 818 835 818
query32 72 60 57 57
query33 418 295 299 295
query34 934 525 523 523
query35 845 746 767 746
query36 1049 946 950 946
query37 111 69 72 69
query38 4038 3958 3945 3945
query39 1493 1476 1455 1455
query40 217 106 105 105
query41 50 53 51 51
query42 118 104 107 104
query43 521 484 484 484
query44 1181 859 844 844
query45 190 173 168 168
query46 1160 746 734 734
query47 2004 1884 1903 1884
query48 506 372 391 372
query49 734 440 436 436
query50 828 443 439 439
query51 7439 7304 7357 7304
query52 110 97 98 97
query53 268 205 202 202
query54 591 488 489 488
query55 86 90 81 81
query56 313 263 247 247
query57 1280 1156 1158 1156
query58 230 219 227 219
query59 3209 2944 2941 2941
query60 286 259 261 259
query61 108 145 133 133
query62 760 667 681 667
query63 218 192 196 192
query64 1384 660 628 628
query65 3243 3201 3233 3201
query66 719 304 296 296
query67 15915 15684 15452 15452
query68 4099 581 598 581
query69 444 267 265 265
query70 1175 1090 1082 1082
query71 355 260 265 260
query72 6356 4063 4065 4063
query73 751 346 346 346
query74 10540 9005 8933 8933
query75 3347 2610 2627 2610
query76 2232 1149 1058 1058
query77 510 279 276 276
query78 10550 9635 9575 9575
query79 2045 588 610 588
query80 1356 439 427 427
query81 517 230 218 218
query82 1264 91 92 91
query83 278 153 145 145
query84 276 82 84 82
query85 1002 303 292 292
query86 401 287 298 287
query87 4398 4217 4247 4217
query88 3978 2379 2339 2339
query89 426 290 284 284
query90 1967 186 188 186
query91 186 146 146 146
query92 62 50 50 50
query93 2975 564 568 564
query94 779 296 302 296
query95 365 259 262 259
query96 623 284 275 275
query97 3305 3172 3094 3094
query98 226 206 190 190
query99 1611 1323 1305 1305
Total cold run time: 316249 ms
Total hot run time: 196570 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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #51317:
URL: https://github.com/apache/doris/pull/51317#issuecomment-2915078189
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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #51317:
URL: https://github.com/apache/doris/pull/51317
--
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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #51317:
URL: https://github.com/apache/doris/pull/51317#issuecomment-2915077884
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).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51317:
URL: https://github.com/apache/doris/pull/51317#issuecomment-2915359135
<details>
<summary>ClickBench: <b>Total hot run time: 30.72 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 be58abd55b5b4cef4f4d2ab828208023d0163d35, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.02 0.03
query3 0.23 0.07 0.07
query4 1.62 0.10 0.10
query5 0.52 0.51 0.51
query6 1.14 0.73 0.73
query7 0.02 0.02 0.02
query8 0.04 0.03 0.04
query9 0.57 0.49 0.50
query10 0.55 0.54 0.54
query11 0.14 0.12 0.11
query12 0.15 0.12 0.11
query13 0.61 0.59 0.60
query14 0.78 0.79 0.81
query15 0.85 0.82 0.83
query16 0.40 0.36 0.39
query17 1.07 1.02 1.06
query18 0.23 0.22 0.21
query19 2.01 1.87 1.84
query20 0.01 0.01 0.01
query21 15.39 0.62 0.60
query22 3.17 2.13 1.98
query23 17.14 0.81 0.75
query24 3.06 1.39 1.59
query25 0.27 0.11 0.13
query26 0.49 0.14 0.14
query27 0.05 0.04 0.04
query28 9.46 0.53 0.45
query29 12.65 3.20 3.21
query30 0.24 0.05 0.05
query31 2.86 0.39 0.39
query32 3.26 0.46 0.46
query33 3.01 3.03 3.02
query34 17.10 4.53 4.49
query35 4.55 4.47 4.61
query36 0.69 0.48 0.50
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.04 0.02 0.02
query40 0.17 0.12 0.12
query41 0.07 0.02 0.03
query42 0.04 0.02 0.02
query43 0.04 0.04 0.03
Total cold run time: 104.93 s
Total hot run time: 30.72 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] branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #51317: branch-3.0: [improvement](jdbc catalog) Optimize the acquisition of indentity type in SQLServer #51285
URL: https://github.com/apache/doris/pull/51317
--
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