Re: [PR] [opt](hash_join) Merging all build blocks at once will cause performance issue [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174220 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 34af1619476c952e9e29c256726cfb9ca4cffd96, 
data reload: false
   
   query1   916 371 366 366
   query2   6459241723462346
   query3   6679207 221 207
   query4   28543   17355   17313   17313
   query5   4191539 492 492
   query6   270 176 197 176
   query7   4588304 290 290
   query8   338 305 293 293
   query9   8452239223732373
   query10  446 296 280 280
   query11  12825   999199179917
   query12  138 87  86  86
   query13  1638385 370 370
   query14  10268   762277147622
   query15  245 192 188 188
   query16  7822315 311 311
   query17  1552572 531 531
   query18  1990279 276 276
   query19  198 149 154 149
   query20  91  83  90  83
   query21  213 133 132 132
   query22  4465413440454045
   query23  33711   33183   33241   33183
   query24  12121   290328452845
   query25  670 370 373 370
   query26  1790154 160 154
   query27  2974274 275 274
   query28  7584206120632061
   query29  1128637 628 628
   query30  298 153 176 153
   query31  957 732 743 732
   query32  88  56  62  56
   query33  773 307 305 305
   query34  947 496 494 494
   query35  685 590 589 589
   query36  1122954 946 946
   query37  211 89  82  82
   query38  2964275127362736
   query39  843 802 807 802
   query40  289 124 124 124
   query41  53  51  55  51
   query42  120 101 104 101
   query43  600 559 574 559
   query44  1266761 744 744
   query45  202 168 173 168
   query46  1102727 728 727
   query47  1819174217981742
   query48  405 297 301 297
   query49  1190419 424 419
   query50  796 416 411 411
   query51  6962686667176717
   query52  106 96  96  96
   query53  365 296 301 296
   query54  1039467 459 459
   query55  75  77  77  77
   query56  296 274 275 274
   query57  1127104610471046
   query58  269 271 266 266
   query59  3440326731663166
   query60  310 319 293 293
   query61  99  94  97  94
   query62  832 651 640 640
   query63  327 298 300 298
   query64  10463   230116821682
   query65  3445313731283128
   query66  1391356 349 349
   query67  15532   14829   14909   14829
   query68  4618553 556 553
   query69  480 334 332 332
   query70  1182106911561069
   query71  408 290 289 289
   query72  7605613156185618
   query73  765 332 328 328
   query74  5888549754505450
   query75  3589271627062706
   query76  2755969 940 940
   query77  493 320 327 320
   query78  10133   895389098909
   query79  3930536 533 533
   query80  1845499 503 499
   query81  581 226 228 226
   query82  1070145 136 136
   query83  328 175 181 175
   query84  281 94  94  94
   query85  1948388 303 303
   query86  473 322 316 316
   query87  3254311331813113
   query88  4484246324642463
   query89  497 389 386 386
   query90  1852194 191 191
   query91  133 104 104 104
   query92  67  51  53  51
   query93  5174525 525 525
   query94  1074217 215 215
   query95  414 320 317 317
   query96  621 269 272 269
   query97  3204302630733026
   query98  219 206 196 196
   query99  1685126412591259
   Total cold run time: 296163 ms
   Total hot run time: 174220 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

Re: [PR] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [fix](catalog)Fix internal program error causing client to get stuck [doris]

2024-07-10 Thread via GitHub


zddr commented on PR #37551:
URL: https://github.com/apache/doris/pull/37551#issuecomment-2219714243

   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] [opt](hash_join) Merging all build blocks at once will cause performance issue [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.4 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 34af1619476c952e9e29c256726cfb9ca4cffd96, 
data reload: false
   
   query1   0.040.040.04
   query2   0.080.040.04
   query3   0.230.060.05
   query4   1.680.080.08
   query5   0.490.490.48
   query6   1.140.730.73
   query7   0.020.020.02
   query8   0.060.040.04
   query9   0.560.510.49
   query10  0.560.540.55
   query11  0.150.110.12
   query12  0.140.120.12
   query13  0.600.580.60
   query14  0.790.800.77
   query15  0.870.840.83
   query16  0.340.360.36
   query17  1.011.021.05
   query18  0.240.230.22
   query19  1.921.881.74
   query20  0.010.010.01
   query21  15.40   0.800.67
   query22  4.187.551.68
   query23  18.32   1.331.21
   query24  2.100.220.22
   query25  0.140.080.09
   query26  0.320.200.21
   query27  0.460.240.23
   query28  13.29   1.021.00
   query29  12.62   3.283.29
   query30  0.250.060.06
   query31  2.870.380.38
   query32  3.300.470.46
   query33  2.862.932.89
   query34  16.82   4.324.35
   query35  4.414.484.41
   query36  0.650.460.47
   query37  0.190.150.15
   query38  0.160.160.14
   query39  0.040.040.04
   query40  0.160.130.12
   query41  0.100.040.04
   query42  0.050.050.05
   query43  0.050.040.05
   Total cold run time: 109.67 s
   Total hot run time: 30.4 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] [Refact](inverted index) refact no need read data opt logic [doris]

2024-07-10 Thread via GitHub


airborne12 commented on PR #36969:
URL: https://github.com/apache/doris/pull/36969#issuecomment-2219717452

   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] doris illegal label fix [doris-flink-connector]

2024-07-10 Thread via GitHub


monologuist commented on PR #421:
URL: 
https://github.com/apache/doris-flink-connector/pull/421#issuecomment-2219728231

   @JNSimba @CalvinKirs Hi, can you review my code? I think this is a problem 
and needs to be fixed


-- 
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] [opt](MultiCast) Avoid copying while holding a lock [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40394 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit cec03f335dac54affad7780054489dafe6d17783, 
data reload: false
   
   -- Round 1 --
   q1   18052   452343924392
   q2   2331188 188 188
   q3   10454   119211901190
   q4   10196   855 771 771
   q5   7496266426482648
   q6   220 142 142 142
   q7   951 621 606 606
   q8   9238205220762052
   q9   9060651765096509
   q10  8783378337533753
   q11  465 247 242 242
   q12  401 237 240 237
   q13  17816   302029682968
   q14  275 233 220 220
   q15  522 491 494 491
   q16  507 378 386 378
   q17  971 769 737 737
   q18  8130749373797379
   q19  2530160315081508
   q20  671 316 321 316
   q21  5030332739193327
   q22  413 347 340 340
   Total cold run time: 114512 ms
   Total hot run time: 40394 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4341427442554255
   q2   376 266 266 266
   q3   3003272727592727
   q4   1894160916381609
   q5   5269526852675267
   q6   225 133 135 133
   q7   2136172717231723
   q8   3223333533013301
   q9   8396834683978346
   q10  3864368137033681
   q11  588 492 503 492
   q12  791 609 583 583
   q13  16369   299630222996
   q14  320 258 253 253
   q15  517 484 484 484
   q16  493 434 430 430
   q17  1767150114971497
   q18  7805764073967396
   q19  1674152216051522
   q20  2036181417871787
   q21  4885476647844766
   q22  636 582 554 554
   Total cold run time: 70608 ms
   Total hot run time: 54068 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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


dataroaring commented on PR #37593:
URL: https://github.com/apache/doris/pull/37593#issuecomment-2219743801

   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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   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] [fix](mtmv)fix mtmv task nereids cost too much time [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.69 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 4767136c1fd1c20cd9ebd40008bced308dd6196b, 
data reload: false
   
   query1   0.040.030.04
   query2   0.080.040.04
   query3   0.230.040.05
   query4   1.690.070.07
   query5   0.480.470.52
   query6   1.160.730.72
   query7   0.020.020.01
   query8   0.040.040.04
   query9   0.540.510.49
   query10  0.550.540.55
   query11  0.140.110.12
   query12  0.150.120.12
   query13  0.620.590.59
   query14  0.760.780.77
   query15  0.860.810.81
   query16  0.360.380.37
   query17  1.030.980.99
   query18  0.240.230.22
   query19  1.921.841.83
   query20  0.010.010.01
   query21  15.42   0.770.67
   query22  4.516.052.76
   query23  18.32   1.451.33
   query24  2.140.230.21
   query25  0.160.090.08
   query26  0.300.210.21
   query27  0.450.230.24
   query28  13.24   1.021.00
   query29  12.58   3.363.30
   query30  0.260.060.05
   query31  2.870.390.37
   query32  3.300.490.47
   query33  2.852.982.92
   query34  16.84   4.354.38
   query35  4.474.434.51
   query36  0.650.500.47
   query37  0.190.160.15
   query38  0.160.140.15
   query39  0.040.030.04
   query40  0.150.120.12
   query41  0.090.050.05
   query42  0.070.050.05
   query43  0.050.040.04
   Total cold run time: 110.03 s
   Total hot run time: 31.69 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



[PR] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


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

   ## Proposed changes
   
   before
   ```
   mysql [test10]>select cast(f64 as string) from nums;
   +--+
   | ReturnedRows |
   +--+
   | 2000 |
   +--+
   1 row in set (0.48 sec)
   
   mysql [test10]>select cast(f32 as string) from nums;
   +--+
   | ReturnedRows |
   +--+
   | 2000 |
   +--+
   1 row in set (0.98 sec)
   
   ```
   
   now
   ```
   mysql [test10]>select cast(f64 as string) from nums;
   +--+
   | ReturnedRows |
   +--+
   | 2000 |
   +--+
   1 row in set (0.42 sec)
   
   mysql [test10]>select cast(f32 as string) from nums;
   +--+
   | ReturnedRows |
   +--+
   | 2000 |
   +--+
   1 row in set (0.43 sec)
   ```
   
   
   
   


-- 
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] [opt](compaction) Add logs for update delete bitmap info in cloud compaction [doris]

2024-07-10 Thread via GitHub


bobhan1 commented on PR #37558:
URL: https://github.com/apache/doris/pull/37558#issuecomment-2219710136

   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] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


Mryange commented on PR #37592:
URL: https://github.com/apache/doris/pull/37592#issuecomment-2219713908

   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] [fix](mtmv)fix mtmv task nereids cost too much time [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39970 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 4767136c1fd1c20cd9ebd40008bced308dd6196b, 
data reload: false
   
   -- Round 1 --
   q1   17621   439042874287
   q2   2026189 182 182
   q3   10457   124510471047
   q4   10201   765 790 765
   q5   7546263326422633
   q6   220 141 137 137
   q7   953 603 612 603
   q8   9221207220922072
   q9   9002657665426542
   q10  9030377637203720
   q11  460 229 232 229
   q12  445 241 247 241
   q13  17781   298330072983
   q14  271 226 224 224
   q15  525 489 483 483
   q16  523 379 378 378
   q17  971 756 674 674
   q18  7897755674997499
   q19  7106140714991407
   q20  679 331 329 329
   q21  4989318740533187
   q22  425 348 353 348
   Total cold run time: 118349 ms
   Total hot run time: 39970 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4498439244084392
   q2   374 285 282 282
   q3   3211308730833083
   q4   2079187618681868
   q5   5728565654625462
   q6   224 139 143 139
   q7   2260190818341834
   q8   3344349634213421
   q9   8700875286778677
   q10  4163368838343688
   q11  583 494 496 494
   q12  805 652 648 648
   q13  16116   313832393138
   q14  298 290 273 273
   q15  531 495 499 495
   q16  494 428 420 420
   q17  1807152514991499
   q18  8219804978697869
   q19  1834165716471647
   q20  2686186818701868
   q21  9156471948204719
   q22  632 579 552 552
   Total cold run time: 77742 ms
   Total hot run time: 56468 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] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 49582 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e39cf9f4ac4efc17d111408afda61a5fd461bb3a, 
data reload: false
   
   -- Round 1 --
   q1   17990   441943294329
   q2   2060152 144 144
   q3   10274   185618931856
   q4   10357   121013451210
   q5   8861385239213852
   q6   234 125 125 125
   q7   2034157816161578
   q8   9322271926902690
   q9   10644   10369   10120   10120
   q10  8637352335223522
   q11  414 248 244 244
   q12  473 308 291 291
   q13  18373   398840343988
   q14  370 331 329 329
   q15  505 462 467 462
   q16  679 577 573 573
   q17  1129979 955 955
   q18  7157689268916891
   q19  1771169116161616
   q20  515 314 313 313
   q21  4441412640564056
   q22  535 438 449 438
   Total cold run time: 116775 ms
   Total hot run time: 49582 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4288428643094286
   q2   316 230 229 229
   q3   4172414140904090
   q4   2728274527482745
   q5   7120708070837080
   q6   235 122 117 117
   q7   3230282828602828
   q8   4356448844754475
   q9   16908   16754   16830   16754
   q10  4228425542814255
   q11  774 699 686 686
   q12  1018844 848 844
   q13  6437373737093709
   q14  461 419 422 419
   q15  508 459 454 454
   q16  736 681 694 681
   q17  3853385338283828
   q18  8832869287498692
   q19  1735171416861686
   q20  2411214621242124
   q21  8664846584678465
   q22  1051962 992 962
   Total cold run time: 84061 ms
   Total hot run time: 79409 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] [opt](MultiCast) Avoid copying while holding a lock [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 173064 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 cec03f335dac54affad7780054489dafe6d17783, 
data reload: false
   
   query1   924 371 361 361
   query2   6477245023312331
   query3   6650217 217 217
   query4   28424   17659   17389   17389
   query5   4191498 496 496
   query6   281 189 168 168
   query7   4594292 284 284
   query8   317 283 287 283
   query9   8452241523732373
   query10  430 285 262 262
   query11  12080   991310030   9913
   query12  132 90  82  82
   query13  1643377 375 375
   query14  10367   690070356900
   query15  250 189 189 189
   query16  7231327 305 305
   query17  1364537 547 537
   query18  1899272 277 272
   query19  187 150 148 148
   query20  88  84  79  79
   query21  207 127 128 127
   query22  4358410341204103
   query23  33796   33010   33131   33010
   query24  12234   284928272827
   query25  652 369 416 369
   query26  1825151 150 150
   query27  2970270 274 270
   query28  7568207020472047
   query29  1175639 602 602
   query30  283 148 146 146
   query31  991 737 729 729
   query32  101 53  53  53
   query33  776 319 300 300
   query34  935 498 495 495
   query35  669 558 569 558
   query36  1129939 924 924
   query37  203 77  78  77
   query38  2878274427212721
   query39  860 823 795 795
   query40  281 120 122 120
   query41  53  50  52  50
   query42  118 99  99  99
   query43  576 568 546 546
   query44  1246746 776 746
   query45  189 160 162 160
   query46  1068713 728 713
   query47  1882173817821738
   query48  373 295 309 295
   query49  1204425 414 414
   query50  773 395 396 395
   query51  6918685067336733
   query52  107 90  97  90
   query53  355 291 288 288
   query54  984 460 442 442
   query55  76  78  72  72
   query56  289 256 270 256
   query57  1138105710521052
   query58  270 237 253 237
   query59  3465320031873187
   query60  301 275 313 275
   query61  98  100 97  97
   query62  831 649 648 648
   query63  327 298 286 286
   query64  10584   219416321632
   query65  3217310830933093
   query66  1424374 346 346
   query67  15442   14942   15046   14942
   query68  4610544 548 544
   query69  468 327 319 319
   query70  1156113411831134
   query71  409 276 276 276
   query72  7117594155975597
   query73  750 332 329 329
   query74  5897546755305467
   query75  3401272726852685
   query76  2297947 965 947
   query77  449 317 293 293
   query78  9653889488968894
   query79  3008530 525 525
   query80  2074491 469 469
   query81  576 223 226 223
   query82  727 133 143 133
   query83  278 168 169 168
   query84  276 88  90  88
   query85  2125323 297 297
   query86  490 321 322 321
   query87  3300312131223121
   query88  4543246624702466
   query89  491 383 397 383
   query90  1844188 188 188
   query91  128 104 104 104
   query92  59  49  49  49
   query93  4888519 515 515
   query94  1264208 211 208
   query95  408 323 315 315
   query96  615 273 269 269
   query97  3167304130563041
   query98  221 199 197 197
   query99  1573128712801280
   Total cold run time: 291442 ms
   Total hot run time: 173064 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 

Re: [PR] [feature](mtmv) Support querying rewrite by materialized view when DML such as insert and insert overwrite [doris]

2024-07-10 Thread via GitHub


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

   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] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


w41ter commented on PR #37415:
URL: https://github.com/apache/doris/pull/37415#issuecomment-2219733055

   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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   Query following createting table would throw table not exist error.
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   


-- 
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] [opt](Nereids) Add object ID in expression and use it as hash code [doris]

2024-07-10 Thread via GitHub


XieJiann commented on PR #37538:
URL: https://github.com/apache/doris/pull/37538#issuecomment-2219742140

   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] [feature](Vault) Support alter s3 storage vault using http interface [doris]

2024-07-10 Thread via GitHub


ByteYue commented on PR #37537:
URL: https://github.com/apache/doris/pull/37537#issuecomment-2219739950

   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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   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] [enhance](mtmv)MTMV support refresh by time range [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39651 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 02acdd3fad65881540ffed80e888a6da238e1b19, 
data reload: false
   
   -- Round 1 --
   q1   17602   437242574257
   q2   2005189 181 181
   q3   10448   122410901090
   q4   10190   786 869 786
   q5   7484263226272627
   q6   217 137 133 133
   q7   960 595 614 595
   q8   9224208520502050
   q9   9009651165076507
   q10  8948373937353735
   q11  457 234 235 234
   q12  435 222 224 222
   q13  17773   297829642964
   q14  266 228 230 228
   q15  517 482 484 482
   q16  504 372 371 371
   q17  954 696 727 696
   q18  7913740673197319
   q19  6122143014021402
   q20  668 321 338 321
   q21  4942312531193119
   q22  389 336 332 332
   Total cold run time: 117027 ms
   Total hot run time: 39651 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4415426742744267
   q2   369 266 270 266
   q3   2930277628572776
   q4   1993173516991699
   q5   5645547054705470
   q6   229 139 136 136
   q7   2227188118791879
   q8   3294337334343373
   q9   8636868187828681
   q10  4092382337503750
   q11  606 507 514 507
   q12  825 641 671 641
   q13  16246   311131583111
   q14  304 268 268 268
   q15  534 493 491 491
   q16  489 437 433 433
   q17  1815153915041504
   q18  8070801578687868
   q19  1825151115531511
   q20  2592189518561856
   q21  5141481246774677
   q22  649 554 602 554
   Total cold run time: 72926 ms
   Total hot run time: 55718 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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [regression-test](group commit) enable wait_internal_group_commit_finish [doris]

2024-07-10 Thread via GitHub


mymeiyi commented on PR #26856:
URL: https://github.com/apache/doris/pull/26856#issuecomment-2219762971

   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-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] [fix](mtmv)fix mtmv task nereids cost too much time [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174127 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 4767136c1fd1c20cd9ebd40008bced308dd6196b, 
data reload: false
   
   query1   896 370 361 361
   query2   6359255024172417
   query3   6636206 212 206
   query4   23773   17510   17409   17409
   query5   3778496 488 488
   query6   262 174 188 174
   query7   4593314 283 283
   query8   303 299 295 295
   query9   8489238723652365
   query10  439 295 266 266
   query11  10693   993010056   9930
   query12  115 86  83  83
   query13  1662374 383 374
   query14  9974783575097509
   query15  236 186 178 178
   query16  7597305 309 305
   query17  1812555 527 527
   query18  1233271 270 270
   query19  192 180 157 157
   query20  95  88  83  83
   query21  203 130 130 130
   query22  4403415440034003
   query23  34068   33903   33561   33561
   query24  10775   297728232823
   query25  618 387 388 387
   query26  693 147 147 147
   query27  2253278 274 274
   query28  5829213121072107
   query29  896 657 636 636
   query30  277 150 153 150
   query31  978 738 789 738
   query32  99  52  52  52
   query33  656 304 305 304
   query34  892 492 499 492
   query35  674 591 580 580
   query36  1132979 973 973
   query37  143 85  86  85
   query38  2973287028252825
   query39  940 817 789 789
   query40  202 122 119 119
   query41  54  52  52  52
   query42  114 100 101 100
   query43  590 543 557 543
   query44  1144739 751 739
   query45  207 161 165 161
   query46  1085728 710 710
   query47  1846176417671764
   query48  384 307 293 293
   query49  841 427 410 410
   query50  780 397 406 397
   query51  6785671767706717
   query52  106 95  90  90
   query53  356 285 284 284
   query54  861 455 444 444
   query55  76  78  74  74
   query56  294 254 267 254
   query57  1128103710611037
   query58  245 269 258 258
   query59  3416319032603190
   query60  324 283 285 283
   query61  94  93  93  93
   query62  815 647 643 643
   query63  316 283 280 280
   query64  9147219616441644
   query65  3128310730783078
   query66  718 332 324 324
   query67  15450   15437   15055   15055
   query68  4533535 539 535
   query69  523 447 335 335
   query70  1189111011581110
   query71  416 290 274 274
   query72  7128575052615261
   query73  745 328 322 322
   query74  5929557355315531
   query75  3339267926682668
   query76  2177950 981 950
   query77  462 292 300 292
   query78  9581890888528852
   query79  2638512 502 502
   query80  2406486 484 484
   query81  590 221 213 213
   query82  1443145 136 136
   query83  278 165 166 165
   query84  257 92  84  84
   query85  1398321 305 305
   query86  462 310 321 310
   query87  3260309731153097
   query88  3708245424552454
   query89  483 387 379 379
   query90  1730188 189 188
   query91  131 104 99  99
   query92  57  49  52  49
   query93  2451514 510 510
   query94  1126212 213 212
   query95  404 317 330 317
   query96  600 278 269 269
   query97  3203300931193009
   query98  226 208 199 199
   query99  1487126812441244
   Total cold run time: 272505 ms
   Total hot run time: 174127 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 

Re: [PR] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 50099 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8a9934f3ac734f2b06b4f108f294b87c817a0ef8, 
data reload: false
   
   -- Round 1 --
   q1   5082439843914391
   q2   759 201 152 152
   q3   2099192319241923
   q4   2651131713071307
   q5   4022386440513864
   q6   236 124 132 124
   q7   2063160016401600
   q8   2793275427162716
   q9   10679   10501   10277   10277
   q10  5265354735103510
   q11  378 251 246 246
   q12  462 305 300 300
   q13  4490402640564026
   q14  364 326 336 326
   q15  510 465 471 465
   q16  645 578 591 578
   q17  1116957 976 957
   q18  7248684869316848
   q19  1778165716381638
   q20  554 314 298 298
   q21  4461413441054105
   q22  546 448 449 448
   Total cold run time: 58201 ms
   Total hot run time: 50099 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4338430242814281
   q2   316 223 232 223
   q3   4195410441664104
   q4   2765273427432734
   q5   7217712671097109
   q6   237 121 119 119
   q7   3249286027702770
   q8   4400448945224489
   q9   16882   16661   16769   16661
   q10  4228425142824251
   q11  754 686 663 663
   q12  1017861 860 860
   q13  4144377736933693
   q14  448 418 420 418
   q15  515 446 462 446
   q16  727 676 666 666
   q17  3878386337623762
   q18  8792874787458745
   q19  1741174816931693
   q20  2348213120922092
   q21  8584845285298452
   q22  1141108010581058
   Total cold run time: 81916 ms
   Total hot run time: 79289 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] [opt](compaction) Add logs for update delete bitmap info in cloud compaction [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40976 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 082733f2edc7393db16194e191899ea2e48feabc, 
data reload: false
   
   -- Round 1 --
   q1   18455   447243424342
   q2   2024196 187 187
   q3   10452   124411021102
   q4   10195   845 844 844
   q5   7494263326342633
   q6   224 143 140 140
   q7   970 610 613 610
   q8   9225208020692069
   q9   8640650664926492
   q10  8836373137243724
   q11  453 250 240 240
   q12  397 239 244 239
   q13  17957   297629852976
   q14  270 229 228 228
   q15  532 501 485 485
   q16  495 398 370 370
   q17  974 684 745 684
   q18  8116751274557455
   q19  2928156515991565
   q20  707 332 346 332
   q21  4920391339343913
   q22  400 346 353 346
   Total cold run time: 114664 ms
   Total hot run time: 40976 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4339433742434243
   q2   374 264 255 255
   q3   3007279827522752
   q4   1899159415771577
   q5   5282528853135288
   q6   215 134 134 134
   q7   2089169117161691
   q8   3199338633313331
   q9   8383836883338333
   q10  3881367436843674
   q11  594 510 495 495
   q12  797 638 603 603
   q13  17514   300729992999
   q14  307 285 275 275
   q15  516 485 482 482
   q16  472 415 442 415
   q17  1778151114931493
   q18  7683759773657365
   q19  1692168715551555
   q20  2038179917641764
   q21  4876482748974827
   q22  657 556 567 556
   Total cold run time: 71592 ms
   Total hot run time: 54107 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] [opt](MultiCast) Avoid copying while holding a lock [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.14 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit cec03f335dac54affad7780054489dafe6d17783, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.040.04
   query3   0.220.050.04
   query4   1.680.070.07
   query5   0.500.470.48
   query6   1.150.730.72
   query7   0.020.020.01
   query8   0.050.040.04
   query9   0.550.500.49
   query10  0.560.550.55
   query11  0.150.110.12
   query12  0.150.130.12
   query13  0.600.590.59
   query14  0.760.780.79
   query15  0.860.820.81
   query16  0.350.380.37
   query17  1.010.990.97
   query18  0.230.210.22
   query19  1.751.701.82
   query20  0.010.000.01
   query21  15.43   0.800.67
   query22  4.066.892.48
   query23  18.32   1.351.26
   query24  2.100.230.22
   query25  0.170.090.09
   query26  0.280.210.20
   query27  0.440.230.22
   query28  13.31   1.031.00
   query29  12.89   3.283.27
   query30  0.260.060.05
   query31  2.880.390.39
   query32  3.270.480.47
   query33  2.922.912.86
   query34  17.04   4.394.47
   query35  4.474.434.48
   query36  0.650.460.50
   query37  0.180.160.16
   query38  0.160.150.14
   query39  0.040.030.03
   query40  0.140.120.11
   query41  0.090.050.04
   query42  0.050.040.05
   query43  0.050.050.04
   Total cold run time: 109.92 s
   Total hot run time: 31.14 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



[PR] [cherry-pick](branch-2.1) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table (#35917)" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian opened a new pull request, #37594:
URL: https://github.com/apache/doris/pull/37594

   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   Pick #35917 and #37151 
   


-- 
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] [cherry-pick](branch-2.1) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table (#35917)" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian commented on PR #37594:
URL: https://github.com/apache/doris/pull/37594#issuecomment-2219762441

   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] [cherry-pick](branch-2.1) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table (#35917)" [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [test](statistics)Add test case for set global variables. [doris]

2024-07-10 Thread via GitHub


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

   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] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 37.89% (8116/21420) 
Line Coverage: 29.55% (66498/225009)
Region Coverage: 29.03% (34277/118093)
Branch Coverage: 24.89% (17606/70724)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/8a9934f3ac734f2b06b4f108f294b87c817a0ef8_8a9934f3ac734f2b06b4f108f294b87c817a0ef8/report/index.html


-- 
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] [opt](compaction) Add logs for update delete bitmap info in cloud compaction [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174115 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 082733f2edc7393db16194e191899ea2e48feabc, 
data reload: false
   
   query1   913 380 365 365
   query2   6465245223882388
   query3   6654205 222 205
   query4   28651   17550   17475   17475
   query5   4214503 499 499
   query6   284 182 182 182
   query7   4600295 295 295
   query8   330 304 306 304
   query9   8538240323892389
   query10  433 291 276 276
   query11  11860   10148   10077   10077
   query12  144 88  85  85
   query13  1654393 386 386
   query14  10209   701478787014
   query15  276 181 182 181
   query16  8146322 301 301
   query17  1795554 527 527
   query18  2109274 275 274
   query19  288 149 143 143
   query20  89  84  83  83
   query21  208 129 128 128
   query22  4489401940374019
   query23  33988   33082   33397   33082
   query24  10739   285428522852
   query25  616 361 368 361
   query26  1578151 153 151
   query27  2725268 273 268
   query28  7366204820562048
   query29  951 616 647 616
   query30  285 149 149 149
   query31  943 744 754 744
   query32  94  56  53  53
   query33  756 295 285 285
   query34  960 494 495 494
   query35  680 581 550 550
   query36  1085900 943 900
   query37  162 81  80  80
   query38  2850273227332732
   query39  863 845 827 827
   query40  281 121 122 121
   query41  53  51  55  51
   query42  119 98  104 98
   query43  589 585 566 566
   query44  1173732 731 731
   query45  194 164 160 160
   query46  1076745 709 709
   query47  1859174817871748
   query48  373 304 339 304
   query49  1173413 413 413
   query50  778 405 407 405
   query51  6922679367916791
   query52  110 97  95  95
   query53  368 301 295 295
   query54  970 451 452 451
   query55  80  74  73  73
   query56  304 263 269 263
   query57  1133106710701067
   query58  254 264 255 255
   query59  3417317433493174
   query60  307 285 285 285
   query61  127 97  90  90
   query62  823 651 660 651
   query63  332 303 297 297
   query64  10549   218074392180
   query65  3175341531053105
   query66  1396352 354 352
   query67  15584   15056   15100   15056
   query68  4577545 532 532
   query69  653 444 334 334
   query70  1216114611531146
   query71  409 288 288 288
   query72  7874529456965294
   query73  745 330 329 329
   query74  5869548655105486
   query75  3448273927112711
   query76  2978947 1010947
   query77  655 310 302 302
   query78  9422893888338833
   query79  2936528 523 523
   query80  2120482 485 482
   query81  579 220 218 218
   query82  953 140 136 136
   query83  322 173 170 170
   query84  277 95  91  91
   query85  1891311 309 309
   query86  486 338 295 295
   query87  3278308631153086
   query88  4210247124712471
   query89  483 388 385 385
   query90  1890198 202 198
   query91  221 103 106 103
   query92  65  52  49  49
   query93  3904515 523 515
   query94  1260224 216 216
   query95  412 323 329 323
   query96  598 273 271 271
   query97  3222305330353035
   query98  234 204 202 202
   query99  1684126112631261
   Total cold run time: 291380 ms
   Total hot run time: 174115 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

Re: [PR] [profile](rf) fix set error value in RuntimeFilterInfo [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40083 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 7ddb5c1057b5b1757848b6328d34126a21faa965, 
data reload: false
   
   -- Round 1 --
   q1   17618   433042904290
   q2   2017193 188 188
   q3   10446   114010791079
   q4   10329   764 743 743
   q5   7501265026372637
   q6   217 140 139 139
   q7   959 603 613 603
   q8   9540207620932076
   q9   9015657265396539
   q10  9028373037193719
   q11  462 237 240 237
   q12  496 228 236 228
   q13  19860   296130532961
   q14  284 232 228 228
   q15  537 500 499 499
   q16  532 400 378 378
   q17  978 653 656 653
   q18  8027750074637463
   q19  7813152114441444
   q20  732 339 321 321
   q21  5098329241803292
   q22  436 368 366 366
   Total cold run time: 121925 ms
   Total hot run time: 40083 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4562439344214393
   q2   398 285 304 285
   q3   3304309931203099
   q4   2037170317801703
   q5   5517546156145461
   q6   227 137 133 133
   q7   2263187218521852
   q8   3322344234083408
   q9   8679879586568656
   q10  3885380638843806
   q11  582 492 508 492
   q12  785 621 644 621
   q13  16089   322832003200
   q14  297 262 276 262
   q15  516 484 464 464
   q16  498 439 422 422
   q17  1829151914991499
   q18  8201794179407940
   q19  1805165617261656
   q20  2905187718541854
   q21  7076480248714802
   q22  636 565 559 559
   Total cold run time: 75413 ms
   Total hot run time: 56567 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



[PR] [fix](group commit) Fix some group commit problems [doris]

2024-07-10 Thread via GitHub


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

   ## Proposed changes
   
   Fix some problems found by https://github.com/apache/doris/pull/26856/files
   
   1. 
   


-- 
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] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39806 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5687dc8fc0cd44100adfd8cf96f7fc3041270dda, 
data reload: false
   
   -- Round 1 --
   q1   17625   434042854285
   q2   2016189 190 189
   q3   10454   124211851185
   q4   10189   760 737 737
   q5   7492266426122612
   q6   221 136 135 135
   q7   964 594 603 594
   q8   9235206320882063
   q9   8905644964786449
   q10  8958374836893689
   q11  444 230 234 230
   q12  529 220 225 220
   q13  17976   296529602960
   q14  256 226 218 218
   q15  513 472 478 472
   q16  494 373 370 370
   q17  971 716 758 716
   q18  8022737675717376
   q19  3825151714691469
   q20  671 310 325 310
   q21  4922319332413193
   q22  396 334 334 334
   Total cold run time: 115078 ms
   Total hot run time: 39806 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4393428842864286
   q2   372 270 269 269
   q3   3004272228002722
   q4   1971170916841684
   q5   5558551654735473
   q6   221 130 130 130
   q7   2166181918531819
   q8   3268342634183418
   q9   8666865587968655
   q10  4086387737233723
   q11  593 476 488 476
   q12  818 648 666 648
   q13  16639   313831783138
   q14  308 259 295 259
   q15  512 484 470 470
   q16  482 438 437 437
   q17  1791153215081508
   q18  8056806576357635
   q19  1768168614951495
   q20  2077187118561856
   q21  5059493247604760
   q22  645 559 541 541
   Total cold run time: 72453 ms
   Total hot run time: 55402 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] [fix](group commit) Fix some group commit problems [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [fix](catalog)Fix internal program error causing client to get stuck [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39660 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 491200172045abd3703b81398a3f39a21e76cd48, 
data reload: false
   
   -- Round 1 --
   q1   17629   432842634263
   q2   2027185 182 182
   q3   10492   113410641064
   q4   10187   778 814 778
   q5   7486263525782578
   q6   221 138 139 138
   q7   953 601 611 601
   q8   9250203320662033
   q9   8766698164646464
   q10  8961374437193719
   q11  451 241 246 241
   q12  451 226 230 226
   q13  17774   298829762976
   q14  269 220 229 220
   q15  513 481 494 481
   q16  498 380 379 379
   q17  952 623 706 623
   q18  8045741174197411
   q19  8048148914451445
   q20  695 316 334 316
   q21  4854319032423190
   q22  385 334 332 332
   Total cold run time: 118907 ms
   Total hot run time: 39660 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4421429842784278
   q2   382 273 282 273
   q3   3024290329612903
   q4   1967172817611728
   q5   5537554754455445
   q6   227 135 135 135
   q7   2251184618411841
   q8   3258345134293429
   q9   8661876687118711
   q10  4118372738133727
   q11  613 504 510 504
   q12  821 635 620 620
   q13  16324   315732153157
   q14  317 269 290 269
   q15  537 487 483 483
   q16  476 443 424 424
   q17  1814151915121512
   q18  8133803478367836
   q19  1804159316511593
   q20  2528186018601860
   q21  6521497949004900
   q22  611 515 553 515
   Total cold run time: 74345 ms
   Total hot run time: 56143 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] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


Lchangliang commented on PR #37596:
URL: https://github.com/apache/doris/pull/37596#issuecomment-2219779451

   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] [enhance](mtmv)MTMV support refresh by time range [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174288 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 02acdd3fad65881540ffed80e888a6da238e1b19, 
data reload: false
   
   query1   908 366 366 366
   query2   6438239724042397
   query3   6638204 210 204
   query4   23718   17565   17525   17525
   query5   3746480 485 480
   query6   251 192 172 172
   query7   4593291 289 289
   query8   322 301 314 301
   query9   8499239023582358
   query10  432 295 271 271
   query11  10741   10080   10272   10080
   query12  113 89  83  83
   query13  1661385 379 379
   query14  10167   776977187718
   query15  237 188 187 187
   query16  7806301 296 296
   query17  1838546 513 513
   query18  1921273 287 273
   query19  197 145 153 145
   query20  93  84  88  84
   query21  208 129 125 125
   query22  4723423541804180
   query23  34018   33432   33473   33432
   query24  10619   291428692869
   query25  583 393 399 393
   query26  709 149 145 145
   query27  2199277 284 277
   query28  6231213521212121
   query29  922 639 619 619
   query30  258 154 150 150
   query31  989 758 741 741
   query32  98  50  54  50
   query33  659 316 280 280
   query34  904 511 495 495
   query35  678 586 572 572
   query36  1136971 951 951
   query37  145 83  86  83
   query38  2960281527892789
   query39  897 877 810 810
   query40  205 121 116 116
   query41  56  50  49  49
   query42  114 95  101 95
   query43  580 571 558 558
   query44  1072733 744 733
   query45  195 157 162 157
   query46  1068747 710 710
   query47  1878176518091765
   query48  385 307 297 297
   query49  851 404 420 404
   query50  781 386 389 386
   query51  6843679266846684
   query52  112 89  91  89
   query53  360 290 282 282
   query54  867 450 446 446
   query55  74  72  73  72
   query56  302 253 271 253
   query57  1160103710491037
   query58  248 250 244 244
   query59  3459314232513142
   query60  306 294 273 273
   query61  94  121 98  98
   query62  799 639 655 639
   query63  325 286 287 286
   query64  9200217316151615
   query65  3152309330803080
   query66  744 324 329 324
   query67  15304   15122   14991   14991
   query68  4499535 550 535
   query69  526 411 323 323
   query70  1186115610591059
   query71  373 291 282 282
   query72  7058546151415141
   query73  743 321 318 318
   query74  5997550255105502
   query75  3337267626432643
   query76  2299924 956 924
   query77  451 295 313 295
   query78  9547905989938993
   query79  1787516 517 516
   query80  1916467 471 467
   query81  601 218 216 216
   query82  1052129 134 129
   query83  293 160 172 160
   query84  262 92  86  86
   query85  1117324 311 311
   query86  387 325 332 325
   query87  3266314330553055
   query88  3263246124492449
   query89  473 382 388 382
   query90  1650186 183 183
   query91  132 102 105 102
   query92  59  47  51  47
   query93  1463512 505 505
   query94  1046214 206 206
   query95  400 310 314 310
   query96  595 274 276 274
   query97  3184306430713064
   query98  225 209 200 200
   query99  1628125812981258
   Total cold run time: 270604 ms
   Total hot run time: 174288 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

Re: [PR] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


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

   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



[PR] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


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

   https://github.com/apache/doris/pull/34598
   
   


-- 
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] [Improve] Estimated column reader memory to control segment cache [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [Improve] Estimated column reader memory to control segment cache [doris]

2024-07-10 Thread via GitHub


Lchangliang commented on PR #37597:
URL: https://github.com/apache/doris/pull/37597#issuecomment-2219780603

   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] [opt](compaction) Add logs for update delete bitmap info in cloud compaction [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.56 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 082733f2edc7393db16194e191899ea2e48feabc, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.030.04
   query3   0.220.040.04
   query4   1.690.070.06
   query5   0.490.500.49
   query6   1.140.720.72
   query7   0.010.010.01
   query8   0.050.050.05
   query9   0.550.480.50
   query10  0.540.540.54
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.600.580.59
   query14  0.750.800.77
   query15  0.850.830.81
   query16  0.360.380.37
   query17  1.011.001.04
   query18  0.240.230.24
   query19  1.821.741.74
   query20  0.010.010.01
   query21  15.40   0.780.67
   query22  3.957.331.81
   query23  18.24   1.421.30
   query24  2.200.230.23
   query25  0.180.090.10
   query26  0.300.210.20
   query27  0.450.230.24
   query28  13.20   1.031.00
   query29  12.61   3.303.23
   query30  0.250.060.06
   query31  2.870.390.39
   query32  3.280.480.47
   query33  2.932.972.90
   query34  16.98   4.364.37
   query35  4.424.374.46
   query36  0.650.490.48
   query37  0.190.150.16
   query38  0.160.150.15
   query39  0.040.040.04
   query40  0.160.120.12
   query41  0.090.040.04
   query42  0.060.050.05
   query43  0.060.030.03
   Total cold run time: 109.42 s
   Total hot run time: 30.56 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] [fix](group commit) Fix some group commit problems [doris]

2024-07-10 Thread via GitHub


mymeiyi commented on PR #37595:
URL: https://github.com/apache/doris/pull/37595#issuecomment-2219783706

   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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40029 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 47ade42db98ceb6311e243f141682f859f38baa7, 
data reload: false
   
   -- Round 1 --
   q1   17852   448043794379
   q2   2668200 231 200
   q3   11546   114911271127
   q4   11247   851 814 814
   q5   7857271226322632
   q6   223 141 143 141
   q7   957 599 622 599
   q8   9235205621032056
   q9   8991650264526452
   q10  8841370536973697
   q11  457 240 247 240
   q12  402 236 236 236
   q13  19011   298730302987
   q14  278 246 232 232
   q15  535 487 480 480
   q16  498 396 388 388
   q17  964 685 684 684
   q18  8068745974337433
   q19  1911160914641464
   q20  691 325 326 325
   q21  4949311833083118
   q22  406 349 345 345
   Total cold run time: 117587 ms
   Total hot run time: 40029 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4350420642654206
   q2   386 275 275 275
   q3   2975271827422718
   q4   1844162616111611
   q5   5241527852855278
   q6   219 133 131 131
   q7   2155180317201720
   q8   3424332833043304
   q9   8221824782358235
   q10  3887366236203620
   q11  580 500 485 485
   q12  808 635 594 594
   q13  17409   305629752975
   q14  300 273 267 267
   q15  511 474 491 474
   q16  477 419 441 419
   q17  1776149314761476
   q18  7536760173587358
   q19  1692146014551455
   q20  1989178617891786
   q21  4997487348514851
   q22  629 541 551 541
   Total cold run time: 71406 ms
   Total hot run time: 53779 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] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 203419 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 8a9934f3ac734f2b06b4f108f294b87c817a0ef8, 
data reload: false
   
   query1   913 425 379 379
   query2   5961283226582658
   query3   6578208 202 202
   query4   19937   18137   17937   17937
   query5   18109   650265316502
   query6   282 219 227 219
   query7   4163302 307 302
   query8   462 472 386 386
   query9   3084266025922592
   query10  404 304 285 285
   query11  11293   10759   10803   10759
   query12  121 82  73  73
   query13  5634713 682 682
   query14  17357   13485   13924   13485
   query15  360 245 240 240
   query16  6456282 261 261
   query17  16821388882 882
   query18  2326411 407 407
   query19  204 147 153 147
   query20  79  81  79  79
   query21  190 94  98  94
   query22  5284508350715071
   query23  32616   31895   31927   31895
   query24  6973657665596559
   query25  513 425 425 425
   query26  529 161 158 158
   query27  1861294 289 289
   query28  6229235723102310
   query29  3044261526562615
   query30  246 169 164 164
   query31  896 742 735 735
   query32  70  65  60  60
   query33  401 269 265 265
   query34  842 471 466 466
   query35  1115939 941 939
   query36  1276125011181118
   query37  94  63  61  61
   query38  3095298229592959
   query39  1374134013241324
   query40  212 95  96  95
   query41  50  43  44  43
   query42  88  84  80  80
   query43  784 731 731 731
   query44  1123728 717 717
   query45  251 235 233 233
   query46  1226967 963 963
   query47  1918176016791679
   query48  1005707 711 707
   query49  626 374 373 373
   query50  871 601 618 601
   query51  4800465746564656
   query52  90  80  79  79
   query53  450 322 313 313
   query54  2640245425062454
   query55  90  95  78  78
   query56  227 222 210 210
   query57  1216105612571056
   query58  215 195 206 195
   query59  4106450339023902
   query60  215 221 217 217
   query61  96  93  95  93
   query62  797 505 483 483
   query63  491 331 333 331
   query64  2438149614651465
   query65  3638353035553530
   query66  762 375 374 374
   query67  18174   15311   15563   15311
   query68  9956642 637 637
   query69  581 331 337 331
   query70  1692140813591359
   query71  399 313 306 306
   query72  6486347734183418
   query73  734 333 322 322
   query74  6317584158165816
   query75  5315370536473647
   query76  6124106011141060
   query77  1024254 266 254
   query78  12719   11718   13503   11718
   query79  12668   653 623 623
   query80  1162391 396 391
   query81  488 233 236 233
   query82  900 95  95  95
   query83  166 137 129 129
   query84  260 70  71  70
   query85  882 328 331 328
   query86  353 338 293 293
   query87  3245306530243024
   query88  5506233223452332
   query89  417 284 298 284
   query90  1974214 208 208
   query91  178 139 151 139
   query92  61  50  53  50
   query93  5065550 551 550
   query94  750 205 206 205
   query95  1088106710351035
   query96  645 330 325 325
   query97  6441640962896289
   query98  192 181 170 170
   query99  2744825 885 825
   Total cold run time: 317184 ms
   Total hot run time: 203419 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 t

Re: [PR] [enhance](mtmv)MTMV support refresh by time range [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.6 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 02acdd3fad65881540ffed80e888a6da238e1b19, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.040.04
   query3   0.230.060.06
   query4   1.660.080.08
   query5   0.490.490.48
   query6   1.150.730.73
   query7   0.020.010.01
   query8   0.050.040.04
   query9   0.550.490.49
   query10  0.560.540.55
   query11  0.150.120.11
   query12  0.140.120.12
   query13  0.600.580.57
   query14  0.770.770.76
   query15  0.860.800.83
   query16  0.380.380.35
   query17  0.971.011.05
   query18  0.230.230.22
   query19  1.801.701.76
   query20  0.010.010.01
   query21  15.38   0.770.66
   query22  4.246.901.88
   query23  18.27   1.351.37
   query24  2.080.240.23
   query25  0.150.090.08
   query26  0.290.210.20
   query27  0.450.230.23
   query28  13.28   1.011.00
   query29  12.56   3.343.32
   query30  0.250.060.05
   query31  2.890.390.39
   query32  3.270.480.47
   query33  2.892.892.96
   query34  17.08   4.294.36
   query35  4.404.434.37
   query36  0.650.470.48
   query37  0.190.160.15
   query38  0.150.140.15
   query39  0.040.040.03
   query40  0.160.120.13
   query41  0.100.050.05
   query42  0.050.050.05
   query43  0.040.040.03
   Total cold run time: 109.6 s
   Total hot run time: 30.6 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] [pick](Variant) pick some refactor and fix [doris]

2024-07-10 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 36.34% (9156/25197) 
Line Coverage: 27.88% (74778/268242)
Region Coverage: 26.77% (38589/144128)
Branch Coverage: 23.47% (19557/83326)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/e787a3d118e01a7f9755c44381088afec1b4a1be_e787a3d118e01a7f9755c44381088afec1b4a1be/report/index.html


-- 
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] [profile](rf) fix set error value in RuntimeFilterInfo [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 175209 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 7ddb5c1057b5b1757848b6328d34126a21faa965, 
data reload: false
   
   query1   914 385 368 368
   query2   6346232623502326
   query3   6639210 218 210
   query4   28487   17405   17427   17405
   query5   3497487 501 487
   query6   278 168 167 167
   query7   4583302 285 285
   query8   332 308 303 303
   query9   8442238923532353
   query10  454 288 276 276
   query11  12175   996010091   9960
   query12  114 84  85  84
   query13  1641374 379 374
   query14  10414   786379617863
   query15  250 197 192 192
   query16  7775317 312 312
   query17  1808549 559 549
   query18  1908276 280 276
   query19  201 147 155 147
   query20  90  84  85  84
   query21  213 131 137 131
   query22  4213388938643864
   query23  34068   33793   33694   33694
   query24  10975   282228982822
   query25  650 405 389 389
   query26  1189156 152 152
   query27  3040297 286 286
   query28  7294214521232123
   query29  890 667 639 639
   query30  254 155 155 155
   query31  941 794 772 772
   query32  99  55  60  55
   query33  796 327 335 327
   query34  990 505 522 505
   query35  701 576 611 576
   query36  1151968 992 968
   query37  152 83  85  83
   query38  2919282328832823
   query39  860 805 824 805
   query40  207 121 123 121
   query41  53  52  52  52
   query42  116 99  103 99
   query43  577 572 560 560
   query44  1187736 753 736
   query45  191 161 161 161
   query46  1086729 733 729
   query47  1823176317771763
   query48  385 311 302 302
   query49  857 418 432 418
   query50  792 403 412 403
   query51  6949678767426742
   query52  117 90  111 90
   query53  371 306 298 298
   query54  887 481 473 473
   query55  78  76  79  76
   query56  307 291 292 291
   query57  1113103310621033
   query58  276 315 268 268
   query59  3725337834603378
   query60  306 287 281 281
   query61  112 96  92  92
   query62  801 646 622 622
   query63  331 301 300 300
   query64  9478218516311631
   query65  3208308131573081
   query66  759 332 332 332
   query67  15224   14970   14876   14876
   query68  6716547 548 547
   query69  664 459 383 383
   query70  1260116710881088
   query71  503 298 288 288
   query72  7490571556065606
   query73  834 327 324 324
   query74  5936549255075492
   query75  4241266326932663
   query76  45861003941 941
   query77  668 314 310 310
   query78  95378945
   query79  2420537 542 537
   query80  2278479 492 479
   query81  584 221 222 221
   query82  768 142 134 134
   query83  281 171 172 171
   query84  272 90  88  88
   query85  1502317 305 305
   query86  480 296 292 292
   query87  3281306131383061
   query88  3969246624692466
   query89  496 396 393 393
   query90  2021201 203 201
   query91  218 105 105 105
   query92  63  49  50  49
   query93  2360526 510 510
   query94  1360219 217 217
   query95  416 330 327 327
   query96  599 280 271 271
   query97  3188303829922992
   query98  229 199 195 195
   query99  1574128012671267
   Total cold run time: 289853 ms
   Total hot run time: 175209 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 

[PR] [cherry-pick](branch-2.0) pick "[Fix](schema change) Fix schema change fault when add complex type column (#31824)" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian opened a new pull request, #37598:
URL: https://github.com/apache/doris/pull/37598

   Problem: An error is encountered when executing a schema change on a unique 
table to add a column with a complex type, such as bitmap, as documented in 
https://github.com/apache/doris/issues/31365
   
   Reason: The error arises because the schema change logic erroneously applies 
an aggregation check for new columns across all table types, demanding an 
explicit aggregation type declaration. However, unique and duplicate tables 
inherently assume default aggregation types for newly added columns, leading to 
this misstep.
   
   Solution: The schema change process for introducing new columns needs to 
distinguish between table types accurately. For unique and duplicate tables, it 
should automatically assign the appropriate aggregation type, which, for the 
purpose of smooth integration with subsequent processes, should be set to NONE.
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   


-- 
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] [Improve] Estimated column reader memory to control segment cache [doris]

2024-07-10 Thread via GitHub


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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [cherry-pick](branch-2.0) pick "[Fix](schema change) Fix schema change fault when add complex type column (#31824)" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian commented on PR #37598:
URL: https://github.com/apache/doris/pull/37598#issuecomment-2219793252

   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] [cherry-pick](branch-2.0) pick "[Fix](schema change) Fix schema change fault when add complex type column (#31824)" [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.93 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8a9934f3ac734f2b06b4f108f294b87c817a0ef8, 
data reload: false
   
   query1   0.020.030.02
   query2   0.070.030.02
   query3   0.250.040.04
   query4   1.800.060.07
   query5   0.540.520.51
   query6   1.240.620.61
   query7   0.010.000.01
   query8   0.040.030.02
   query9   0.530.490.48
   query10  0.550.540.54
   query11  0.120.080.09
   query12  0.120.090.09
   query13  0.620.610.61
   query14  0.790.790.78
   query15  0.790.760.77
   query16  0.380.350.36
   query17  1.010.991.01
   query18  0.230.250.25
   query19  1.931.881.87
   query20  0.020.010.01
   query21  15.48   0.570.55
   query22  2.422.481.65
   query23  17.41   0.970.86
   query24  5.491.111.27
   query25  0.370.100.05
   query26  0.610.150.16
   query27  0.040.040.04
   query28  7.250.730.71
   query29  12.67   2.432.42
   query30  0.570.530.54
   query31  2.810.390.38
   query32  3.380.490.49
   query33  3.123.113.06
   query34  15.25   4.794.76
   query35  4.844.844.82
   query36  1.051.011.03
   query37  0.060.050.04
   query38  0.030.020.02
   query39  0.020.010.02
   query40  0.150.140.14
   query41  0.070.010.01
   query42  0.020.010.01
   query43  0.020.020.02
   Total cold run time: 104.19 s
   Total hot run time: 30.93 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] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174871 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 5687dc8fc0cd44100adfd8cf96f7fc3041270dda, 
data reload: false
   
   query1   906 367 370 367
   query2   6441238525422385
   query3   6638203 214 203
   query4   23601   17671   17537   17537
   query5   3655490 472 472
   query6   271 181 170 170
   query7   4582294 295 294
   query8   331 299 303 299
   query9   8639238723742374
   query10  443 290 300 290
   query11  11925   10155   10290   10155
   query12  115 82  87  82
   query13  1640371 368 368
   query14  9604777482797774
   query15  272 192 182 182
   query16  8015305 296 296
   query17  1822544 523 523
   query18  1999286 271 271
   query19  199 154 150 150
   query20  87  81  88  81
   query21  205 125 127 125
   query22  4611426343884263
   query23  33997   33791   33501   33501
   query24  10485   287529272875
   query25  572 402 405 402
   query26  692 149 152 149
   query27  2205274 275 274
   query28  5806213521072107
   query29  921 623 631 623
   query30  249 151 149 149
   query31  960 774 749 749
   query32  95  54  53  53
   query33  661 298 303 298
   query34  967 485 490 485
   query35  699 583 603 583
   query36  1155998 1008998
   query37  141 85  86  85
   query38  3047286728422842
   query39  893 849 805 805
   query40  210 124 119 119
   query41  53  50  54  50
   query42  113 98  98  98
   query43  623 546 543 543
   query44  1138734 732 732
   query45  194 156 164 156
   query46  1092679 719 679
   query47  1893181117981798
   query48  367 304 293 293
   query49  846 409 410 409
   query50  780 384 384 384
   query51  6900672466466646
   query52  106 96  94  94
   query53  354 295 282 282
   query54  867 445 441 441
   query55  73  72  72  72
   query56  294 265 299 265
   query57  1155107010791070
   query58  249 253 253 253
   query59  3653329132143214
   query60  294 276 273 273
   query61  97  96  97  96
   query62  774 654 629 629
   query63  319 284 282 282
   query64  9130215716351635
   query65  3171308430833083
   query66  749 340 335 335
   query67  15498   15113   15265   15113
   query68  4603549 551 549
   query69  621 411 343 343
   query70  1179105611401056
   query71  379 295 283 283
   query72  7098547951335133
   query73  733 322 326 322
   query74  6031556755635563
   query75  3344265026942650
   query76  2166915 966 915
   query77  481 296 302 296
   query78  9524915288548854
   query79  2559511 528 511
   query80  2860463 462 462
   query81  584 217 218 217
   query82  894 136 143 136
   query83  309 168 184 168
   query84  274 88  87  87
   query85  2027297 301 297
   query86  482 309 301 301
   query87  3275310330753075
   query88  4154244424482444
   query89  472 385 378 378
   query90  1827190 186 186
   query91  131 102 99  99
   query92  60  47  48  47
   query93  2984510 512 510
   query94  1242207 204 204
   query95  392 318 315 315
   query96  608 282 278 278
   query97  3280303330403033
   query98  222 199 191 191
   query99  1584128513031285
   Total cold run time: 276917 ms
   Total hot run time: 174871 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 

Re: [PR] [fix](catalog)Fix internal program error causing client to get stuck [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174348 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 491200172045abd3703b81398a3f39a21e76cd48, 
data reload: false
   
   query1   917 377 358 358
   query2   6463238823612361
   query3   6645206 214 206
   query4   28350   17364   17066   17066
   query5   3769474 473 473
   query6   261 181 171 171
   query7   4580296 288 288
   query8   318 288 300 288
   query9   8551239423562356
   query10  434 284 270 270
   query11  10795   10229   10193   10193
   query12  117 82  82  82
   query13  1644373 377 373
   query14  9984758874757475
   query15  222 181 184 181
   query16  7775299 305 299
   query17  1799562 515 515
   query18  1959292 302 292
   query19  197 154 147 147
   query20  91  83  81  81
   query21  214 124 121 121
   query22  4318431940854085
   query23  33959   33853   34163   33853
   query24  11163   286128142814
   query25  572 454 425 425
   query26  839 152 147 147
   query27  3009285 282 282
   query28  7864213520962096
   query29  899 656 664 656
   query30  250 156 164 156
   query31  984 759 787 759
   query32  102 57  60  57
   query33  800 325 316 316
   query34  994 490 502 490
   query35  697 582 591 582
   query36  1108936 955 936
   query37  133 80  80  80
   query38  2861274027402740
   query39  859 823 828 823
   query40  199 125 120 120
   query41  53  51  52  51
   query42  118 105 100 100
   query43  603 527 500 500
   query44  1185732 749 732
   query45  198 157 161 157
   query46  1068739 718 718
   query47  1846176517641764
   query48  377 300 300 300
   query49  896 416 457 416
   query50  790 387 396 387
   query51  6866679967446744
   query52  110 90  92  90
   query53  361 285 290 285
   query54  870 457 443 443
   query55  74  75  73  73
   query56  291 269 264 264
   query57  1137105010501050
   query58  259 246 259 246
   query59  3510336334133363
   query60  302 289 288 288
   query61  95  96  95  95
   query62  791 648 648 648
   query63  313 290 302 290
   query64  9403227316341634
   query65  3158305730983057
   query66  748 328 325 325
   query67  15687   15243   15025   15025
   query68  4484526 539 526
   query69  598 409 348 348
   query70  1113104310731043
   query71  420 283 272 272
   query72  7249527052365236
   query73  751 319 321 319
   query74  5909551555335515
   query75  3374271226962696
   query76  2741969 1005969
   query77  604 304 310 304
   query78  11017   918788098809
   query79  3235517 510 510
   query80  1508473 472 472
   query81  596 220 223 220
   query82  688 135 134 134
   query83  343 170 174 170
   query84  278 85  91  85
   query85  1210375 303 303
   query86  484 328 318 318
   query87  3274309431233094
   query88  4864245324552453
   query89  498 384 379 379
   query90  1873191 188 188
   query91  129 100 101 100
   query92  64  51  49  49
   query93  4644509 505 505
   query94  1200214 203 203
   query95  392 310 307 307
   query96  597 271 280 271
   query97  3196304930433043
   query98  221 209 195 195
   query99  1587125412691254
   Total cold run time: 286945 ms
   Total hot run time: 174348 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 th

Re: [PR] [fix](txn_manager) Add ingested rowsets to unused rowsets when removing txn [doris]

2024-07-10 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 8a9934f3ac734f2b06b4f108f294b87c817a0ef8 with 
default session variables
   Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 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:   21.2 seconds inserted 1000 Rows, about 471K 
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-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] [profile](rf) fix set error value in RuntimeFilterInfo [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.49 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 7ddb5c1057b5b1757848b6328d34126a21faa965, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.040.04
   query3   0.230.050.04
   query4   1.680.070.08
   query5   0.520.480.48
   query6   1.130.720.72
   query7   0.020.010.01
   query8   0.050.040.04
   query9   0.560.490.48
   query10  0.540.530.54
   query11  0.150.110.11
   query12  0.140.120.13
   query13  0.610.580.57
   query14  0.770.770.78
   query15  0.860.810.81
   query16  0.360.350.34
   query17  0.970.970.95
   query18  0.250.220.21
   query19  1.781.691.67
   query20  0.020.010.01
   query21  15.40   0.760.67
   query22  4.686.741.97
   query23  18.31   1.371.24
   query24  2.080.240.22
   query25  0.160.080.08
   query26  0.300.200.20
   query27  0.450.230.23
   query28  13.30   1.040.99
   query29  12.61   3.353.31
   query30  0.250.060.05
   query31  2.890.380.39
   query32  3.260.480.46
   query33  2.912.962.91
   query34  17.04   4.424.32
   query35  4.414.424.36
   query36  0.660.480.48
   query37  0.180.160.16
   query38  0.160.150.15
   query39  0.040.030.04
   query40  0.150.130.13
   query41  0.100.050.05
   query42  0.050.060.06
   query43  0.040.040.04
   Total cold run time: 110.19 s
   Total hot run time: 30.49 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] [Improment]Query queued by be memory [doris]

2024-07-10 Thread via GitHub


yiguolei commented on code in PR #37559:
URL: https://github.com/apache/doris/pull/37559#discussion_r1671799610


##
fe/fe-common/src/main/java/org/apache/doris/common/Config.java:
##
@@ -1759,6 +1759,14 @@ public class Config extends ConfigBase {
 @ConfField(mutable = true, varType = VariableAnnotation.EXPERIMENTAL)
 public static boolean enable_cpu_hard_limit = false;
 
+@ConfField(mutable = true, description = {
+"当BE内存用量大于该值时,查询会进入排队逻辑,默认值为-1,代表该值不生效。取值范围0~1的小数",
+"When be memory usage bigger than this value, query could queue, 
default value is -1, means this value not work. Decimal value range from 0 to 
1"})
+public static double query_queue_by_be_used_memory = -1;

Review Comment:
   为啥是一个config,而不是一个workload group的properties?



-- 
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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 173431 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 47ade42db98ceb6311e243f141682f859f38baa7, 
data reload: false
   
   query1   906 376 366 366
   query2   6467235524572355
   query3   6657207 212 207
   query4   26832   17208   17287   17208
   query5   4157513 506 506
   query6   289 173 174 173
   query7   4587294 282 282
   query8   325 303 299 299
   query9   8446239223752375
   query10  433 287 275 275
   query11  12271   997610060   9976
   query12  136 85  82  82
   query13  1636377 367 367
   query14  10151   779578757795
   query15  236 189 193 189
   query16  7207308 305 305
   query17  1807562 553 553
   query18  1349318 275 275
   query19  208 152 153 152
   query20  97  83  91  83
   query21  212 132 127 127
   query22  4248416839903990
   query23  33848   33095   33172   33095
   query24  11907   286428322832
   query25  672 369 366 366
   query26  1788148 148 148
   query27  2653268 272 268
   query28  7080206020542054
   query29  975 636 622 622
   query30  288 149 148 148
   query31  949 763 771 763
   query32  95  53  56  53
   query33  770 311 327 311
   query34  910 507 495 495
   query35  674 555 548 548
   query36  1096929 911 911
   query37  237 79  76  76
   query38  2824271027602710
   query39  875 831 802 802
   query40  276 122 123 122
   query41  61  52  51  51
   query42  126 100 108 100
   query43  592 546 536 536
   query44  1156741 731 731
   query45  198 165 160 160
   query46  1081726 725 725
   query47  1878175517571755
   query48  375 314 294 294
   query49  1189410 417 410
   query50  787 408 408 408
   query51  6914676567636763
   query52  134 92  95  92
   query53  359 301 299 299
   query54  1100450 469 450
   query55  78  75  77  75
   query56  304 284 272 272
   query57  1174102610321026
   query58  246 271 288 271
   query59  3504332631623162
   query60  309 277 285 277
   query61  97  92  93  92
   query62  813 647 651 647
   query63  336 303 304 303
   query64  10633   218016221622
   query65  3235307430733073
   query66  1287361 339 339
   query67  15520   14891   15064   14891
   query68  4541541 557 541
   query69  478 335 333 333
   query70  1188112510681068
   query71  402 300 294 294
   query72  7498530658655306
   query73  744 327 326 326
   query74  6080552555115511
   query75  3501270126712671
   query76  2811980 907 907
   query77  497 309 316 309
   query78  9370915988538853
   query79  2167529 523 523
   query80  1324496 490 490
   query81  572 215 218 215
   query82  735 135 133 133
   query83  266 168 169 168
   query84  237 86  90  86
   query85  1812317 305 305
   query86  489 327 329 327
   query87  3274315230713071
   query88  3922252324282428
   query89  479 388 394 388
   query90  1856196 192 192
   query91  132 104 105 104
   query92  66  52  51  51
   query93  2445519 513 513
   query94  1260218 213 213
   query95  416 328 323 323
   query96  602 274 271 271
   query97  3215306730173017
   query98  223 202 196 196
   query99  1643128912101210
   Total cold run time: 284305 ms
   Total hot run time: 173431 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

[PR] [cherry-pick](branch-2.0) pick "[Enhancement](mor) Add unique mor table min max push down case #32196" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian opened a new pull request, #37599:
URL: https://github.com/apache/doris/pull/37599

   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   


-- 
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] [cherry-pick](branch-2.0) pick "[Enhancement](mor) Add unique mor table min max push down case #32196" [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [opt](cast) use fmt in cast float to string [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.25 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5687dc8fc0cd44100adfd8cf96f7fc3041270dda, 
data reload: false
   
   query1   0.040.040.03
   query2   0.080.040.04
   query3   0.230.060.06
   query4   1.660.100.09
   query5   0.510.490.49
   query6   1.130.730.72
   query7   0.020.010.01
   query8   0.050.040.04
   query9   0.550.490.49
   query10  0.540.550.53
   query11  0.150.120.11
   query12  0.140.120.12
   query13  0.600.590.58
   query14  0.760.780.77
   query15  0.850.810.82
   query16  0.360.370.37
   query17  1.030.970.96
   query18  0.230.220.22
   query19  1.801.791.74
   query20  0.020.010.01
   query21  15.39   0.750.65
   query22  3.567.552.41
   query23  18.33   1.351.31
   query24  2.060.220.22
   query25  0.170.080.08
   query26  0.310.200.20
   query27  0.450.220.22
   query28  13.33   1.021.00
   query29  12.61   3.383.36
   query30  0.250.060.06
   query31  2.860.380.38
   query32  3.280.470.47
   query33  2.842.962.92
   query34  16.96   4.384.34
   query35  4.384.384.49
   query36  0.650.470.47
   query37  0.190.150.15
   query38  0.160.150.14
   query39  0.040.030.04
   query40  0.150.130.13
   query41  0.090.050.05
   query42  0.060.050.05
   query43  0.050.040.04
   Total cold run time: 108.92 s
   Total hot run time: 31.25 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] [cherry-pick](branch-2.0) pick "[Enhancement](mor) Add unique mor table min max push down case #32196" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian commented on PR #37599:
URL: https://github.com/apache/doris/pull/37599#issuecomment-2219806477

   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] [fix](catalog)Fix internal program error causing client to get stuck [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.6 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 491200172045abd3703b81398a3f39a21e76cd48, 
data reload: false
   
   query1   0.030.030.04
   query2   0.080.030.04
   query3   0.220.040.04
   query4   1.680.070.07
   query5   0.490.480.49
   query6   1.140.720.73
   query7   0.020.020.01
   query8   0.050.050.04
   query9   0.550.500.49
   query10  0.550.540.55
   query11  0.150.110.11
   query12  0.140.120.12
   query13  0.590.580.58
   query14  0.760.780.77
   query15  0.840.820.82
   query16  0.370.370.37
   query17  1.010.961.05
   query18  0.240.220.23
   query19  1.821.681.71
   query20  0.010.000.01
   query21  15.39   0.780.67
   query22  4.397.601.84
   query23  18.29   1.331.41
   query24  2.130.250.22
   query25  0.150.080.08
   query26  0.300.210.21
   query27  0.450.220.23
   query28  13.23   1.021.01
   query29  12.62   3.363.33
   query30  0.250.060.05
   query31  2.880.390.38
   query32  3.270.480.47
   query33  2.882.942.91
   query34  17.11   4.334.40
   query35  4.414.434.48
   query36  0.650.490.48
   query37  0.200.150.15
   query38  0.150.140.14
   query39  0.040.030.03
   query40  0.160.120.11
   query41  0.100.050.05
   query42  0.060.050.04
   query43  0.040.040.04
   Total cold run time: 109.89 s
   Total hot run time: 30.6 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] [Refact](inverted index) refact no need read data opt logic [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39606 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e822f48b71d11590007e5719987f8d88e76ca604, 
data reload: false
   
   -- Round 1 --
   q1   17620   429042674267
   q2   2013194 185 185
   q3   10454   115110961096
   q4   10187   775 826 775
   q5   7486261025932593
   q6   219 135 137 135
   q7   970 596 604 596
   q8   9225206620512051
   q9   8814648764716471
   q10  8867394636693669
   q11  495 239 240 239
   q12  468 222 229 222
   q13  18785   301429742974
   q14  264 234 234 234
   q15  530 472 490 472
   q16  503 391 378 378
   q17  961 722 736 722
   q18  8015738474757384
   q19  6436152313601360
   q20  660 315 304 304
   q21  4914323831483148
   q22  391 331 337 331
   Total cold run time: 118277 ms
   Total hot run time: 39606 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4355423442014201
   q2   369 271 277 271
   q3   2962289328602860
   q4   1996167416591659
   q5   5599549355175493
   q6   225 134 133 133
   q7   2231185818401840
   q8   3283341234313412
   q9   8626875088618750
   q10  4089390938083808
   q11  582 493 516 493
   q12  845 693 647 647
   q13  15915   319831833183
   q14  321 294 292 292
   q15  539 497 481 481
   q16  483 429 444 429
   q17  1839153514871487
   q18  8161796479727964
   q19  1788162317671623
   q20  2937189918971897
   q21  9659491549074907
   q22  667 588 554 554
   Total cold run time: 77471 ms
   Total hot run time: 56384 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



[PR] (selectdb-cloud) Add retry when delete bitmap lock expired on group commit [doris]

2024-07-10 Thread via GitHub


hust-hhb opened a new pull request, #37600:
URL: https://github.com/apache/doris/pull/37600

   group commit writing mow table may encouter delete bitmap lock expired, add 
retry mechanism to avoid group commit fail.
   
   


-- 
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] (selectdb-cloud) Add retry when delete bitmap lock expired on group commit [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [fix](group commit) Add retry when delete bitmap lock expired on group commit [doris]

2024-07-10 Thread via GitHub


hust-hhb commented on PR #37600:
URL: https://github.com/apache/doris/pull/37600#issuecomment-2219810745

   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] [fix](readconsistency) avoid table not exist error [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.71 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 47ade42db98ceb6311e243f141682f859f38baa7, 
data reload: false
   
   query1   0.040.040.03
   query2   0.080.030.04
   query3   0.230.060.06
   query4   1.660.070.09
   query5   0.500.510.48
   query6   1.130.730.73
   query7   0.020.020.01
   query8   0.050.050.05
   query9   0.560.500.49
   query10  0.550.540.54
   query11  0.150.120.11
   query12  0.140.120.12
   query13  0.600.590.59
   query14  0.760.780.78
   query15  0.850.820.81
   query16  0.370.370.37
   query17  1.041.031.03
   query18  0.230.220.23
   query19  1.931.861.89
   query20  0.020.010.02
   query21  15.53   0.770.66
   query22  4.207.801.49
   query23  18.26   1.321.23
   query24  2.110.220.22
   query25  0.150.080.09
   query26  0.290.210.21
   query27  0.450.230.23
   query28  13.28   1.011.00
   query29  12.63   3.633.65
   query30  0.260.060.05
   query31  2.860.380.38
   query32  3.290.480.47
   query33  2.872.912.88
   query34  17.06   4.344.48
   query35  4.414.454.40
   query36  0.650.470.47
   query37  0.180.160.16
   query38  0.160.150.15
   query39  0.040.030.04
   query40  0.160.120.13
   query41  0.090.050.04
   query42  0.050.040.05
   query43  0.040.040.04
   Total cold run time: 109.93 s
   Total hot run time: 30.71 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] [cherry-pick](branch-2.0) Pick "[Enhancement](merge-on-write) Support dynamic delete bitmap cache (#32991)" [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [Improment]Query queued by be memory [doris]

2024-07-10 Thread via GitHub


yiguolei commented on code in PR #37559:
URL: https://github.com/apache/doris/pull/37559#discussion_r1671808009


##
fe/fe-core/src/main/java/org/apache/doris/tablefunction/MetadataGenerator.java:
##
@@ -598,6 +598,8 @@ private static TFetchSchemaTableDataResult 
queriesMetadataResult(TSchemaTableReq
 trow.addToColumnValue(new TCell());
 } else if (tokenState == TokenState.READY_TO_RUN) {
 trow.addToColumnValue(new TCell().setStringVal("RUNNING"));
+} else if (tokenState == TokenState.WAIT_FOR_MEMORY) {

Review Comment:
   为啥要改这里?



-- 
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](regression) remove unique key duplicate cases [doris]

2024-07-10 Thread via GitHub


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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   1. the suite `tpch_unique_sql_zstd_p0` is completely duplicate with 
`tpch_sf0.1_unique_p1`, remove `tpch_unique_sql_zstd_p0` to improve p0 pipeline 
execution time
   2. the suit `ssb_unique_load_zstd_p0` is completely duplicate with 
`unique_with_mow_p0/ssb_unique_load_zstd`
   
   


-- 
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](regression) remove unique key duplicate cases [doris]

2024-07-10 Thread via GitHub


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

   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



[PR] [cherry-pick](branch-2.0) Pick "[Enhancement](merge-on-write) Support dynamic delete bitmap cache (#32991)" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian opened a new pull request, #37602:
URL: https://github.com/apache/doris/pull/37602

   The default delete bitmap cache is set to 100MB, which can be insufficient 
and cause performance issues when the amount of user data is large. To mitigate 
the problem of an inadequate cache, we will take the larger of 5% of the total 
memory and 100MB as the delete bitmap cache size.
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   


-- 
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](regression) remove unique key duplicate cases [doris]

2024-07-10 Thread via GitHub


zhannngchen commented on PR #37601:
URL: https://github.com/apache/doris/pull/37601#issuecomment-2219814272

   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] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 49884 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8e54babc057c926401540967860d03a217920904, 
data reload: false
   
   -- Round 1 --
   q1   17985   658843394339
   q2   2078156 147 147
   q3   10528   190519271905
   q4   10343   123513421235
   q5   8434393239493932
   q6   234 126 128 126
   q7   2047158415871584
   q8   9496273127072707
   q9   13363   10348   10226   10226
   q10  8652352835073507
   q11  418 251 252 251
   q12  470 303 309 303
   q13  18358   395141013951
   q14  356 330 333 330
   q15  523 464 472 464
   q16  670 574 570 570
   q17  1129952 903 903
   q18  7204696569066906
   q19  1818170016331633
   q20  527 321 311 311
   q21  4424417941054105
   q22  531 451 449 449
   Total cold run time: 119588 ms
   Total hot run time: 49884 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4337430743234307
   q2   313 222 222 222
   q3   4193417541454145
   q4   2743275027342734
   q5   7131704870857048
   q6   240 122 120 120
   q7   3256287328332833
   q8   4357444544774445
   q9   16999   16955   16898   16898
   q10  4206431042784278
   q11  734 713 677 677
   q12  1027869 862 862
   q13  6806375537323732
   q14  445 434 425 425
   q15  515 471 453 453
   q16  738 685 690 685
   q17  3797392438423842
   q18  8770884087098709
   q19  1752168516591659
   q20  2392215121162116
   q21  8545842685018426
   q22  1068933 988 933
   Total cold run time: 84364 ms
   Total hot run time: 79549 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] [fix](group commit) Fix some group commit problems [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39889 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ffbfb12cb7cd4ba8da37076e9804e5d1791136b0, 
data reload: false
   
   -- Round 1 --
   q1   17593   455642544254
   q2   2026193 188 188
   q3   10436   123011761176
   q4   10184   857 746 746
   q5   7612270426642664
   q6   227 141 146 141
   q7   982 616 631 616
   q8   9285208420712071
   q9   8975653364936493
   q10  8897378636903690
   q11  459 237 251 237
   q12  412 233 240 233
   q13  17770   302629922992
   q14  280 231 229 229
   q15  530 493 500 493
   q16  512 384 388 384
   q17  960 644 743 644
   q18  8241743375057433
   q19  1661153813731373
   q20  686 327 338 327
   q21  5037316933533169
   q22  387 340 336 336
   Total cold run time: 113152 ms
   Total hot run time: 39889 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4397424244254242
   q2   369 267 265 265
   q3   2974278727362736
   q4   1899163916261626
   q5   5327529853105298
   q6   227 133 133 133
   q7   2115179118031791
   q8   3271334433403340
   q9   8433839783338333
   q10  3895369036493649
   q11  581 495 476 476
   q12  803 597 615 597
   q13  17660   302929822982
   q14  299 269 276 269
   q15  514 476 470 470
   q16  479 401 424 401
   q17  1757150014541454
   q18  7668757173797379
   q19  8928173715751575
   q20  2040175317821753
   q21  4927480647504750
   q22  610 539 551 539
   Total cold run time: 79173 ms
   Total hot run time: 54058 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] [cherry-pick](branch-2.0) Pick "[Enhancement](merge-on-write) Support dynamic delete bitmap cache (#32991)" [doris]

2024-07-10 Thread via GitHub


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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [cherry-pick](branch-2.0) pick "[Fix](schema change) Fix schema change fault when add complex type column (#31824)" [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 50160 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit bf54ec39e051c2b896d658290bbe1e0e5bb4bdae, 
data reload: false
   
   -- Round 1 --
   q1   20259   452345684523
   q2   2259227 160 160
   q3   12786   196719571957
   q4   10111   124913271249
   q5   8372385139183851
   q6   233 126 129 126
   q7   2052163615991599
   q8   9476275427292729
   q9   10848   10262   10262   10262
   q10  8673352635433526
   q11  408 247 256 247
   q12  476 305 309 305
   q13  18341   394140613941
   q14  366 331 342 331
   q15  524 455 456 455
   q16  679 577 575 575
   q17  1160983 971 971
   q18  7322705869346934
   q19  1795170716491649
   q20  548 292 308 292
   q21  4432414240314031
   q22  537 462 447 447
   Total cold run time: 121657 ms
   Total hot run time: 50160 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4372430242954295
   q2   329 234 229 229
   q3   4181413641134113
   q4   2757274327592743
   q5   7153711570537053
   q6   238 128 123 123
   q7   3268280928282809
   q8   4424451644884488
   q9   16926   16781   16829   16781
   q10  4266424842874248
   q11  773 695 714 695
   q12  1044836 860 836
   q13  7211373737553737
   q14  451 435 435 435
   q15  525 467 455 455
   q16  738 684 691 684
   q17  3841386738933867
   q18  8894882688238823
   q19  1744175316731673
   q20  2403216021552155
   q21  8711855585878555
   q22  1026981 994 981
   Total cold run time: 85275 ms
   Total hot run time: 79778 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] [fix](dump) do not report success if dumping fails [doris]

2024-07-10 Thread via GitHub


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

   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] [Refact](inverted index) refact no need read data opt logic [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 176529 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 e822f48b71d11590007e5719987f8d88e76ca604, 
data reload: false
   
   query1   926 379 373 373
   query2   6444245223442344
   query3   6657204 211 204
   query4   28289   17573   17340   17340
   query5   3726500 512 500
   query6   275 173 175 173
   query7   4572291 301 291
   query8   334 314 297 297
   query9   8535237923482348
   query10  443 269 292 269
   query11  10899   10291   10047   10047
   query12  121 88  90  88
   query13  1640386 372 372
   query14  10141   791080477910
   query15  236 208 196 196
   query16  7258328 319 319
   query17  1649590 544 544
   query18  1808290 280 280
   query19  210 149 147 147
   query20  92  84  82  82
   query21  210 134 133 133
   query22  4262414239823982
   query23  34308   33695   33942   33695
   query24  11298   310930613061
   query25  603 406 427 406
   query26  707 161 159 159
   query27  2310281 290 281
   query28  7358213221122112
   query29  967 674 662 662
   query30  283 161 162 161
   query31  981 778 752 752
   query32  95  55  57  55
   query33  765 320 344 320
   query34  969 528 529 528
   query35  714 603 597 597
   query36  1179995 993 993
   query37  154 93  84  84
   query38  3042295928692869
   query39  949 819 809 809
   query40  205 129 122 122
   query41  48  52  48  48
   query42  117 100 104 100
   query43  598 572 576 572
   query44  2007765 767 765
   query45  200 167 181 167
   query46  1181805 771 771
   query47  1928184818701848
   query48  419 312 321 312
   query49  898 458 468 458
   query50  872 419 435 419
   query51  7077687568726872
   query52  115 99  98  98
   query53  398 303 298 298
   query54  943 465 461 461
   query55  77  76  75  75
   query56  309 286 296 286
   query57  1144113711191119
   query58  418 280 264 264
   query59  3478333530853085
   query60  825 300 309 300
   query61  111 133 127 127
   query62  1607688 681 681
   query63  341 314 310 310
   query64  10712   237016671667
   query65  3250317231183118
   query66  757 356 343 343
   query67  15446   15234   14939   14939
   query68  4542548 544 544
   query69  502 337 346 337
   query70  1262115211821152
   query71  428 279 285 279
   query72  7433578256035603
   query73  788 328 331 328
   query74  6004559855225522
   query75  3587270227892702
   query76  27831073991 991
   query77  467 307 311 307
   query78  9590893889838938
   query79  2684599 532 532
   query80  2463488 498 488
   query81  600 225 227 225
   query82  784 150 139 139
   query83  299 181 169 169
   query84  268 94  91  91
   query85  1435324 307 307
   query86  461 314 331 314
   query87  3328312431053105
   query88  4150247124552455
   query89  493 409 396 396
   query90  1732206 199 199
   query91  137 106 102 102
   query92  63  51  51  51
   query93  1801506 506 506
   query94  1140225 223 223
   query95  463 319 324 319
   query96  652 278 278 278
   query97  3253303630433036
   query98  235 204 203 203
   query99  1547128712801280
   Total cold run time: 286264 ms
   Total hot run time: 176529 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 t

Re: [PR] [fix](dump) do not report success if dumping fails [doris]

2024-07-10 Thread via GitHub


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

   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



(doris) branch master updated (dff9f497f21 -> cff3f187692)

2024-07-10 Thread gavinchou
This is an automated email from the ASF dual-hosted git repository.

gavinchou pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


from dff9f497f21 [fix](statistics)Fix column cached stats size bug. (#37545)
 add cff3f187692 [fix](dump) do not report success if dumping FE image 
fails (#37508)

No new revisions were added by this update.

Summary of changes:
 fe/fe-core/src/main/java/org/apache/doris/catalog/Env.java | 1 +
 1 file changed, 1 insertion(+)


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [fix](dump) do not report success if dumping FE image fails [doris]

2024-07-10 Thread via GitHub


gavinchou merged PR #37508:
URL: https://github.com/apache/doris/pull/37508


-- 
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](regression) remove unique key duplicate cases [doris]

2024-07-10 Thread via GitHub


zhannngchen commented on PR #37601:
URL: https://github.com/apache/doris/pull/37601#issuecomment-2219842157

   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] [Refact](inverted index) refact no need read data opt logic [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.98 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e822f48b71d11590007e5719987f8d88e76ca604, 
data reload: false
   
   query1   0.040.040.02
   query2   0.080.040.04
   query3   0.220.040.04
   query4   1.710.070.07
   query5   0.510.500.47
   query6   1.150.730.72
   query7   0.020.020.02
   query8   0.050.040.05
   query9   0.540.490.49
   query10  0.540.540.53
   query11  0.140.110.12
   query12  0.140.120.12
   query13  0.600.590.58
   query14  0.770.780.78
   query15  0.840.810.82
   query16  0.360.360.36
   query17  1.020.970.98
   query18  0.230.220.23
   query19  1.821.721.73
   query20  0.010.010.01
   query21  15.39   0.750.67
   query22  4.367.531.32
   query23  18.30   1.381.22
   query24  2.070.240.23
   query25  0.170.090.09
   query26  0.300.200.20
   query27  0.450.240.23
   query28  13.27   1.021.01
   query29  12.59   3.363.35
   query30  0.250.060.06
   query31  2.870.390.39
   query32  3.280.470.46
   query33  2.902.882.85
   query34  17.10   4.334.39
   query35  4.414.394.48
   query36  0.660.480.48
   query37  0.190.160.16
   query38  0.160.160.15
   query39  0.040.040.03
   query40  0.150.120.13
   query41  0.090.040.05
   query42  0.060.050.05
   query43  0.050.040.03
   Total cold run time: 109.9 s
   Total hot run time: 29.98 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] [fix](group commit) Fix some group commit problems [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 174192 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 ffbfb12cb7cd4ba8da37076e9804e5d1791136b0, 
data reload: false
   
   query1   930 370 365 365
   query2   6447248022862286
   query3   6657221 214 214
   query4   28499   17323   17434   17323
   query5   4209479 476 476
   query6   291 172 195 172
   query7   4586304 292 292
   query8   330 283 295 283
   query9   8561239123692369
   query10  447 288 276 276
   query11  10720   10067   10347   10067
   query12  137 88  84  84
   query13  1650391 380 380
   query14  9578845578177817
   query15  271 182 203 182
   query16  7370328 315 315
   query17  1784573 570 570
   query18  1921299 286 286
   query19  201 158 161 158
   query20  89  86  82  82
   query21  203 131 134 131
   query22  4451408540934085
   query23  33807   33178   33273   33178
   query24  11904   289428122812
   query25  659 391 396 391
   query26  1625159 164 159
   query27  2684273 280 273
   query28  7433208020682068
   query29  950 655 637 637
   query30  280 150 151 150
   query31  958 725 767 725
   query32  95  59  58  58
   query33  792 314 310 310
   query34  893 489 504 489
   query35  687 568 586 568
   query36  1085953 935 935
   query37  159 83  84  83
   query38  2875273627822736
   query39  902 816 816 816
   query40  284 128 132 128
   query41  55  55  60  55
   query42  119 103 105 103
   query43  613 566 544 544
   query44  1243742 744 742
   query45  191 164 164 164
   query46  1071729 717 717
   query47  1853177317641764
   query48  383 311 312 311
   query49  1187436 429 429
   query50  776 400 408 400
   query51  6972672767916727
   query52  105 102 96  96
   query53  364 297 294 294
   query54  1012470 465 465
   query55  77  79  78  78
   query56  325 293 306 293
   query57  1168108310601060
   query58  273 351 248 248
   query59  3734344531913191
   query60  305 277 281 277
   query61  95  95  95  95
   query62  829 647 670 647
   query63  322 305 291 291
   query64  10628   218116311631
   query65  3185312831083108
   query66  1382338 340 338
   query67  15738   15031   14920   14920
   query68  8442566 567 566
   query69  735 475 360 360
   query70  1245115611051105
   query71  540 289 294 289
   query72  9095521755285217
   query73  826 334 326 326
   query74  5994553854415441
   query75  5191269926822682
   query76  5121933 926 926
   query77  778 316 313 313
   query78  10532   8937
   query79  9391523 529 523
   query80  1267495 498 495
   query81  586 222 217 217
   query82  443 136 138 136
   query83  337 171 173 171
   query84  280 90  88  88
   query85  1086327 350 327
   query86  354 311 312 311
   query87  3310316031213121
   query88  4434244924772449
   query89  497 395 384 384
   query90  2130190 200 190
   query91  138 105 105 105
   query92  64  50  52  50
   query93  6713525 524 524
   query94  1440217 211 211
   query95  404 327 324 324
   query96  633 273 268 268
   query97  3168304130013001
   query98  222 207 193 193
   query99  1555128112741274
   Total cold run time: 308360 ms
   Total hot run time: 174192 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 th

Re: [PR] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 202730 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 8e54babc057c926401540967860d03a217920904, 
data reload: false
   
   query1   918 420 374 374
   query2   6525280526412641
   query3   6921202 205 202
   query4   20164   18039   17919   17919
   query5   19738   646964446444
   query6   295 212 227 212
   query7   4150305 313 305
   query8   427 446 440 440
   query9   3079262225652565
   query10  404 310 292 292
   query11  11477   10683   10677   10677
   query12  129 77  76  76
   query13  5598712 697 697
   query14  18160   13769   13405   13405
   query15  366 249 249 249
   query16  6486301 263 263
   query17  16731467887 887
   query18  2308414 419 414
   query19  219 144 149 144
   query20  82  78  87  78
   query21  189 94  96  94
   query22  5179509550545054
   query23  32834   31912   31953   31912
   query24  6966649164456445
   query25  521 442 437 437
   query26  533 164 163 163
   query27  1889301 297 297
   query28  6131234722762276
   query29  2945273828262738
   query30  238 163 167 163
   query31  909 736 737 736
   query32  65  64  60  60
   query33  407 257 264 257
   query34  864 477 468 468
   query35  1110964 932 932
   query36  1407112011571120
   query37  88  63  61  61
   query38  3079291729472917
   query39  1362134113201320
   query40  203 95  95  95
   query41  46  44  45  44
   query42  84  83  79  79
   query43  814 690 680 680
   query44  1149736 734 734
   query45  244 242 233 233
   query46  1221980 983 980
   query47  1916165118371651
   query48  1014731 734 731
   query49  622 374 379 374
   query50  879 635 586 586
   query51  4757463846704638
   query52  93  78  83  78
   query53  463 326 321 321
   query54  2638246824702468
   query55  83  78  80  78
   query56  252 220 209 209
   query57  1259105711541057
   query58  207 199 186 186
   query59  4263395739483948
   query60  218 200 207 200
   query61  96  92  92  92
   query62  781 482 482 482
   query63  483 342 348 342
   query64  2621153313491349
   query65  3627355835443544
   query66  832 377 373 373
   query67  15706   15182   14565   14565
   query68  10070   648 673 648
   query69  588 359 347 347
   query70  2025144013831383
   query71  404 314 326 314
   query72  6531352634463446
   query73  738 315 324 315
   query74  6275585658985856
   query75  5466377337193719
   query76  6525119611921192
   query77  1071258 257 257
   query78  12593   12424   11696   11696
   query79  11819   661 651 651
   query80  789 401 397 397
   query81  495 233 238 233
   query82  948 97  99  97
   query83  177 132 133 132
   query84  261 72  70  70
   query85  879 327 333 327
   query86  317 297 289 289
   query87  3264301130293011
   query88  5543233723332333
   query89  425 289 306 289
   query90  2218197 215 197
   query91  177 145 156 145
   query92  58  57  51  51
   query93  5773569 552 552
   query94  811 210 210 210
   query95  1113105610281028
   query96  638 330 326 326
   query97  6527634763766347
   query98  186 182 167 167
   query99  3021854 882 854
   Total cold run time: 320131 ms
   Total hot run time: 202730 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 t

[PR] [cherry-pick](branch-2.0) Pick "[Enhancement](partial update)Add timezone case for partial update timestamp #33177" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian opened a new pull request, #37603:
URL: https://github.com/apache/doris/pull/37603

   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   pick #33177 
   
   


-- 
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] [cherry-pick](branch-2.0) Pick "[Enhancement](partial update)Add timezone case for partial update timestamp #33177" [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [cherry-pick](branch-2.0) Pick "[Enhancement](partial update)Add timezone case for partial update timestamp #33177" [doris]

2024-07-10 Thread via GitHub


Yukang-Lian commented on PR #37603:
URL: https://github.com/apache/doris/pull/37603#issuecomment-2219844402

   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] [fix](cloud) Fix compile err build cloud [doris]

2024-07-10 Thread via GitHub


deardeng commented on PR #37604:
URL: https://github.com/apache/doris/pull/37604#issuecomment-2219851144

   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] [fix](cloud) Fix compile err build cloud [doris]

2024-07-10 Thread via GitHub


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

   ```
   add_library cannot create imported target "jemalloc" because another target
   ```
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   
   
   


-- 
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] [fix](cloud) Fix compile err build cloud [doris]

2024-07-10 Thread via GitHub


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

   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



Re: [PR] [Bugfix] Fix mv column type is not changed when do schema change [doris]

2024-07-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.14 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8e54babc057c926401540967860d03a217920904, 
data reload: false
   
   query1   0.030.020.02
   query2   0.080.020.02
   query3   0.250.050.06
   query4   1.780.100.10
   query5   0.550.520.53
   query6   1.310.600.61
   query7   0.010.000.01
   query8   0.030.020.02
   query9   0.520.480.48
   query10  0.550.530.52
   query11  0.120.090.09
   query12  0.120.090.09
   query13  0.620.610.62
   query14  0.790.800.78
   query15  0.790.750.75
   query16  0.360.370.35
   query17  1.021.001.01
   query18  0.220.260.24
   query19  1.961.841.85
   query20  0.020.010.01
   query21  15.49   0.570.54
   query22  1.992.331.67
   query23  16.62   1.060.89
   query24  5.672.241.52
   query25  0.390.120.05
   query26  0.770.160.15
   query27  0.050.030.03
   query28  5.730.780.73
   query29  12.65   2.262.11
   query30  0.580.520.62
   query31  2.800.390.38
   query32  3.390.510.49
   query33  3.093.063.11
   query34  15.26   4.794.80
   query35  4.874.854.85
   query36  1.081.021.04
   query37  0.060.050.05
   query38  0.030.020.02
   query39  0.020.010.02
   query40  0.170.130.13
   query41  0.070.020.01
   query42  0.020.010.02
   query43  0.020.020.02
   Total cold run time: 101.95 s
   Total hot run time: 31.14 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



  1   2   3   4   5   6   7   8   >