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

2024-11-16 Thread via GitHub


starocean999 merged PR #43135:
URL: https://github.com/apache/doris/pull/43135


-- 
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 showStorageEnginesCommand in nereids [doris]

2024-11-15 Thread via GitHub


github-actions[bot] commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2478601569

   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 showStorageEnginesCommand in nereids [doris]

2024-11-15 Thread via GitHub


github-actions[bot] commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2478601481

   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 showStorageEnginesCommand in nereids [doris]

2024-11-15 Thread via GitHub


Vallishp commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2478349218

   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 showStorageEnginesCommand in nereids [doris]

2024-11-14 Thread via GitHub


starocean999 commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2478058614

   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 showStorageEnginesCommand in nereids [doris]

2024-11-11 Thread via GitHub


Vallishp commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2469531974

   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 showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


doris-robot commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2452950241

   
   
   ClickBench: Total hot run time: 32.43 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5bc566bc799b5f9bc3e658ef62701ca1981b75fd, 
data reload: false
   
   query1   0.040.040.03
   query2   0.070.030.04
   query3   0.230.060.06
   query4   1.650.110.10
   query5   0.430.410.41
   query6   1.130.680.65
   query7   0.020.010.01
   query8   0.040.030.04
   query9   0.560.510.49
   query10  0.560.550.55
   query11  0.140.110.11
   query12  0.130.110.11
   query13  0.610.600.59
   query14  2.692.732.75
   query15  0.900.830.82
   query16  0.370.400.38
   query17  1.071.071.06
   query18  0.200.190.20
   query19  1.981.872.00
   query20  0.010.010.01
   query21  15.35   0.610.59
   query22  2.841.831.53
   query23  17.04   0.930.74
   query24  3.131.271.48
   query25  0.270.100.12
   query26  0.500.130.13
   query27  0.040.040.05
   query28  10.26   1.101.07
   query29  12.55   3.223.19
   query30  0.250.060.06
   query31  2.890.390.38
   query32  3.260.470.45
   query33  2.993.063.02
   query34  16.89   4.414.53
   query35  4.494.444.47
   query36  0.660.490.48
   query37  0.090.060.06
   query38  0.040.030.03
   query39  0.030.030.02
   query40  0.160.120.12
   query41  0.070.020.02
   query42  0.040.020.02
   query43  0.030.030.03
   Total cold run time: 106.7 s
   Total hot run time: 32.43 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 showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


doris-robot commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2452949101

   
   
   TPC-DS: Total hot run time: 195677 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 5bc566bc799b5f9bc3e658ef62701ca1981b75fd, 
data reload: false
   
   query1   1196935 907 907
   query2   6259211120972097
   query3   10772   395940903959
   query4   67509   29403   23576   23576
   query5   4924443 450 443
   query6   407 183 171 171
   query7   5537291 285 285
   query8   314 220 220 220
   query9   8980273327132713
   query10  444 259 244 244
   query11  17321   15197   16158   15197
   query12  158 102 103 102
   query13  1554433 433 433
   query14  10668   714975697149
   query15  205 188 192 188
   query16  7363439 435 435
   query17  1053557 569 557
   query18  1780296 287 287
   query19  191 167 146 146
   query20  113 113 116 113
   query21  197 105 98  98
   query22  4485445341494149
   query23  34469   33916   33881   33881
   query24  5959274527262726
   query25  508 402 395 395
   query26  651 158 156 156
   query27  1653277 292 277
   query28  4153244824012401
   query29  683 432 431 431
   query30  230 154 157 154
   query31  991 786 807 786
   query32  65  55  60  55
   query33  397 266 263 263
   query34  901 511 517 511
   query35  845 758 747 747
   query36  1063960 964 960
   query37  122 73  80  73
   query38  4356426243264262
   query39  1465143314171417
   query40  199 99  98  98
   query41  48  46  46  46
   query42  109 98  106 98
   query43  552 495 499 495
   query44  1145821 820 820
   query45  185 170 170 170
   query46  1121669 714 669
   query47  1908184918921849
   query48  410 315 322 315
   query49  739 395 395 395
   query50  823 380 397 380
   query51  7449702071347020
   query52  103 86  82  82
   query53  250 172 180 172
   query54  502 401 401 401
   query55  72  71  73  71
   query56  248 222 237 222
   query57  1304118211501150
   query58  212 200 221 200
   query59  3318309230843084
   query60  274 240 241 240
   query61  113 127 103 103
   query62  792 684 693 684
   query63  208 180 184 180
   query64  1362642 638 638
   query65  3263318532423185
   query66  705 302 289 289
   query67  15897   15959   15915   15915
   query68  3586580 573 573
   query69  415 253 243 243
   query70  1202114111591141
   query71  350 250 247 247
   query72  6147395039483948
   query73  767 347 352 347
   query74  10107   908989978997
   query75  3399269026582658
   query76  1796113010321032
   query77  492 275 266 266
   query78  10410   936393679363
   query79  1458595 577 577
   query80  878 424 428 424
   query81  511 235 242 235
   query82  1309116 118 116
   query83  180 136 137 136
   query84  284 70  66  66
   query85  878 293 291 291
   query86  347 308 253 253
   query87  4869467545924592
   query88  3405216321402140
   query89  413 290 289 289
   query90  2004184 178 178
   query91  146 102 115 102
   query92  63  47  50  47
   query93  1894528 536 528
   query94  809 289 285 285
   query95  358 241 242 241
   query96  614 277 286 277
   query97  2907275226622662
   query98  209 206 192 192
   query99  1749129613001296
   Total cold run time: 317208 ms
   Total hot run time: 195677 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 showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


doris-robot commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2452946438

   
   
   TPC-H: Total hot run time: 41181 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5bc566bc799b5f9bc3e658ef62701ca1981b75fd, 
data reload: false
   
   -- Round 1 --
   q1   17591   740972967296
   q2   2036161 179 161
   q3   10603   108312101083
   q4   10579   797 771 771
   q5   7735306230623062
   q6   233 147 145 145
   q7   1026619 607 607
   q8   9357193720401937
   q9   6669642564566425
   q10  7087239223902390
   q11  458 258 260 258
   q12  414 215 206 206
   q13  17776   299430062994
   q14  245 216 214 214
   q15  577 522 521 521
   q16  637 580 591 580
   q17  960 578 536 536
   q18  7235682666626662
   q19  1343105510331033
   q20  459 184 189 184
   q21  4056321531023102
   q22  1084101910141014
   Total cold run time: 108160 ms
   Total hot run time: 41181 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7315730372587258
   q2   327 225 225 225
   q3   2970294129962941
   q4   2051190818201820
   q5   5765573557925735
   q6   221 143 143 143
   q7   2224180518031803
   q8   3409355834553455
   q9   8974898788948894
   q10  3608356536063565
   q11  600 513 509 509
   q12  841 640 618 618
   q13  10293   325531903190
   q14  303 266 278 266
   q15  572 536 523 523
   q16  691 648 651 648
   q17  1827161816231618
   q18  8185772075557555
   q19  1700164614921492
   q20  2123185118921851
   q21  5442546454565456
   q22  1147107510381038
   Total cold run time: 70588 ms
   Total hot run time: 60603 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 showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


Vallishp commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2452937338

   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



[PR] [Enhancement] (nereids)implement showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


Vallishp opened a new pull request, #43135:
URL: https://github.com/apache/doris/pull/43135

   ### What problem does this PR solve?
   
   support show storage engine in nereids
   
   Issue Number: close #42734 
   
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Check List (For Committer)
   
   - Test 
   
   - [ ] Regression test
   - [ ] Unit Test
   - [ ] Manual test (add detailed scripts or steps below)
   - [ ] No need to test or manual test. Explain why:
   - [ ] This is a refactor/code format and no logic has been changed.
   - [ ] Previous test can cover this change.
   - [ ] No colde files have been changed.
   - [ ] Other reason 
   
   
   mysql> show  engines;
   
+---+-+---+--+--++
   | Engine| Support | Comment   | 
Transactions | XA   | Savepoints |
   
+---+-+---+--+--++
   | Olap engine   | YES | Default storage engine of palo| NO   
| NO   | NO |
   | MySQL | YES | MySQL server which data is in it  | NO   
| NO   | NO |
   | ELASTICSEARCH | YES | ELASTICSEARCH cluster which data is in it | NO   
| NO   | NO |
   | HIVE  | YES | HIVE database which data is in it | NO   
| NO   | NO |
   | ICEBERG   | YES | ICEBERG data lake which data is in it | NO   
| NO   | NO |
   | ODBC  | YES | ODBC driver which data we can connect | NO   
| NO   | NO |
   | HUDI  | YES | HUDI data lake which data is in it| NO   
| NO   | NO |
   
+---+-+---+--+--++
   7 rows in set (0.00 sec)
   
   mysql> show storage engines;
   
+---+-+---+--+--++
   | Engine| Support | Comment   | 
Transactions | XA   | Savepoints |
   
+---+-+---+--+--++
   | Olap engine   | YES | Default storage engine of palo| NO   
| NO   | NO |
   | MySQL | YES | MySQL server which data is in it  | NO   
| NO   | NO |
   | ELASTICSEARCH | YES | ELASTICSEARCH cluster which data is in it | NO   
| NO   | NO |
   | HIVE  | YES | HIVE database which data is in it | NO   
| NO   | NO |
   | ICEBERG   | YES | ICEBERG data lake which data is in it | NO   
| NO   | NO |
   | ODBC  | YES | ODBC driver which data we can connect | NO   
| NO   | NO |
   | HUDI  | YES | HUDI data lake which data is in it| NO   
| NO   | NO |
   
+---+-+---+--+--++
   7 rows in set (0.00 sec)
   
   - Behavior changed:
   
   - [ ] No.
   - [ ] Yes. 
   
   - Does this need documentation?
   
   - [ ] No.
   - [ ] Yes. 
   
   - Release note
   
   
   
   None
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label 
   
   


-- 
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 showStorageEnginesCommand in nereids [doris]

2024-11-02 Thread via GitHub


doris-robot commented on PR #43135:
URL: https://github.com/apache/doris/pull/43135#issuecomment-2452937322

   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