You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Jibing-Li (via GitHub)" <gi...@apache.org> on 2024/10/21 09:25:33 UTC
[PR] [fix](statistics)Skip shadow index while analyzing a table. [doris]
Jibing-Li opened a new pull request, #42201:
URL: https://github.com/apache/doris/pull/42201
Skip shadow index while analyzing a table.
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431151507
<details>
<summary>ClickBench: <b>Total hot run time: 32.64 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 485532398a1eb42757c2b4dfa0f90897a2fbc567, data reload: false
query1 0.03 0.04 0.03
query2 0.06 0.03 0.04
query3 0.23 0.07 0.06
query4 1.65 0.10 0.11
query5 0.52 0.53 0.49
query6 1.14 0.74 0.72
query7 0.02 0.01 0.02
query8 0.04 0.04 0.03
query9 0.54 0.50 0.47
query10 0.56 0.54 0.53
query11 0.15 0.12 0.11
query12 0.14 0.11 0.11
query13 0.61 0.59 0.59
query14 2.85 2.75 2.82
query15 0.89 0.81 0.83
query16 0.37 0.39 0.38
query17 1.06 1.05 1.05
query18 0.20 0.20 0.20
query19 1.94 1.89 1.95
query20 0.01 0.01 0.01
query21 15.71 0.59 0.59
query22 2.21 2.44 2.04
query23 17.03 1.07 0.75
query24 2.94 1.80 0.66
query25 0.21 0.17 0.08
query26 0.46 0.14 0.13
query27 0.05 0.03 0.04
query28 10.40 1.08 1.07
query29 12.59 3.25 3.21
query30 0.26 0.06 0.08
query31 2.86 0.38 0.39
query32 3.25 0.46 0.46
query33 3.03 3.04 3.07
query34 17.10 4.49 4.50
query35 4.55 4.51 4.51
query36 0.66 0.48 0.47
query37 0.08 0.06 0.06
query38 0.05 0.03 0.03
query39 0.04 0.02 0.02
query40 0.16 0.12 0.12
query41 0.08 0.02 0.03
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 106.8 s
Total hot run time: 32.64 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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431140105
<details>
<summary>TPC-DS: <b>Total hot run time: 192432 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 485532398a1eb42757c2b4dfa0f90897a2fbc567, data reload: false
query1 941 386 399 386
query2 6259 2073 2057 2057
query3 8688 205 213 205
query4 34453 23565 23695 23565
query5 3531 468 481 468
query6 272 175 188 175
query7 4194 289 288 288
query8 284 228 238 228
query9 9421 2649 2633 2633
query10 443 267 287 267
query11 17855 15323 15281 15281
query12 152 101 102 101
query13 1579 433 409 409
query14 10038 7579 7235 7235
query15 238 170 175 170
query16 7937 495 520 495
query17 1676 586 599 586
query18 2085 324 308 308
query19 236 158 159 158
query20 130 116 118 116
query21 223 112 107 107
query22 4709 4650 4574 4574
query23 35123 34221 34280 34221
query24 11073 2765 2706 2706
query25 621 413 408 408
query26 1297 161 157 157
query27 2703 282 286 282
query28 7846 2400 2425 2400
query29 873 436 432 432
query30 281 153 159 153
query31 1077 772 793 772
query32 103 53 58 53
query33 797 297 296 296
query34 918 520 522 520
query35 861 756 752 752
query36 1109 942 949 942
query37 162 91 89 89
query38 4159 3955 3942 3942
query39 1485 1443 1416 1416
query40 257 101 101 101
query41 48 49 46 46
query42 123 102 102 102
query43 548 507 497 497
query44 1313 799 804 799
query45 200 164 167 164
query46 1138 700 702 700
query47 1928 1826 1828 1826
query48 427 322 316 316
query49 989 430 427 427
query50 812 387 405 387
query51 7137 6996 6966 6966
query52 109 96 92 92
query53 253 186 183 183
query54 1138 438 439 438
query55 83 81 79 79
query56 295 275 284 275
query57 1324 1160 1160 1160
query58 237 247 233 233
query59 3228 3138 3048 3048
query60 290 274 269 269
query61 104 100 105 100
query62 847 685 662 662
query63 218 185 186 185
query64 5030 648 620 620
query65 3290 3223 3220 3220
query66 1085 315 304 304
query67 15706 15844 15636 15636
query68 4382 566 576 566
query69 555 291 301 291
query70 1218 1153 1104 1104
query71 392 281 309 281
query72 7448 3985 3995 3985
query73 772 355 356 355
query74 10221 9098 9047 9047
query75 3498 2677 2652 2652
query76 3375 910 889 889
query77 420 302 315 302
query78 10480 9627 9526 9526
query79 2044 593 603 593
query80 1328 467 454 454
query81 575 243 240 240
query82 686 147 141 141
query83 254 143 141 141
query84 241 70 70 70
query85 1518 300 291 291
query86 415 295 301 295
query87 4511 4295 4431 4295
query88 3758 2210 2169 2169
query89 406 298 284 284
query90 1994 187 187 187
query91 135 101 103 101
query92 68 51 46 46
query93 1133 537 527 527
query94 1075 295 305 295
query95 365 252 247 247
query96 611 286 297 286
query97 3276 3090 3218 3090
query98 220 194 198 194
query99 1623 1300 1316 1300
Total cold run time: 302986 ms
Total hot run time: 192432 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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431498406
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2426220936
<details>
<summary>TPC-H: <b>Total hot run time: 42121 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 a567a883b6044c895a9bc3340939e2aa2555f625, data reload: false
------ Round 1 ----------------------------------
q1 17620 7433 7361 7361
q2 2023 298 288 288
q3 12562 1099 1180 1099
q4 10565 899 936 899
q5 7775 3148 3125 3125
q6 239 155 152 152
q7 1045 643 619 619
q8 9515 1924 1942 1924
q9 6634 6531 6459 6459
q10 7077 2443 2429 2429
q11 452 246 243 243
q12 426 216 219 216
q13 18813 3135 3156 3135
q14 267 229 245 229
q15 579 538 557 538
q16 920 603 592 592
q17 997 637 508 508
q18 7876 7180 6929 6929
q19 1427 942 1004 942
q20 513 188 188 188
q21 4022 3218 3218 3218
q22 1131 1054 1028 1028
Total cold run time: 112478 ms
Total hot run time: 42121 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7380 7246 7443 7246
q2 339 235 235 235
q3 3064 3004 3032 3004
q4 2080 1783 1864 1783
q5 5734 5780 5798 5780
q6 242 147 150 147
q7 2237 1838 1847 1838
q8 3300 3511 3483 3483
q9 8972 9021 8886 8886
q10 3607 3565 3605 3565
q11 593 493 484 484
q12 800 607 620 607
q13 14503 3161 3195 3161
q14 309 295 294 294
q15 583 523 537 523
q16 659 622 625 622
q17 1847 1651 1585 1585
q18 8242 7770 7605 7605
q19 1706 1425 1437 1425
q20 2149 1895 1889 1889
q21 5628 5350 5390 5350
q22 1176 1074 1073 1073
Total cold run time: 75150 ms
Total hot run time: 60585 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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431814990
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431251780
run feut
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2434564693
PR approved by at least one committer and no changes requested.
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2432340994
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431322385
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2426259965
<details>
<summary>ClickBench: <b>Total hot run time: 33.23 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 a567a883b6044c895a9bc3340939e2aa2555f625, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.65 0.10 0.10
query5 0.51 0.49 0.49
query6 1.15 0.73 0.72
query7 0.02 0.01 0.01
query8 0.03 0.03 0.03
query9 0.58 0.52 0.53
query10 0.56 0.54 0.55
query11 0.14 0.10 0.10
query12 0.14 0.10 0.11
query13 0.61 0.60 0.60
query14 2.81 2.76 2.73
query15 0.89 0.82 0.83
query16 0.41 0.37 0.38
query17 1.03 1.01 0.98
query18 0.20 0.20 0.20
query19 1.91 1.79 1.92
query20 0.01 0.01 0.01
query21 15.37 0.61 0.61
query22 2.14 2.52 2.11
query23 17.06 0.89 0.78
query24 2.85 1.66 1.36
query25 0.27 0.13 0.05
query26 0.58 0.13 0.13
query27 0.04 0.04 0.03
query28 9.91 1.12 1.06
query29 12.58 3.25 3.27
query30 0.25 0.06 0.05
query31 2.87 0.38 0.38
query32 3.29 0.46 0.45
query33 2.97 3.04 2.97
query34 17.06 4.50 4.50
query35 4.60 4.50 4.52
query36 0.67 0.48 0.49
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.04 0.02 0.03
query40 0.15 0.13 0.12
query41 0.08 0.02 0.02
query42 0.04 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 105.96 s
Total hot run time: 33.23 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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2426111691
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431116329
<details>
<summary>TPC-H: <b>Total hot run time: 41411 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 485532398a1eb42757c2b4dfa0f90897a2fbc567, data reload: false
------ Round 1 ----------------------------------
q1 17584 7444 7316 7316
q2 2013 300 297 297
q3 12212 1062 1150 1062
q4 10587 853 920 853
q5 7757 3098 3044 3044
q6 244 159 150 150
q7 1025 644 601 601
q8 9362 1969 1950 1950
q9 6522 6460 6351 6351
q10 7052 2413 2466 2413
q11 434 249 256 249
q12 410 228 229 228
q13 17775 3051 3024 3024
q14 251 207 224 207
q15 570 525 529 525
q16 657 600 586 586
q17 963 628 544 544
q18 7211 6722 6798 6722
q19 1345 1007 1032 1007
q20 490 193 188 188
q21 4036 3297 3090 3090
q22 1124 1016 1004 1004
Total cold run time: 109624 ms
Total hot run time: 41411 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7364 7357 7307 7307
q2 336 247 234 234
q3 3075 2950 2961 2950
q4 2118 1889 1805 1805
q5 5781 5776 5711 5711
q6 235 157 149 149
q7 2196 1859 1826 1826
q8 3337 3566 3415 3415
q9 8952 8939 8876 8876
q10 3623 3594 3586 3586
q11 597 492 494 492
q12 848 651 668 651
q13 10512 3284 3206 3206
q14 320 268 272 268
q15 593 530 528 528
q16 701 659 654 654
q17 1844 1614 1621 1614
q18 8400 7747 7623 7623
q19 1716 1352 1495 1352
q20 2139 1890 1958 1890
q21 5642 5470 5447 5447
q22 1149 1104 1059 1059
Total cold run time: 71478 ms
Total hot run time: 60643 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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2426112950
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431046837
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2431158989
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li merged PR #42201:
URL: https://github.com/apache/doris/pull/42201
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #42201:
URL: https://github.com/apache/doris/pull/42201#discussion_r1811801442
##########
fe/fe-core/src/main/java/org/apache/doris/catalog/OlapTable.java:
##########
@@ -961,6 +962,9 @@ public List<Column> getSchemaByIndexId(Long indexId, boolean full) {
public Set<Column> getSchemaAllIndexes(boolean full) {
Set<Column> columns = Sets.newHashSet();
for (Long indexId : indexIdToMeta.keySet()) {
+ if (isShadowIndex(indexId)) {
Review Comment:
use `org.apache.doris.catalog.OlapTable#getVisibleIndex`
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2432412766
run p0
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2434564754
PR approved by anyone and no changes requested.
--
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](statistics)Skip shadow index while analyzing a table. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42201:
URL: https://github.com/apache/doris/pull/42201#issuecomment-2426248130
<details>
<summary>TPC-DS: <b>Total hot run time: 192694 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 a567a883b6044c895a9bc3340939e2aa2555f625, data reload: false
query1 906 389 392 389
query2 6256 2181 2090 2090
query3 8685 195 191 191
query4 34659 23642 23581 23581
query5 3471 478 470 470
query6 283 172 168 168
query7 4199 307 287 287
query8 302 230 232 230
query9 9565 2745 2747 2745
query10 468 282 269 269
query11 17732 15337 15304 15304
query12 161 107 101 101
query13 1560 448 417 417
query14 10263 7231 7246 7231
query15 247 168 172 168
query16 8051 451 456 451
query17 1598 598 576 576
query18 2215 315 321 315
query19 379 159 152 152
query20 127 116 115 115
query21 214 110 111 110
query22 5126 4596 4799 4596
query23 35693 34401 34230 34230
query24 10943 2766 2874 2766
query25 534 404 406 404
query26 764 160 165 160
query27 2068 284 285 284
query28 6672 2464 2428 2428
query29 669 428 434 428
query30 256 158 155 155
query31 1088 773 797 773
query32 105 59 57 57
query33 768 303 290 290
query34 920 510 511 510
query35 895 780 746 746
query36 1114 944 940 940
query37 143 99 85 85
query38 4119 3936 3953 3936
query39 1521 1413 1432 1413
query40 210 104 102 102
query41 50 48 46 46
query42 119 103 97 97
query43 532 497 504 497
query44 1233 807 824 807
query45 200 166 168 166
query46 1128 711 689 689
query47 1986 1883 1854 1854
query48 431 327 326 326
query49 930 432 440 432
query50 814 392 387 387
query51 7149 7011 6953 6953
query52 106 90 115 90
query53 260 175 176 175
query54 1201 417 432 417
query55 76 78 77 77
query56 267 255 251 251
query57 1289 1138 1167 1138
query58 221 215 225 215
query59 3290 3033 3042 3033
query60 286 257 257 257
query61 105 107 106 106
query62 881 653 666 653
query63 227 196 187 187
query64 3700 645 611 611
query65 3347 3250 3198 3198
query66 841 304 298 298
query67 16092 15705 15646 15646
query68 4401 576 547 547
query69 518 308 295 295
query70 1222 1118 1143 1118
query71 373 275 260 260
query72 7248 4060 3879 3879
query73 779 371 363 363
query74 10340 9061 9069 9061
query75 3418 2714 2673 2673
query76 3064 950 888 888
query77 594 300 291 291
query78 10630 9724 9672 9672
query79 1810 604 604 604
query80 1171 434 451 434
query81 589 237 235 235
query82 715 142 138 138
query83 296 139 138 138
query84 276 70 67 67
query85 1311 301 288 288
query86 399 304 301 301
query87 4589 4475 4443 4443
query88 3007 2221 2151 2151
query89 405 284 280 280
query90 1979 184 181 181
query91 143 103 100 100
query92 60 50 48 48
query93 1943 547 542 542
query94 1026 292 277 277
query95 352 249 246 246
query96 604 273 278 273
query97 3291 3122 3167 3122
query98 213 206 208 206
query99 1782 1318 1304 1304
Total cold run time: 300258 ms
Total hot run time: 192694 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