You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BiteTheDDDDt (via GitHub)" <gi...@apache.org> on 2024/01/26 03:35:09 UTC
[PR] [Improvement](priv) move check priv out of analyze [doris]
BiteTheDDDDt opened a new pull request, #30403:
URL: https://github.com/apache/doris/pull/30403
## Proposed changes
move check priv out of analyze
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911407016
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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911455536
<details>
<summary>TPC-DS: <b>Total hot run time: 186552 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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
query1 942 337 326 326
query2 6563 2066 1896 1896
query3 6703 202 201 201
query4 33437 22347 22137 22137
query5 4450 449 367 367
query6 245 146 150 146
query7 4612 260 255 255
query8 220 179 185 179
query9 8303 2599 2586 2586
query10 434 228 226 226
query11 17038 15462 15542 15462
query12 125 66 66 66
query13 1666 385 379 379
query14 10626 7016 7036 7016
query15 209 181 185 181
query16 5788 256 258 256
query17 941 473 495 473
query18 1800 262 249 249
query19 171 131 131 131
query20 73 71 67 67
query21 193 130 134 130
query22 4924 4753 4731 4731
query23 31671 30637 30637 30637
query24 11169 2830 2860 2830
query25 554 308 306 306
query26 870 153 144 144
query27 2835 277 282 277
query28 6213 1847 1832 1832
query29 924 608 616 608
query30 273 137 136 136
query31 910 748 740 740
query32 72 51 51 51
query33 593 210 213 210
query34 848 457 470 457
query35 920 821 801 801
query36 1256 1177 1202 1177
query37 91 56 67 56
query38 3407 3279 3214 3214
query39 1323 1274 1256 1256
query40 194 92 81 81
query41 37 35 36 35
query42 86 82 80 80
query43 485 469 477 469
query44 1057 691 699 691
query45 193 176 175 175
query46 1067 651 660 651
query47 1648 1565 1571 1565
query48 385 298 320 298
query49 1092 289 292 289
query50 688 315 314 314
query51 5384 5260 5189 5189
query52 97 75 77 75
query53 324 258 259 258
query54 244 179 190 179
query55 83 82 75 75
query56 173 163 156 156
query57 974 933 946 933
query58 174 152 154 152
query59 2962 2715 2758 2715
query60 204 184 182 182
query61 86 93 89 89
query62 595 375 358 358
query63 286 265 262 262
query64 4313 1813 1764 1764
query65 3307 3288 3253 3253
query66 1191 313 317 313
query67 15744 15095 15186 15095
query68 12221 532 509 509
query69 587 297 286 286
query70 1662 1525 1505 1505
query71 10437 10199 10201 10199
query72 5094 2834 2877 2834
query73 2736 316 318 316
query74 7681 6374 6342 6342
query75 4894 2324 2289 2289
query76 6347 1066 992 992
query77 655 228 236 228
query78 9353 8903 8538 8538
query79 996 527 512 512
query80 583 330 321 321
query81 467 201 203 201
query82 205 77 80 77
query83 134 114 126 114
query84 273 67 67 67
query85 1106 360 318 318
query86 379 374 391 374
query87 3515 3359 3399 3359
query88 2777 2207 2209 2207
query89 423 370 340 340
query90 1947 191 183 183
query91 158 120 135 120
query92 50 43 47 43
query93 1591 456 452 452
query94 1244 161 157 157
query95 502 453 458 453
query96 612 320 321 320
query97 4254 4151 4154 4151
query98 210 190 181 181
query99 971 676 697 676
Total cold run time: 300529 ms
Total hot run time: 186552 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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911447148
<details>
<summary>TPC-H: <b>Total hot run time: 39039 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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
------ Round 1 ----------------------------------
q1 17661 5354 5374 5354
q2 2048 145 129 129
q3 10789 1123 1112 1112
q4 10373 742 850 742
q5 7757 3142 3146 3142
q6 196 120 120 120
q7 858 486 482 482
q8 9256 1935 1957 1935
q9 7210 6384 6357 6357
q10 8194 3019 3018 3018
q11 412 196 194 194
q12 354 189 190 189
q13 18001 3380 3379 3379
q14 228 216 222 216
q15 538 508 514 508
q16 429 361 394 361
q17 926 552 497 497
q18 7552 7107 6928 6928
q19 1552 1292 1337 1292
q20 575 322 313 313
q21 2785 2453 2469 2453
q22 359 327 318 318
Total cold run time: 108053 ms
Total hot run time: 39039 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5485 5447 5291 5291
q2 323 222 214 214
q3 3384 3238 3297 3238
q4 2096 2108 2037 2037
q5 6054 5948 5978 5948
q6 198 114 117 114
q7 2368 1935 1829 1829
q8 3254 3380 3398 3380
q9 9160 9024 9069 9024
q10 4078 4089 4139 4089
q11 613 497 476 476
q12 850 674 649 649
q13 17864 3350 3314 3314
q14 293 254 266 254
q15 552 511 509 509
q16 512 451 469 451
q17 1879 1847 1819 1819
q18 9605 15268 9784 9784
q19 24703 1602 1552 1552
q20 4609 1937 1917 1917
q21 14648 5342 5284 5284
q22 990 568 556 556
Total cold run time: 113518 ms
Total hot run time: 61729 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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911543274
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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt merged PR #30403:
URL: https://github.com/apache/doris/pull/30403
--
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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911458811
<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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.22 0.05 0.06
query4 1.68 0.07 0.07
query5 0.52 0.53 0.53
query6 1.24 0.63 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.54 0.49 0.50
query10 0.55 0.56 0.56
query11 0.12 0.09 0.09
query12 0.11 0.10 0.09
query13 0.61 0.61 0.60
query14 0.77 0.80 0.81
query15 0.79 0.77 0.76
query16 0.40 0.37 0.37
query17 0.99 1.01 1.00
query18 0.23 0.25 0.24
query19 1.86 1.75 1.76
query20 0.02 0.01 0.01
query21 15.40 0.58 0.57
query22 2.44 2.31 2.00
query23 17.55 0.90 0.79
query24 2.49 1.84 0.92
query25 0.33 0.29 0.14
query26 0.55 0.14 0.13
query27 0.05 0.05 0.05
query28 10.32 0.78 0.76
query29 12.49 3.27 3.18
query30 0.54 0.46 0.49
query31 2.77 0.34 0.35
query32 3.44 0.49 0.48
query33 3.24 3.20 3.25
query34 15.83 4.29 4.34
query35 4.34 4.31 4.27
query36 1.12 1.06 1.08
query37 0.06 0.05 0.05
query38 0.05 0.02 0.02
query39 0.02 0.02 0.02
query40 0.15 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.01 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.09 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] [Improvement](priv) move check priv out of analyze [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911460618
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 0b5fa7bc538d5e1b47ec9d270404079e2469bc76 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 13.7 seconds inserted 10000000 Rows, about 729K 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
Re: [PR] [Improvement](priv) move check priv out of analyze [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911583912
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