Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
starocean999 merged PR #43119: URL: https://github.com/apache/doris/pull/43119 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
github-actions[bot] commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2482968759 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
starocean999 commented on code in PR #43119: URL: https://github.com/apache/doris/pull/43119#discussion_r1846099706 ## fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowPrivilegesCommand.java: ## @@ -0,0 +1,77 @@ +// Licensed to the Apache Software Foundation (ASF) under one +// or more contributor license agreements. See the NOTICE file +// distributed with this work for additional information +// regarding copyright ownership. The ASF licenses this file +// to you under the Apache License, Version 2.0 (the +// "License"); you may not use this file except in compliance +// with the License. You may obtain a copy of the License at +// +// http://www.apache.org/licenses/LICENSE-2.0 +// +// Unless required by applicable law or agreed to in writing, +// software distributed under the License is distributed on an +// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +// KIND, either express or implied. See the License for the +// specific language governing permissions and limitations +// under the License. + +package org.apache.doris.nereids.trees.plans.commands; + +import org.apache.doris.catalog.Column; +import org.apache.doris.catalog.ScalarType; +import org.apache.doris.mysql.privilege.Privilege; +import org.apache.doris.nereids.trees.plans.PlanType; +import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor; +import org.apache.doris.qe.ConnectContext; +import org.apache.doris.qe.ShowResultSet; +import org.apache.doris.qe.ShowResultSetMetaData; +import org.apache.doris.qe.StmtExecutor; + +import com.google.common.collect.Lists; +import org.apache.logging.log4j.LogManager; +import org.apache.logging.log4j.Logger; + +import java.util.List; + +/** + * show privileges command + */ +public class ShowPrivilegesCommand extends ShowCommand { +public static final Logger LOG = LogManager.getLogger(ShowPrivilegesCommand.class); Review Comment: ```suggestion ``` -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
github-actions[bot] commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2482295189 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
github-actions[bot] commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2482295259 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
Vallishp commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2482755865 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
Vallishp commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2482452234 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
Vallishp commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2480931005 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
Vallishp commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2479467895 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
starocean999 commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2478053138 please resolve conflict -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
doris-robot commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2452425963 ClickBench: Total hot run time: 32.04 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 314eae54d01e9e966076df5b27d667c343ba3e78, data reload: false query1 0.030.030.03 query2 0.070.030.03 query3 0.230.070.07 query4 1.640.100.10 query5 0.420.410.39 query6 1.140.640.66 query7 0.020.010.01 query8 0.040.030.03 query9 0.550.510.50 query10 0.560.550.58 query11 0.140.100.10 query12 0.140.110.11 query13 0.610.600.60 query14 2.822.822.84 query15 0.900.830.81 query16 0.370.380.40 query17 1.051.071.04 query18 0.200.200.20 query19 2.021.932.02 query20 0.010.010.01 query21 15.36 0.610.58 query22 2.942.681.36 query23 17.10 0.940.78 query24 3.011.470.81 query25 0.310.190.06 query26 0.380.130.14 query27 0.050.040.04 query28 10.65 1.081.07 query29 12.54 3.263.24 query30 0.250.060.06 query31 2.870.380.38 query32 3.270.450.45 query33 3.013.053.03 query34 16.86 4.444.41 query35 4.574.504.52 query36 0.660.490.51 query37 0.090.070.06 query38 0.050.040.03 query39 0.030.020.02 query40 0.160.120.13 query41 0.070.020.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 107.26 s Total hot run time: 32.04 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
doris-robot commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2452418356 TPC-DS: Total hot run time: 196664 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 314eae54d01e9e966076df5b27d667c343ba3e78, data reload: false query1 1180930 912 912 query2 6234211720682068 query3 10760 391139223911 query4 68357 28626 23594 23594 query5 4921451 441 441 query6 393 183 164 164 query7 5517290 293 290 query8 317 223 225 223 query9 8744272927242724 query10 435 256 249 249 query11 17284 15265 15965 15265 query12 160 106 103 103 query13 1488463 431 431 query14 10557 762072997299 query15 207 189 193 189 query16 7107471 475 471 query17 1026561 565 561 query18 1780303 297 297 query19 196 153 157 153 query20 118 111 118 111 query21 200 100 102 100 query22 4631424740954095 query23 34629 34249 34222 34222 query24 5965274827312731 query25 518 403 405 403 query26 642 159 157 157 query27 1644282 285 282 query28 4342242823972397 query29 679 423 419 419 query30 239 155 152 152 query31 985 783 824 783 query32 66 54 60 54 query33 459 268 278 268 query34 925 522 526 522 query35 868 750 733 733 query36 1049957 967 957 query37 120 77 75 75 query38 4485423044934230 query39 1493144515671445 query40 211 101 103 101 query41 52 45 47 45 query42 116 100 100 100 query43 566 517 516 516 query44 1218860 843 843 query45 187 166 174 166 query46 1125690 711 690 query47 1961185318671853 query48 422 315 328 315 query49 731 403 396 396 query50 832 398 412 398 query51 7243717971087108 query52 100 89 89 89 query53 253 181 184 181 query54 534 410 434 410 query55 76 72 76 72 query56 258 231 247 231 query57 1289115511491149 query58 214 206 198 198 query59 3299312034013120 query60 271 241 236 236 query61 106 101 99 99 query62 825 688 669 669 query63 210 187 187 187 query64 1337626 604 604 query65 3288321932463219 query66 699 297 301 297 query67 15925 15732 15772 15732 query68 3956575 572 572 query69 422 253 259 253 query70 1210119311471147 query71 346 250 250 250 query72 6353397140023971 query73 750 368 369 368 query74 10152 900491049004 query75 3415268626872686 query76 1794109710661066 query77 477 286 269 269 query78 10427 940894219408 query79 1417589 597 589 query80 868 424 432 424 query81 518 238 236 236 query82 1285117 116 116 query83 225 136 142 136 query84 281 74 66 66 query85 870 286 286 286 query86 343 298 297 297 query87 4845467048934670 query88 3625221321692169 query89 407 295 281 281 query90 1996189 191 189 query91 136 99 98 98 query92 63 53 49 49 query93 1909534 538 534 query94 801 301 297 297 query95 352 245 244 244 query96 626 282 290 282 query97 2941272327372723 query98 211 204 204 204 query99 1602134512751275 Total cold run time: 318691 ms Total hot run time: 196664 ms ``` -- 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
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
doris-robot commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2452400777 TPC-H: Total hot run time: 41284 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 314eae54d01e9e966076df5b27d667c343ba3e78, data reload: false -- Round 1 -- q1 17605 741773077307 q2 2051162 158 158 q3 10598 108011941080 q4 10573 894 835 835 q5 7749309930313031 q6 236 147 147 147 q7 1033605 611 605 q8 9361192619891926 q9 6560643664366436 q10 7026241424322414 q11 467 267 259 259 q12 414 212 219 212 q13 17791 300030053000 q14 237 215 206 206 q15 565 523 519 519 q16 643 582 559 559 q17 959 579 508 508 q18 7238681066736673 q19 13301006968 968 q20 463 186 188 186 q21 3982337332493249 q22 1105100610331006 Total cold run time: 107986 ms Total hot run time: 41284 ms - Round 2, with runtime_filter_mode=off - q1 7302730972547254 q2 323 235 235 235 q3 2998299429482948 q4 2126186018181818 q5 5752576858295768 q6 228 140 139 139 q7 2282184118231823 q8 3392349134783478 q9 8909893788358835 q10 3628355635593556 q11 604 500 517 500 q12 853 620 605 605 q13 9652320731793179 q14 318 289 283 283 q15 582 513 517 513 q16 659 655 621 621 q17 1858163016581630 q18 8207777677007700 q19 1702154916941549 q20 2145187418741874 q21 5730538754115387 q22 1130104210371037 Total cold run time: 70380 ms Total hot run time: 60732 ms ``` -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
Vallishp commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2452320222 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]
doris-robot commented on PR #43119: URL: https://github.com/apache/doris/pull/43119#issuecomment-2452121973 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org