Re: [PR] [Enhancement] (nereids)implement showPrivilegesCommand in nereids [doris]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-18 Thread via GitHub


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]

2024-11-16 Thread via GitHub


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]

2024-11-15 Thread via GitHub


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]

2024-11-14 Thread via GitHub


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]

2024-11-01 Thread via GitHub


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]

2024-11-01 Thread via GitHub


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]

2024-11-01 Thread via GitHub


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]

2024-11-01 Thread via GitHub


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]

2024-11-01 Thread via GitHub


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