Re: [PR] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   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] [test](inverted index) add an Inverted Index Testing Switch [doris]

2024-08-06 Thread via GitHub


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

   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] [opt](inverted index) opt value extraction from column to string (#37395) [doris]

2024-08-06 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 37.75% (8104/21466) 
Line Coverage: 29.39% (66377/225861)
Region Coverage: 28.90% (34256/118539)
Branch Coverage: 24.78% (17604/71034)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/e3714ebce528f631682203e59482e0464c3f40fe_e3714ebce528f631682203e59482e0464c3f40fe/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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270532378

   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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


seawinde closed pull request #38882: [improvement](mtmv) Support to use view 
when create mtmv
URL: https://github.com/apache/doris/pull/38882


-- 
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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270532738

   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](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   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](cloud-balance) use right file size instead of block size [doris]

2024-08-06 Thread via GitHub


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

   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] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


csun5285 commented on PR #38379:
URL: https://github.com/apache/doris/pull/38379#issuecomment-2270533308

   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] [opt](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   In master branch, we already fixed in this pr: 
https://github.com/apache/doris/pull/36884
   
   Here cherry-pick to branch-2.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] (inverted index) add inverted index file size for open file [doris]

2024-08-06 Thread via GitHub


csun5285 commented on PR #37482:
URL: https://github.com/apache/doris/pull/37482#issuecomment-2270535054

   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



(doris) branch branch-3.0 updated: [fix](pipeline) Fix mem control in local exchanger (#38885)

2024-08-06 Thread dataroaring
This is an automated email from the ASF dual-hosted git repository.

dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-3.0 by this push:
 new 33ec829128e [fix](pipeline) Fix mem control in local exchanger (#38885)
33ec829128e is described below

commit 33ec829128e352b5a3bdd3ab21b0dc6bcd589643
Author: Gabriel 
AuthorDate: Tue Aug 6 09:59:35 2024 +0800

[fix](pipeline) Fix mem control in local exchanger (#38885)

## Proposed changes

If a block (>128M) is dequeue by local exchange source operator and it
is the last block, both of source operators and sink operators will be
hang. This PR fixed it.


---
 be/src/pipeline/dependency.h | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/be/src/pipeline/dependency.h b/be/src/pipeline/dependency.h
index 1e29cf904c7..9c6f9d85dd8 100644
--- a/be/src/pipeline/dependency.h
+++ b/be/src/pipeline/dependency.h
@@ -868,13 +868,13 @@ public:
 }
 
 void add_total_mem_usage(size_t delta) {
-if (mem_usage.fetch_add(delta) > 
config::local_exchange_buffer_mem_limit) {
+if (mem_usage.fetch_add(delta) + delta > 
config::local_exchange_buffer_mem_limit) {
 sink_deps.front()->block();
 }
 }
 
 void sub_total_mem_usage(size_t delta) {
-if (mem_usage.fetch_sub(delta) <= 
config::local_exchange_buffer_mem_limit) {
+if (mem_usage.fetch_sub(delta) - delta <= 
config::local_exchange_buffer_mem_limit) {
 sink_deps.front()->set_ready();
 }
 }


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



Re: [PR] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   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] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   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] [opt](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


cambyzju commented on PR #38943:
URL: https://github.com/apache/doris/pull/38943#issuecomment-2270538266

   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](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


cambyzju commented on PR #38944:
URL: https://github.com/apache/doris/pull/38944#issuecomment-2270542380

   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] [opt](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   pick #38943 to branch-2.0


-- 
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](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   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] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   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] [fix](cloud-balance) use right file size instead of block size [doris]

2024-08-06 Thread via GitHub


gavinchou commented on code in PR #38939:
URL: https://github.com/apache/doris/pull/38939#discussion_r1705022901


##
be/src/io/cache/block_file_cache_downloader.cpp:
##
@@ -171,7 +171,8 @@ void FileCacheBlockDownloader::download_file_cache_block(
 DownloadFileMeta download_meta {
 .path = 
storage_resource.value()->remote_segment_path(*find_it->second,
   
meta.segment_id()),
-.file_size = meta.offset() + meta.size(), // To avoid trigger 
get file size IO
+.file_size = meta.has_file_size() ? meta.file_size()
+  : -1, // To avoid trigger 
get file size IO

Review Comment:
   incorrect 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



Re: [PR] [opt](inverted index) opt value extraction from column to string (#37395) [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 202382 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 e3714ebce528f631682203e59482e0464c3f40fe, 
data reload: false
   
   query1   931 387 408 387
   query2   6549226321622162
   query3   7063212 203 203
   query4   20254   18242   18373   18242
   query5   22525   653265276527
   query6   291 220 243 220
   query7   4153310 314 310
   query8   252 258 240 240
   query9   3143268226272627
   query10  404 301 280 280
   query11  11506   10937   11613   10937
   query12  143 80  89  80
   query13  5940668 674 668
   query14  19774   13623   13786   13623
   query15  383 222 222 222
   query16  6904277 274 274
   query17  18951467882 882
   query18  2345409 407 407
   query19  212 144 157 144
   query20  80  77  79  77
   query21  191 100 89  89
   query22  5393488051634880
   query23  32370   31660   32045   31660
   query24  6802656365306530
   query25  536 424 429 424
   query26  521 164 160 160
   query27  1795300 302 300
   query28  6077227322302230
   query29  2938273427962734
   query30  242 174 161 161
   query31  919 725 734 725
   query32  65  60  60  60
   query33  414 260 267 260
   query34  853 469 487 469
   query35  1112919 919 919
   query36  1285111413621114
   query37  89  64  62  62
   query38  3055297129512951
   query39  1379134213311331
   query40  205 99  100 99
   query41  47  37  36  36
   query42  89  80  100 80
   query43  679 640 596 596
   query44  1140715 720 715
   query45  240 226 226 226
   query46  1223967 956 956
   query47  1774176916011601
   query48  982 699 680 680
   query49  616 383 393 383
   query50  860 629 585 585
   query51  4792467447094674
   query52  88  84  76  76
   query53  450 317 321 317
   query54  2655246624682466
   query55  89  74  80  74
   query56  221 233 208 208
   query57  1133113411961134
   query58  204 205 197 197
   query59  3686338733343334
   query60  215 206 209 206
   query61  98  96  96  96
   query62  881 484 473 473
   query63  485 350 345 345
   query64  2288151714381438
   query65  3664357135633563
   query66  769 398 381 381
   query67  15407   15966   14955   14955
   query68  8976653 638 638
   query69  565 375 355 355
   query70  1831156414511451
   query71  428 314 304 304
   query72  6753351134793479
   query73  747 326 318 318
   query74  6277590658355835
   query75  5351364236713642
   query76  5283114811411141
   query77  884 257 262 257
   query78  12588   12178   11872   11872
   query79  12314   641 636 636
   query80  853 399 401 399
   query81  498 235 237 235
   query82  102097  97  97
   query83  186 130 131 130
   query84  269 73  69  69
   query85  892 322 314 314
   query86  339 327 292 292
   query87  3227302429952995
   query88  5705230523052305
   query89  394 297 286 286
   query90  2534217 206 206
   query91  160 123 121 121
   query92  58  54  54  54
   query93  5970556 591 556
   query94  1295213 208 208
   query95  1123107910721072
   query96  629 336 324 324
   query97  6365632763656327
   query98  189 171 175 171
   query99  3091828 939 828
   Total cold run time: 322557 ms
   Total hot run time: 202382 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] [fix](invert index) fix the error issue in the unit test remove_element_only_in_table [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 204426 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 bc3d81a8c470f2ef0386f2daca887e38a47043f0, 
data reload: false
   
   query1   966 400 414 400
   query2   6660309026712671
   query3   6932218 206 206
   query4   20123   18199   18167   18167
   query5   19739   655065486548
   query6   292 228 265 228
   query7   4160295 300 295
   query8   483 419 463 419
   query9   3116265326092609
   query10  409 308 308 308
   query11  11912   11503   11681   11503
   query12  133 76  85  76
   query13  5654733 695 695
   query14  22392   13621   13445   13445
   query15  377 251 247 247
   query16  6905298 264 264
   query17  17341459875 875
   query18  2337416 417 416
   query19  211 153 152 152
   query20  79  69  81  69
   query21  193 98  93  93
   query22  5155505048414841
   query23  32539   31860   31945   31860
   query24  6877667164946494
   query25  519 442 418 418
   query26  528 162 162 162
   query27  1754293 296 293
   query28  6182235623262326
   query29  2908274526972697
   query30  245 169 174 169
   query31  914 735 741 735
   query32  66  66  63  63
   query33  414 260 254 254
   query34  855 474 472 472
   query35  1101919 930 919
   query36  1301124411891189
   query37  92  60  62  60
   query38  3063296029262926
   query39  1381133013321330
   query40  214 101 93  93
   query41  48  45  45  45
   query42  83  83  77  77
   query43  798 618 696 618
   query44  1107722 725 722
   query45  246 238 240 238
   query46  1233960 972 960
   query47  1897181917931793
   query48  1014712 718 712
   query49  637 375 370 370
   query50  865 607 595 595
   query51  4777457947154579
   query52  92  85  96  85
   query53  458 323 324 323
   query54  2682246024082408
   query55  95  78  89  78
   query56  226 229 209 209
   query57  1157114012251140
   query58  221 199 192 192
   query59  4541397638583858
   query60  215 198 225 198
   query61  102 100 112 100
   query62  829 460 470 460
   query63  496 347 339 339
   query64  2250152415111511
   query65  3609353435763534
   query66  785 389 379 379
   query67  16826   15644   14949   14949
   query68  8655659 645 645
   query69  566 361 345 345
   query70  1657152113621362
   query71  423 306 312 306
   query72  6662349834933493
   query73  735 333 320 320
   query74  6315581959645819
   query75  4944376938183769
   query76  4973112911511129
   query77  720 264 261 261
   query78  12514   11654   11928   11654
   query79  6697637 649 637
   query80  1604408 419 408
   query81  507 238 239 238
   query82  1202101 105 101
   query83  183 136 135 135
   query84  257 73  71  71
   query85  1106336 339 336
   query86  355 306 296 296
   query87  3227307730333033
   query88  4940232622952295
   query89  357 306 288 288
   query90  1962206 221 206
   query91  181 159 153 153
   query92  62  55  54  54
   query93  2295548 592 548
   query94  838 216 211 211
   query95  1112107110631063
   query96  635 328 334 328
   query97  6496638463776377
   query98  187 184 176 176
   query99  3001910 974 910
   Total cold run time: 313572 ms
   Total hot run time: 204426 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

Re: [PR] [Refact](inverted index) refact inverted index compound predicates evaluate logic [doris]

2024-08-06 Thread via GitHub


github-actions[bot] commented on code in PR #38908:
URL: https://github.com/apache/doris/pull/38908#discussion_r1705024709


##
be/src/vec/exprs/vcompound_pred.h:
##
@@ -123,6 +191,18 @@ class VCompoundPred : public VectorizedFnCall {
 }
 
 Status execute(VExprContext* context, Block* block, int* result_column_id) 
override {

Review Comment:
   warning: function 'execute' has cognitive complexity of 113 (threshold 50) 
[readability-function-cognitive-complexity]
   ```cpp
   Status execute(VExprContext* context, Block* block, int* 
result_column_id) override {
  ^
   ```
   
   Additional context
   
   **be/src/vec/exprs/vcompound_pred.h:193:** +1, including nesting penalty of 
0, nesting level increased to 1
   ```cpp
   if (context->get_inverted_index_result_column().contains(this)) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:197:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   for (int i = 0; i < result_column->size(); i++) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:205:** +1, including nesting penalty of 
0, nesting level increased to 1
   ```cpp
   if (children().size() == 1 || 
!_all_child_is_compound_and_not_const()) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:211:** +1, including nesting penalty of 
0, nesting level increased to 1
   ```cpp
   RETURN_IF_ERROR(_children[0]->execute(context, block, &lhs_id));
   ^
   ```
   **be/src/common/status.h:618:** expanded from macro 'RETURN_IF_ERROR'
   ```cpp
   do {\
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:211:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   RETURN_IF_ERROR(_children[0]->execute(context, block, &lhs_id));
   ^
   ```
   **be/src/common/status.h:620:** expanded from macro 'RETURN_IF_ERROR'
   ```cpp
   if (UNLIKELY(!_status_.ok())) { \
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:223:** +1, including nesting penalty of 
0, nesting level increased to 1
   ```cpp
   if (lhs_is_nullable) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:237:** nesting level increased to 1
   ```cpp
   auto get_rhs_colum = [&]() {
^
   ```
   **be/src/vec/exprs/vcompound_pred.h:238:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   if (rhs_id == -1) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:239:** +3, including nesting penalty of 
2, nesting level increased to 3
   ```cpp
   RETURN_IF_ERROR(_children[1]->execute(context, block, 
&rhs_id));
   ^
   ```
   **be/src/common/status.h:618:** expanded from macro 'RETURN_IF_ERROR'
   ```cpp
   do {\
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:239:** +4, including nesting penalty of 
3, nesting level increased to 4
   ```cpp
   RETURN_IF_ERROR(_children[1]->execute(context, block, 
&rhs_id));
   ^
   ```
   **be/src/common/status.h:620:** expanded from macro 'RETURN_IF_ERROR'
   ```cpp
   if (UNLIKELY(!_status_.ok())) { \
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:249:** +3, including nesting penalty of 
2, nesting level increased to 3
   ```cpp
   if (rhs_is_nullable) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:257:** nesting level increased to 1
   ```cpp
   auto return_result_column_id = [&](ColumnPtr res_column, int res_id) 
-> int {
  ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:258:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   if (result_is_nullable && !res_column->is_nullable()) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:258:** +1
   ```cpp
   if (result_is_nullable && !res_column->is_nullable()) {
  ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:267:** nesting level increased to 1
   ```cpp
   auto create_null_map_column = [&](ColumnPtr& null_map_column,
 ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:269:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   if (null_map_data == nullptr) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:278:** nesting level increased to 1
   ```cpp
   auto vector_vector_null = [&]() {
 ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:288:** +2, including nesting penalty of 
1, nesting level increased to 2
   ```cpp
   if constexpr (is_and_op) {
   ^
   ```
   **be/src/vec/exprs/vcompound_pred.h:289:** +3, including nesting penalty of 
2, nesting level incr

Re: [PR] [Enhancement](wal) modify wal api which hard to use [doris]

2024-08-06 Thread via GitHub


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

   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](inverted index) opt value extraction from column to string (#37395) [doris]

2024-08-06 Thread via GitHub


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

   
   
   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 e3714ebce528f631682203e59482e0464c3f40fe, 
data reload: false
   
   query1   0.020.030.02
   query2   0.060.030.02
   query3   0.240.050.05
   query4   1.790.070.06
   query5   0.530.530.52
   query6   1.230.610.62
   query7   0.020.010.01
   query8   0.030.030.02
   query9   0.530.480.47
   query10  0.530.540.53
   query11  0.120.090.09
   query12  0.120.090.09
   query13  0.630.620.60
   query14  0.770.780.78
   query15  0.770.770.75
   query16  0.380.350.37
   query17  1.011.051.02
   query18  0.230.250.25
   query19  1.881.851.83
   query20  0.020.010.02
   query21  15.47   0.560.56
   query22  1.742.272.12
   query23  17.43   1.130.84
   query24  6.991.071.40
   query25  0.400.100.06
   query26  0.720.170.16
   query27  0.040.040.04
   query28  5.900.720.75
   query29  12.76   2.282.27
   query30  0.620.560.54
   query31  2.820.390.37
   query32  3.410.500.49
   query33  3.103.063.06
   query34  15.26   4.834.78
   query35  4.854.864.83
   query36  1.021.011.01
   query37  0.060.050.05
   query38  0.040.030.02
   query39  0.020.020.01
   query40  0.160.140.14
   query41  0.060.010.01
   query42  0.020.010.02
   query43  0.030.010.02
   Total cold run time: 103.83 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] [fix](invert index) fix the error issue in the unit test remove_element_only_in_table [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.34 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit bc3d81a8c470f2ef0386f2daca887e38a47043f0, 
data reload: false
   
   query1   0.020.020.02
   query2   0.090.030.02
   query3   0.250.060.05
   query4   1.760.070.06
   query5   0.540.520.52
   query6   1.230.620.62
   query7   0.020.010.01
   query8   0.040.030.02
   query9   0.540.500.48
   query10  0.540.540.53
   query11  0.120.080.09
   query12  0.110.090.09
   query13  0.620.620.62
   query14  0.780.790.80
   query15  0.770.760.78
   query16  0.370.370.37
   query17  1.021.021.02
   query18  0.220.240.27
   query19  1.921.861.81
   query20  0.010.000.00
   query21  15.47   0.570.57
   query22  1.922.061.62
   query23  17.40   1.011.06
   query24  6.101.511.32
   query25  0.330.100.05
   query26  0.690.160.16
   query27  0.050.040.04
   query28  6.200.770.82
   query29  12.65   2.342.31
   query30  0.630.550.54
   query31  2.820.380.39
   query32  3.380.500.49
   query33  3.093.073.08
   query34  15.24   4.794.79
   query35  4.884.854.86
   query36  1.051.011.02
   query37  0.060.040.05
   query38  0.030.020.02
   query39  0.020.010.02
   query40  0.160.150.14
   query41  0.070.010.02
   query42  0.020.010.01
   query43  0.020.020.02
   Total cold run time: 103.25 s
   Total hot run time: 31.34 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](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 50583 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 495e6d801ba58b975d624dee2a8ac291967fe481, 
data reload: false
   
   -- Round 1 --
   q1   17538   442243594359
   q2   2076162 146 146
   q3   10254   191419241914
   q4   10100   127113381271
   q5   8524396339173917
   q6   236 125 128 125
   q7   2063161616241616
   q8   9315275027292729
   q9   10804   10727   10739   10727
   q10  8677351535073507
   q11  422 248 250 248
   q12  478 298 310 298
   q13  18340   398440393984
   q14  354 337 326 326
   q15  504 446 456 446
   q16  680 580 575 575
   q17  11481001969 969
   q18  7213694969396939
   q19  1791167716421642
   q20  549 340 288 288
   q21  4515411741244117
   q22  546 440 442 440
   Total cold run time: 116127 ms
   Total hot run time: 50583 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4330430643014301
   q2   326 227 231 227
   q3   4173418741584158
   q4   2763276327732763
   q5   7108720470697069
   q6   245 118 117 117
   q7   3254294428702870
   q8   4371447445014474
   q9   17090   16817   16842   16817
   q10  4202442142924292
   q11  752 705 670 670
   q12  1025861 868 861
   q13  6780372437593724
   q14  464 414 432 414
   q15  507 463 453 453
   q16  741 682 675 675
   q17  3931393438593859
   q18  8767881987438743
   q19  1757174616611661
   q20  2374213521142114
   q21  8599854284468446
   q22  1043983 1018983
   Total cold run time: 84602 ms
   Total hot run time: 79691 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](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 37.74% (8102/21467) 
Line Coverage: 29.37% (66344/225871)
Region Coverage: 28.88% (34241/118548)
Branch Coverage: 24.77% (17597/71040)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/495e6d801ba58b975d624dee2a8ac291967fe481_495e6d801ba58b975d624dee2a8ac291967fe481/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](inverted index) opt value extraction from column to string (#37395) [doris]

2024-08-06 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e3714ebce528f631682203e59482e0464c3f40fe with 
default session variables
   Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:  59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:  31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:   21.4 seconds inserted 1000 Rows, about 467K 
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] [fix](invert index) fix the error issue in the unit test remove_element_only_in_table [doris]

2024-08-06 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit bc3d81a8c470f2ef0386f2daca887e38a47043f0 with 
default session variables
   Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:  59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:  32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:   21.7 seconds inserted 1000 Rows, about 460K 
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] [Fix](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 36.40% (9268/25459) 
Line Coverage: 27.93% (75825/271529)
Region Coverage: 26.77% (38997/145680)
Branch Coverage: 23.50% (19798/84260)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/08266823399f9b6e4f1f8470cca012a29a48f8f1_08266823399f9b6e4f1f8470cca012a29a48f8f1/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] [fix](inverted index) fix multi match result error [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41596 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9f9ffa465d0578d000ae05d95b20029173ebd253, 
data reload: false
   
   -- Round 1 --
   q1   17641   413140734073
   q2   2019202 192 192
   q3   10450   133713301330
   q4   10164   780 918 780
   q5   7655295329882953
   q6   218 139 136 136
   q7   1058612 611 611
   q8   9442188919701889
   q9   8466660365976597
   q10  8823386838413841
   q11  448 245 250 245
   q12  433 229 223 223
   q13  17761   294729332933
   q14  279 242 241 241
   q15  533 485 504 485
   q16  535 404 388 388
   q17  968 889 891 889
   q18  8039736872807280
   q19  1963120312201203
   q20  554 321 322 321
   q21  5290484547104710
   q22  356 284 276 276
   Total cold run time: 113095 ms
   Total hot run time: 41596 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4093399439903990
   q2   325 219 215 215
   q3   3017301432083014
   q4   2012201619511951
   q5   5639544754805447
   q6   217 129 128 128
   q7   2108176618391766
   q8   3295338633243324
   q9   8675863288188632
   q10  3917406738963896
   q11  559 439 480 439
   q12  740 578 581 578
   q13  16356   306230843062
   q14  291 280 264 264
   q15  531 484 491 484
   q16  464 427 412 412
   q17  1770175117881751
   q18  8191775077477747
   q19  1738172717091709
   q20  2055191218651865
   q21  5646542353005300
   q22  549 465 473 465
   Total cold run time: 72188 ms
   Total hot run time: 56439 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](Exception) throw exception in defer may result std::terminate [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41612 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e35b5269c04c5d735ed2bb626e41e40771e17ffb, 
data reload: false
   
   -- Round 1 --
   q1   17605   412841744128
   q2   2025198 202 198
   q3   10470   129712941294
   q4   10158   781 1013781
   q5   7662295229732952
   q6   220 136 135 135
   q7   1054614 614 614
   q8   9437188419531884
   q9   8526661765786578
   q10  8741384338533843
   q11  431 250 255 250
   q12  422 228 223 223
   q13  17762   296529312931
   q14  277 240 249 240
   q15  523 480 491 480
   q16  542 400 389 389
   q17  972 935 921 921
   q18  8036723672887236
   q19  1660122212111211
   q20  558 328 344 328
   q21  5284471447594714
   q22  354 284 282 282
   Total cold run time: 112719 ms
   Total hot run time: 41612 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4078402639943994
   q2   330 230 223 223
   q3   2977302231243022
   q4   2011204519851985
   q5   5625553354635463
   q6   218 132 130 130
   q7   2139180318481803
   q8   3329336233593359
   q9   8707866188538661
   q10  3943403239033903
   q11  563 465 481 465
   q12  766 614 573 573
   q13  16435   313431283128
   q14  305 297 288 288
   q15  532 480 478 478
   q16  451 416 410 410
   q17  1783177017461746
   q18  8200793378557855
   q19  1743174917071707
   q20  2086184418261826
   q21  5823557454375437
   q22  557 471 452 452
   Total cold run time: 72601 ms
   Total hot run time: 56908 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](nereids) update the mothods to get table row count [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41692 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 64264fb3bdb1834acea5424b7df74851aab9c64f, 
data reload: false
   
   -- Round 1 --
   q1   17306   410040934093
   q2   1415302 291 291
   q3   10276   129613881296
   q4   10505   911 997 911
   q5   7690296029892960
   q6   220 134 135 134
   q7   1048617 627 617
   q8   9439179719721797
   q9   8392660766546607
   q10  8770384038573840
   q11  422 246 246 246
   q12  407 225 228 225
   q13  17766   297629482948
   q14  276 246 248 246
   q15  526 495 489 489
   q16  504 404 405 404
   q17  970 936 909 909
   q18  7983732171777177
   q19  1604121912191219
   q20  562 326 347 326
   q21  5386467447744674
   q22  355 283 284 283
   Total cold run time: 111822 ms
   Total hot run time: 41692 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4067405340044004
   q2   333 231 225 225
   q3   3016301931413019
   q4   2018206719721972
   q5   5586550455105504
   q6   215 130 140 130
   q7   2138175118191751
   q8   3334330933283309
   q9   8688866788108667
   q10  3977407139613961
   q11  538 440 442 440
   q12  776 591 609 591
   q13  16449   316631173117
   q14  305 281 274 274
   q15  536 507 477 477
   q16  470 428 424 424
   q17  1754174417441744
   q18  8222785476907690
   q19  1714176917101710
   q20  2067189918231823
   q21  5752557052725272
   q22  527 460 476 460
   Total cold run time: 72482 ms
   Total hot run time: 56564 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](optimizer) Remove unused code for unify code [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41592 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 685b2d134a6fa3bcb540757953d6f1378ed376e2, 
data reload: false
   
   -- Round 1 --
   q1   17715   417840504050
   q2   2012202 204 202
   q3   10453   125713241257
   q4   10178   900 909 900
   q5   7636298829802980
   q6   219 139 139 139
   q7   1055614 609 609
   q8   9436190919521909
   q9   8498666066126612
   q10  8712381338263813
   q11  435 247 248 247
   q12  435 225 226 225
   q13  17775   294529332933
   q14  264 250 246 246
   q15  528 497 493 493
   q16  535 409 388 388
   q17  978 940 884 884
   q18  8086735771857185
   q19  1486122412151215
   q20  562 326 336 326
   q21  5291469847784698
   q22  351 283 281 281
   Total cold run time: 112640 ms
   Total hot run time: 41592 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4088399340183993
   q2   323 222 223 222
   q3   3011300231523002
   q4   1993200919651965
   q5   5572550754675467
   q6   219 129 132 129
   q7   2104178418571784
   q8   3302337633473347
   q9   8672864187808641
   q10  3949411538783878
   q11  584 460 451 451
   q12  756 588 586 586
   q13  16495   309431043094
   q14  295 287 286 286
   q15  551 491 492 491
   q16  460 415 423 415
   q17  1761172017161716
   q18  8268774176807680
   q19  1702172817141714
   q20  2096183018261826
   q21  5690550652435243
   q22  543 467 476 467
   Total cold run time: 72434 ms
   Total hot run time: 56397 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] [feature](inverted index) Add multi_match function (#37722) [doris]

2024-08-06 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 36.37% (9274/25497) 
Line Coverage: 27.90% (75855/271868)
Region Coverage: 26.75% (39012/145858)
Branch Coverage: 23.47% (19801/84368)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/3049aa9a37badf3a28e5e87d761c621a7a2e7c8c_3049aa9a37badf3a28e5e87d761c621a7a2e7c8c/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](log) Remove unnecessary warning log (#37093) [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 50064 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1bba06f3af26603221cd12e4e950e4f6c2f92406, 
data reload: false
   
   -- Round 1 --
   q1   17660   436443764364
   q2   2062156 152 152
   q3   10337   188619221886
   q4   10367   121113111211
   q5   8535387639363876
   q6   236 126 126 126
   q7   2076159215711571
   q8   9299273827042704
   q9   8   10561   10557   10557
   q10  8674351534933493
   q11  423 251 239 239
   q12  474 305 308 305
   q13  18354   398940033989
   q14  359 327 330 327
   q15  500 461 463 461
   q16  714 580 571 571
   q17  1129987 979 979
   q18  7382681869076818
   q19  1822166916941669
   q20  545 318 288 288
   q21  4487411540484048
   q22  515 430 440 430
   Total cold run time: 117068 ms
   Total hot run time: 50064 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4316432343234323
   q2   324 226 229 226
   q3   4143412341644123
   q4   2743273227352732
   q5   7151714570907090
   q6   243 121 120 120
   q7   3255283227592759
   q8   4410449845094498
   q9   17433   17222   17224   17222
   q10  4230424542754245
   q11  745 694 700 694
   q12  1041864 852 852
   q13  7270374737643747
   q14  438 428 430 428
   q15  500 461 471 461
   q16  745 673 683 673
   q17  3774384738753847
   q18  8781878187768776
   q19  1743173416401640
   q20  2398215321192119
   q21  8502848384688468
   q22  1053978 925 925
   Total cold run time: 85238 ms
   Total hot run time: 79968 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] [chore](show partitions) show partitions print commit version [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41528 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit c7586e6d46629d8647f3815ef87bda21ba819b2c, 
data reload: false
   
   -- Round 1 --
   q1   17615   408940484048
   q2   2015202 204 202
   q3   10445   130813471308
   q4   10159   873 945 873
   q5   7662297629522952
   q6   221 136 138 136
   q7   1052613 623 613
   q8   9443175819071758
   q9   8536662566196619
   q10  8747384838323832
   q11  427 251 253 251
   q12  428 227 231 227
   q13  17756   292129282921
   q14  269 243 240 240
   q15  526 486 484 484
   q16  526 390 382 382
   q17  965 940 922 922
   q18  8040727871927192
   q19  1541122212051205
   q20  572 319 324 319
   q21  5213476348464763
   q22  351 286 281 281
   Total cold run time: 112509 ms
   Total hot run time: 41528 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4052399439923992
   q2   331 227 224 224
   q3   2998301131493011
   q4   1988202220072007
   q5   5650559255925592
   q6   223 133 133 133
   q7   2221179518891795
   q8   3324333833213321
   q9   8686858188108581
   q10  3934405738853885
   q11  551 472 460 460
   q12  764 609 600 600
   q13  15059   312331043104
   q14  317 274 289 274
   q15  540 472 479 472
   q16  461 429 437 429
   q17  1754171717371717
   q18  8255774977097709
   q19  1700171017051705
   q20  2139184718651847
   q21  5813540552395239
   q22  565 471 462 462
   Total cold run time: 71325 ms
   Total hot run time: 56559 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] [function](cast)Make string casting to integers more like MySQL's behavior [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41756 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ad92efd343eac4184a59fdfadbf26f606a1f4d13, 
data reload: false
   
   -- Round 1 --
   q1   17671   415640904090
   q2   2034206 204 204
   q3   10581   129913201299
   q4   10245   870 940 870
   q5   7652293229962932
   q6   223 142 140 140
   q7   1073628 618 618
   q8   9442198219421942
   q9   8542663566046604
   q10  8753386338623862
   q11  436 255 244 244
   q12  436 232 232 232
   q13  17764   291929462919
   q14  278 247 241 241
   q15  530 481 486 481
   q16  526 386 384 384
   q17  976 917 911 911
   q18  8107729672127212
   q19  1572122812201220
   q20  579 324 334 324
   q21  5378474647934746
   q22  357 287 281 281
   Total cold run time: 113155 ms
   Total hot run time: 41756 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4051403540094009
   q2   332 224 219 219
   q3   3019301331393013
   q4   2016205519831983
   q5   5634548254045404
   q6   220 129 131 129
   q7   2161182618091809
   q8   3305336033543354
   q9   8657870787598707
   q10  3958404039233923
   q11  556 470 466 466
   q12  796 625 615 615
   q13  16627   310731213107
   q14  312 268 288 268
   q15  516 503 480 480
   q16  466 427 424 424
   q17  1799172617231723
   q18  8350774578027745
   q19  1768172417431724
   q20  2068185518201820
   q21  5666544852975297
   q22  539 458 462 458
   Total cold run time: 72816 ms
   Total hot run time: 56677 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](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub


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

   ## Proposed changes
   before
   ```
   mysql> SELECT MICROSECONDS_SUB('2010-11-30 23:50:50', 2);
   +---+
   | microseconds_sub(cast('2010-11-30 23:50:50' as DATETIMEV2(0)), 2) |
   +---+
   | 2010-11-30 23:50:49   |
   +---+
   ```
   now
   ```
   mysql> SELECT MICROSECONDS_SUB('2010-11-30 23:50:50', 2);
   +---+
   | microseconds_sub(cast('2010-11-30 23:50:50' as DATETIMEV2(0)), 2) |
   +---+
   | 2010-11-30 23:50:49.98|
   +---+
   ```
   
   
   
   
   


-- 
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] [improvement](external)add some improvements for external scan [doris]

2024-08-06 Thread via GitHub


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

   ## Proposed changes
   
   1. add session variable: `use_consistent_hash_for_external_scan`, which can 
specify consistent hash for external scan.
   2. add session variable: `ignore_split_type`, which can ignore splits of the 
specified type, use for performance tuning.
   3. add split weight for paimon split with consistent hash.
   4. add `executeFilter` for paimon jni split.
   
   


-- 
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](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub


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

   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] [improvement](external)add some improvements for external scan [doris]

2024-08-06 Thread via GitHub


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

   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] [improvement](external)add some improvements for external scan [doris]

2024-08-06 Thread via GitHub


wuwenchi commented on PR #38946:
URL: https://github.com/apache/doris/pull/38946#issuecomment-2270575395

   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](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub


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

   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] [WIP]Test sub txn [doris]

2024-08-06 Thread via GitHub


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

   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](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 204438 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 495e6d801ba58b975d624dee2a8ac291967fe481, 
data reload: false
   
   query1   927 390 407 390
   query2   6520280627772777
   query3   6924215 205 205
   query4   20451   17871   17912   17871
   query5   19743   654165506541
   query6   295 237 232 232
   query7   4167303 319 303
   query8   432 420 441 420
   query9   3133267425842584
   query10  440 300 279 279
   query11  11223   10715   10687   10687
   query12  128 78  79  78
   query13  5616688 677 677
   query14  17770   13899   13495   13495
   query15  363 239 251 239
   query16  6471285 271 271
   query17  17011467881 881
   query18  2288418 418 418
   query19  215 149 149 149
   query20  83  81  84  81
   query21  191 100 96  96
   query22  5213502050035003
   query23  32646   31974   31939   31939
   query24  6937656164566456
   query25  511 441 426 426
   query26  531 164 163 163
   query27  1885300 295 295
   query28  6128237423152315
   query29  3100287326532653
   query30  243 170 164 164
   query31  915 732 749 732
   query32  66  58  60  58
   query33  393 260 268 260
   query34  856 476 469 469
   query35  1158910 944 910
   query36  1420115112101151
   query37  87  59  61  59
   query38  3037289529242895
   query39  1385130913411309
   query40  196 97  95  95
   query41  47  47  43  43
   query42  96  86  86  86
   query43  744 691 721 691
   query44  1133722 728 722
   query45  247 237 232 232
   query46  1237961 979 961
   query47  1883180116801680
   query48  1025708 715 708
   query49  613 370 368 368
   query50  879 630 631 630
   query51  4762467646784676
   query52  98  79  82  79
   query53  449 332 315 315
   query54  2649244424702444
   query55  94  79  87  79
   query56  244 229 211 211
   query57  1245104712181047
   query58  228 202 219 202
   query59  4156412339253925
   query60  225 214 210 210
   query61  97  96  99  96
   query62  904 502 458 458
   query63  495 344 350 344
   query64  2532153415131513
   query65  3655354835693548
   query66  822 387 378 378
   query67  16557   16192   15841   15841
   query68  8451647 651 647
   query69  559 354 346 346
   query70  1781139315311393
   query71  396 308 316 308
   query72  6579347434633463
   query73  730 306 316 306
   query74  6378590458895889
   query75  5149369236793679
   query76  4945114111681141
   query77  720 260 254 254
   query78  12468   11757   19613   11757
   query79  6562619 630 619
   query80  916 401 402 401
   query81  501 236 238 236
   query82  363 98  101 98
   query83  184 132 130 130
   query84  265 77  71  71
   query85  994 341 340 340
   query86  343 287 285 285
   query87  3204299630502996
   query88  4337228022922280
   query89  356 338 303 303
   query90  1891205 209 205
   query91  171 144 140 140
   query92  60  53  57  53
   query93  996 547 562 547
   query94  750 213 212 212
   query95  1127109810831083
   query96  623 322 327 322
   query97  6426639564206395
   query98  191 169 172 169
   query99  2478884 857 857
   Total cold run time: 303798 ms
   Total hot run time: 204438 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] [Fix](nereids) fix partition_prune or expression evaluate wrongly [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41542 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e5118a617a05e9764a0d9000855fe24ac61ad6d8, 
data reload: false
   
   -- Round 1 --
   q1   17648   405840444044
   q2   2032199 211 199
   q3   10586   124913521249
   q4   10268   787 881 787
   q5   7603295129472947
   q6   215 138 140 138
   q7   1050617 613 613
   q8   9429178219161782
   q9   8764660665366536
   q10  8780385338373837
   q11  436 248 257 248
   q12  463 233 234 233
   q13  17762   294229312931
   q14  273 238 249 238
   q15  539 489 489 489
   q16  520 386 385 385
   q17  953 936 907 907
   q18  8066735773707357
   q19  1435120212211202
   q20  554 339 338 338
   q21  5264479848224798
   q22  342 286 284 284
   Total cold run time: 112982 ms
   Total hot run time: 41542 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4071400740244007
   q2   330 232 226 226
   q3   2981299231552992
   q4   2005197819811978
   q5   5587547754495449
   q6   223 143 142 142
   q7   2111175418201754
   q8   3308337133293329
   q9   8678865788508657
   q10  3933404538833883
   q11  559 478 463 463
   q12  785 642 584 584
   q13  15098   309331313093
   q14  303 270 271 270
   q15  531 481 491 481
   q16  468 426 422 422
   q17  1763172017511720
   q18  8230781177897789
   q19  1766172317491723
   q20  2047185718511851
   q21  5717553353065306
   q22  541 464 471 464
   Total cold run time: 71035 ms
   Total hot run time: 56583 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


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



Re: [PR] [Enhancement](wal) modify wal api which hard to use [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41223 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e665c3df377fb2d811b64a2f7e4353aa17947e1a, 
data reload: false
   
   -- Round 1 --
   q1   17692   403340444033
   q2   2017204 199 199
   q3   10471   129113391291
   q4   10169   768 921 768
   q5   7594291229252912
   q6   225 137 137 137
   q7   1031631 605 605
   q8   9425191219191912
   q9   8446657365416541
   q10  8722379837863786
   q11  437 256 245 245
   q12  406 225 226 225
   q13  17894   292529262925
   q14  268 243 253 243
   q15  529 479 493 479
   q16  520 388 382 382
   q17  948 937 895 895
   q18  8317730971457145
   q19  1586121312021202
   q20  545 338 346 338
   q21  5319468248274682
   q22  358 278 284 278
   Total cold run time: 112919 ms
   Total hot run time: 41223 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4034396140233961
   q2   324 224 214 214
   q3   3003297930922979
   q4   1968198619731973
   q5   5496551354625462
   q6   221 133 133 133
   q7   2106178818141788
   q8   3298336433153315
   q9   8690864287898642
   q10  3883406538253825
   q11  546 452 452 452
   q12  777 604 581 581
   q13  16305   307830713071
   q14  307 291 268 268
   q15  519 499 492 492
   q16  460 432 433 432
   q17  1741170917261709
   q18  8338786478417841
   q19  1738168317141683
   q20  2041187218301830
   q21  5758544452995299
   q22  543 489 469 469
   Total cold run time: 72096 ms
   Total hot run time: 56419 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](multicatalog) fix hadoop authenticator not inited for existing hms catalog. [doris]

2024-08-06 Thread via GitHub


morningman merged PR #38930:
URL: https://github.com/apache/doris/pull/38930


-- 
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](Export) Export delete multiple times when specify the `delete_existing_files` property [doris]

2024-08-06 Thread via GitHub


morningman merged PR #38400:
URL: https://github.com/apache/doris/pull/38400


-- 
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 (81ff2a081cc -> 07e13bbae18)

2024-08-06 Thread morningman
This is an automated email from the ASF dual-hosted git repository.

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


from 81ff2a081cc [Fix](inverted index) fix missed array inverted index null 
bitmap (#38907)
 add 07e13bbae18 [Fix](Export) Export delete multiple times when specify 
the `delete_existing_files` property (#38400)

No new revisions were added by this update.

Summary of changes:
 be/src/service/internal_service.cpp|  6 +++---
 .../org/apache/doris/common/util/BrokerUtil.java   | 12 ++-
 .../main/java/org/apache/doris/load/ExportJob.java |  4 +---
 .../main/java/org/apache/doris/load/ExportMgr.java | 10 ++
 .../doris/load/loadv2/SparkEtlJobHandler.java  |  2 +-
 .../apache/doris/load/loadv2/SparkRepository.java  |  2 +-
 .../java/org/apache/doris/qe/StmtExecutor.java | 23 +-
 .../apache/doris/common/util/BrokerUtilTest.java   |  2 +-
 .../doris/load/loadv2/SparkEtlJobHandlerTest.java  |  2 +-
 gensrc/proto/internal_service.proto|  3 ---
 10 files changed, 34 insertions(+), 32 deletions(-)


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



Re: [PR] [fix](inverted index) fix multi match result error [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 168811 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 9f9ffa465d0578d000ae05d95b20029173ebd253, 
data reload: false
   
   query1   912 372 368 368
   query2   6470170317311703
   query3   6655213 234 213
   query4   20116   17646   17155   17155
   query5   3684499 499 499
   query6   264 174 170 170
   query7   4593309 297 297
   query8   261 201 210 201
   query9   8508235923502350
   query10  425 302 274 274
   query11  10371   998410091   9984
   query12  125 89  89  89
   query13  1639384 399 384
   query14  9943671469576714
   query15  203 171 171 171
   query16  6827479 472 472
   query17  923 546 541 541
   query18  1874275 282 275
   query19  188 144 139 139
   query20  95  84  87  84
   query21  219 99  98  98
   query22  4317405339613961
   query23  33738   33685   33280   33280
   query24  9415306331523063
   query25  649 398 396 396
   query26  722 157 158 157
   query27  2294284 279 279
   query28  5751203420282028
   query29  900 446 417 417
   query30  244 159 159 159
   query31  954 775 762 762
   query32  103 57  59  57
   query33  677 315 330 315
   query34  932 513 498 498
   query35  874 768 778 768
   query36  1074899 921 899
   query37  169 93  87  87
   query38  2960283827832783
   query39  867 800 847 800
   query40  200 110 114 110
   query41  45  44  46  44
   query42  129 104 101 101
   query43  480 421 434 421
   query44  1168714 728 714
   query45  201 175 175 175
   query46  1075811 788 788
   query47  1792172517101710
   query48  368 295 292 292
   query49  858 420 416 416
   query50  888 444 438 438
   query51  6800666566716665
   query52  98  89  88  88
   query53  248 178 174 174
   query54  648 440 443 440
   query55  77  76  75  75
   query56  265 251 260 251
   query57  1119103710331033
   query58  274 278 277 277
   query59  2652236724312367
   query60  298 266 273 266
   query61  97  124 91  91
   query62  882 646 658 646
   query63  217 179 181 179
   query64  4642189518491849
   query65  3163307830873078
   query66  841 335 334 334
   query67  15015   14859   14689   14689
   query68  4419570 577 570
   query69  679 374 310 310
   query70  1102105610391039
   query71  413 288 282 282
   query72  7709283126362636
   query73  787 328 329 328
   query74  5968563756655637
   query75  3396271627132713
   query76  2822121712881217
   query77  551 312 314 312
   query78  9550893788178817
   query79  1695529 533 529
   query80  2041536 526 526
   query81  561 231 234 231
   query82  640 133 133 133
   query83  268 174 175 174
   query84  267 86  86  86
   query85  1208355 303 303
   query86  463 300 293 293
   query87  3276306631123066
   query88  3707241224352412
   query89  385 285 292 285
   query90  1811194 193 193
   query91  122 100 97  97
   query92  60  49  49  49
   query93  2068611 612 611
   query94  743 288 297 288
   query95  377 273 268 268
   query96  601 283 284 283
   query97  3218307130623062
   query98  226 198 186 186
   query99  1612128212741274
   Total cold run time: 258220 ms
   Total hot run time: 168811 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 

(doris) branch branch-2.1 updated: [fix](multicatalog) fix hadoop authenticator not inited for existing hms catalog. (#38930)

2024-08-06 Thread morningman
This is an automated email from the ASF dual-hosted git repository.

morningman pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.1 by this push:
 new 5066be6df34 [fix](multicatalog) fix hadoop authenticator not inited 
for existing hms catalog. (#38930)
5066be6df34 is described below

commit 5066be6df34415bf538f8b36006f37af94772405
Author: Qi Chen 
AuthorDate: Tue Aug 6 15:34:32 2024 +0800

[fix](multicatalog) fix hadoop authenticator not inited for existing hms 
catalog. (#38930)

Backport #38475.

Co-authored-by: Yulei-Yang 
---
 .../java/org/apache/doris/datasource/hive/HMSExternalCatalog.java| 5 +
 1 file changed, 5 insertions(+)

diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/datasource/hive/HMSExternalCatalog.java
 
b/fe/fe-core/src/main/java/org/apache/doris/datasource/hive/HMSExternalCatalog.java
index a22eacaf1e4..be9bf388adb 100644
--- 
a/fe/fe-core/src/main/java/org/apache/doris/datasource/hive/HMSExternalCatalog.java
+++ 
b/fe/fe-core/src/main/java/org/apache/doris/datasource/hive/HMSExternalCatalog.java
@@ -138,6 +138,11 @@ public class HMSExternalCatalog extends ExternalCatalog {
 
 @Override
 protected void initLocalObjectsImpl() {
+if (authenticator == null) {
+AuthenticationConfig config = 
AuthenticationConfig.getKerberosConfig(getConfiguration());
+authenticator = HadoopAuthenticator.getHadoopAuthenticator(config);
+}
+
 HiveConf hiveConf = null;
 JdbcClientConfig jdbcClientConfig = null;
 String hiveMetastoreType = 
catalogProperty.getOrDefault(HMSProperties.HIVE_METASTORE_TYPE, "");


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



Re: [PR] [opt](nereids) update the mothods to get table row count [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 173248 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 64264fb3bdb1834acea5424b7df74851aab9c64f, 
data reload: false
   
   query1   1786869 855 855
   query2   6481174817511748
   query3   10728   391639073907
   query4   20083   17545   17304   17304
   query5   5604531 514 514
   query6   292 174 167 167
   query7   4020291 297 291
   query8   245 187 205 187
   query9   8373240223822382
   query10  472 265 271 265
   query11  10598   10077   99259925
   query12  140 89  87  87
   query13  1546377 360 360
   query14  10556   695660736073
   query15  222 164 163 163
   query16  7558463 488 463
   query17  1119578 566 566
   query18  1970296 297 296
   query19  203 148 151 148
   query20  100 93  88  88
   query21  210 100 99  99
   query22  4366397341373973
   query23  34151   33728   33576   33576
   query24  9415318332023183
   query25  656 444 445 444
   query26  788 153 159 153
   query27  2227311 289 289
   query28  5126204821162048
   query29  951 453 436 436
   query30  247 165 159 159
   query31  972 801 789 789
   query32  89  53  55  53
   query33  695 308 324 308
   query34  918 491 496 491
   query35  871 746 729 729
   query36  1004849 887 849
   query37  142 78  78  78
   query38  2883280728012801
   query39  864 823 806 806
   query40  193 112 111 111
   query41  45  44  46  44
   query42  126 98  97  97
   query43  487 426 423 423
   query44  1169728 735 728
   query45  212 180 178 178
   query46  1087806 795 795
   query47  1821170517351705
   query48  355 293 292 292
   query49  804 430 446 430
   query50  915 441 435 435
   query51  6634673867326732
   query52  117 93  92  92
   query53  258 182 180 180
   query54  611 456 462 456
   query55  74  79  76  76
   query56  299 271 265 265
   query57  1145104510581045
   query58  270 258 267 258
   query59  2561245224022402
   query60  319 271 278 271
   query61  99  94  94  94
   query62  872 647 653 647
   query63  213 189 185 185
   query64  4776192419461924
   query65  3155310231273102
   query66  777 332 337 332
   query67  15379   14644   14789   14644
   query68  5355578 579 578
   query69  714 393 308 308
   query70  1179109410391039
   query71  505 287 292 287
   query72  7663269325042504
   query73  920 328 337 328
   query74  6020576756775677
   query75  3882273227212721
   query76  3505124112631241
   query77  573 334 318 318
   query78  9420900889398939
   query79  2277537 530 530
   query80  1187570 511 511
   query81  558 230 230 230
   query82  1532131 131 131
   query83  242 174 169 169
   query84  238 80  79  79
   query85  1333320 305 305
   query86  439 310 296 296
   query87  3271309830893089
   query88  3675245923932393
   query89  443 292 288 288
   query90  2106193 185 185
   query91  130 98  100 98
   query92  59  50  51  50
   query93  3847609 619 609
   query94  946 292 305 292
   query95  384 279 272 272
   query96  618 279 286 279
   query97  3241310530523052
   query98  223 209 202 202
   query99  1613125212841252
   Total cold run time: 271542 ms
   Total hot run time: 173248 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](Exception) throw exception in defer may result std::terminate [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 170087 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 e35b5269c04c5d735ed2bb626e41e40771e17ffb, 
data reload: false
   
   query1   913 378 371 371
   query2   6475180116981698
   query3   6651216 226 216
   query4   19412   17443   17339   17339
   query5   3670528 530 528
   query6   268 181 171 171
   query7   4602299 295 295
   query8   270 212 202 202
   query9   8515240823752375
   query10  431 305 267 267
   query11  10444   997810167   9978
   query12  120 89  90  89
   query13  1640367 358 358
   query14  9941694072456940
   query15  209 162 161 161
   query16  6930457 471 457
   query17  922 561 561 561
   query18  1926286 278 278
   query19  199 139 144 139
   query20  92  85  86  85
   query21  201 105 101 101
   query22  4263404640334033
   query23  33845   33868   33638   33638
   query24  9422314331793143
   query25  652 422 430 422
   query26  1156155 153 153
   query27  3329291 293 291
   query28  7337203120252025
   query29  998 435 430 430
   query30  240 171 159 159
   query31  954 785 802 785
   query32  112 61  60  60
   query33  726 330 361 330
   query34  973 487 511 487
   query35  854 770 735 735
   query36  985 876 872 872
   query37  173 78  80  78
   query38  2906275027762750
   query39  844 801 813 801
   query40  283 113 114 113
   query41  46  44  44  44
   query42  126 100 95  95
   query43  484 423 425 423
   query44  1181724 733 724
   query45  211 178 178 178
   query46  1095813 825 813
   query47  1793170117221701
   query48  368 292 289 289
   query49  893 421 444 421
   query50  911 436 441 436
   query51  6820670566686668
   query52  106 90  90  90
   query53  265 182 178 178
   query54  649 465 465 465
   query55  79  72  72  72
   query56  280 249 251 249
   query57  1114103610451036
   query58  283 287 263 263
   query59  2601240622172217
   query60  308 269 281 269
   query61  100 97  91  91
   query62  879 656 667 656
   query63  213 182 180 180
   query64  4779189118851885
   query65  3173310730913091
   query66  990 340 336 336
   query67  15172   14806   14845   14806
   query68  4321568 579 568
   query69  433 302 300 300
   query70  1113108610851085
   query71  375 286 281 281
   query72  7087265925412541
   query73  757 336 330 330
   query74  5985569456625662
   query75  3375272927322729
   query76  2151126212761262
   query77  467 313 309 309
   query78  9423902789308930
   query79  1187539 532 532
   query80  1502510 503 503
   query81  550 228 231 228
   query82  1212136 132 132
   query83  276 175 173 173
   query84  265 82  79  79
   query85  1176329 307 307
   query86  415 305 294 294
   query87  3319311131283111
   query88  2919243724692437
   query89  399 295 305 295
   query90  1769204 206 204
   query91  136 114 114 114
   query92  63  50  55  50
   query93  1292622 624 622
   query94  807 314 316 314
   query95  399 283 294 283
   query96  613 283 288 283
   query97  3254305830743058
   query98  222 207 199 199
   query99  1625128213031282
   Total cold run time: 257689 ms
   Total hot run time: 170087 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](optimizer) Remove unused code for unify code [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 168990 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 685b2d134a6fa3bcb540757953d6f1378ed376e2, 
data reload: false
   
   query1   923 379 364 364
   query2   6486169217501692
   query3   6650213 227 213
   query4   20292   17151   17416   17151
   query5   3656512 541 512
   query6   259 165 162 162
   query7   4590298 301 298
   query8   257 202 192 192
   query9   8526239423762376
   query10  432 283 270 270
   query11  10523   10071   99899989
   query12  123 90  90  90
   query13  1647379 386 379
   query14  9104676173896761
   query15  202 171 164 164
   query16  6856456 471 456
   query17  972 594 564 564
   query18  1920300 288 288
   query19  196 147 151 147
   query20  95  84  87  84
   query21  212 103 99  99
   query22  4333405939583958
   query23  33774   33597   33512   33512
   query24  10264   312231173117
   query25  700 479 397 397
   query26  1995149 157 149
   query27  2821288 290 288
   query28  7323204920282028
   query29  1343433 429 429
   query30  235 158 153 153
   query31  940 765 774 765
   query32  101 61  59  59
   query33  657 317 327 317
   query34  916 525 492 492
   query35  864 779 779 779
   query36  1097922 909 909
   query37  239 84  85  84
   query38  3023290728352835
   query39  885 804 827 804
   query40  280 115 114 114
   query41  46  47  44  44
   query42  119 98  93  93
   query43  491 420 412 412
   query44  1193723 723 723
   query45  208 176 177 176
   query46  1071802 779 779
   query47  1787172517331725
   query48  362 290 290 290
   query49  991 413 422 413
   query50  895 438 438 438
   query51  6721663665196519
   query52  98  86  101 86
   query53  256 186 182 182
   query54  610 459 455 455
   query55  79  79  76  76
   query56  293 250 266 250
   query57  1140105710171017
   query58  273 269 274 269
   query59  2620236723622362
   query60  300 271 272 271
   query61  121 92  99  92
   query62  879 646 636 636
   query63  211 188 180 180
   query64  5579190918851885
   query65  3160312230883088
   query66  1345348 332 332
   query67  15253   14870   14664   14664
   query68  4386566 563 563
   query69  452 293 311 293
   query70  1088108710771077
   query71  424 283 275 275
   query72  7058268424802480
   query73  767 327 327 327
   query74  6013572755835583
   query75  3438271127652711
   query76  2631118412331184
   query77  443 305 302 302
   query78  9470891889168916
   query79  2331535 538 535
   query80  1195513 519 513
   query81  548 227 219 219
   query82  994 133 132 132
   query83  256 177 175 175
   query84  266 79  82  79
   query85  1302330 310 310
   query86  457 314 297 297
   query87  3287309730993097
   query88  3099241024052405
   query89  382 290 286 286
   query90  1818189 194 189
   query91  127 99  101 99
   query92  62  49  48  48
   query93  1878622 617 617
   query94  831 309 300 300
   query95  377 283 267 267
   query96  595 286 282 282
   query97  3204304930583049
   query98  218 207 199 199
   query99  1632130412841284
   Total cold run time: 262841 ms
   Total hot run time: 168990 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 s

Re: [PR] [chore](show partitions) show partitions print commit version [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 170181 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 c7586e6d46629d8647f3815ef87bda21ba819b2c, 
data reload: false
   
   query1   908 374 373 373
   query2   6480168016991680
   query3   6676208 220 208
   query4   20427   17405   17205   17205
   query5   3649539 546 539
   query6   278 189 166 166
   query7   4598302 298 298
   query8   262 211 199 199
   query9   8510236923722369
   query10  417 300 264 264
   query11  10680   10028   10052   10028
   query12  119 92  90  90
   query13  1643386 392 386
   query14  10100   720269106910
   query15  215 159 166 159
   query16  6974439 457 439
   query17  966 597 566 566
   query18  1889291 293 291
   query19  204 151 149 149
   query20  102 91  92  91
   query21  209 102 105 102
   query22  4234411441634114
   query23  34170   33441   33643   33441
   query24  9536312931393129
   query25  718 441 463 441
   query26  1495172 163 163
   query27  3088303 291 291
   query28  7406203920072007
   query29  1141472 479 472
   query30  243 172 159 159
   query31  977 800 791 791
   query32  104 58  58  58
   query33  726 348 352 348
   query34  968 510 515 510
   query35  865 788 775 775
   query36  1053913 910 910
   query37  166 82  82  82
   query38  2860276627962766
   query39  850 818 845 818
   query40  268 121 120 120
   query41  51  45  48  45
   query42  130 100 101 100
   query43  481 429 430 429
   query44  1215740 736 736
   query45  210 181 185 181
   query46  1092832 794 794
   query47  1822174517321732
   query48  376 303 300 300
   query49  979 461 484 461
   query50  918 450 444 444
   query51  6765661765706570
   query52  103 90  96  90
   query53  264 194 191 191
   query54  653 467 476 467
   query55  76  78  77  77
   query56  287 266 283 266
   query57  1210996 1036996
   query58  275 282 286 282
   query59  2592242025142420
   query60  299 273 280 273
   query61  104 92  91  91
   query62  905 662 634 634
   query63  222 187 189 187
   query64  5476192819101910
   query65  3193307331103073
   query66  1013333 324 324
   query67  15552   15009   14836   14836
   query68  6650586 578 578
   query69  783 396 315 315
   query70  1165109810891089
   query71  508 288 280 280
   query72  8062265825232523
   query73  962 329 333 329
   query74  6073569255755575
   query75  4180271427192714
   query76  5093127812681268
   query77  771 319 304 304
   query78  9532909589448944
   query79  3419527 535 527
   query80  2037522 519 519
   query81  575 233 225 225
   query82  745 141 138 138
   query83  291 176 181 176
   query84  265 87  82  82
   query85  1460318 312 312
   query86  463 315 295 295
   query87  3271316031153115
   query88  3569242824262426
   query89  405 306 288 288
   query90  1972205 199 199
   query91  127 104 101 101
   query92  65  52  52  52
   query93  2777626 630 626
   query94  918 319 311 311
   query95  386 277 274 274
   query96  614 292 280 280
   query97  3204306630233023
   query98  216 203 194 194
   query99  1604129912831283
   Total cold run time: 274599 ms
   Total hot run time: 170181 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] [function](cast)Make string casting to integers more like MySQL's behavior [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 169248 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 ad92efd343eac4184a59fdfadbf26f606a1f4d13, 
data reload: false
   
   query1   928 381 369 369
   query2   6467171416691669
   query3   6655213 227 213
   query4   20153   17490   17392   17392
   query5   3638521 511 511
   query6   292 164 158 158
   query7   4607306 294 294
   query8   254 192 197 192
   query9   8504238623652365
   query10  428 277 262 262
   query11  10544   999310011   9993
   query12  115 83  83  83
   query13  1621369 368 368
   query14  9500677075066770
   query15  198 169 162 162
   query16  6958429 444 429
   query17  942 580 583 580
   query18  1912287 310 287
   query19  191 138 148 138
   query20  92  84  84  84
   query21  207 97  96  96
   query22  4220398541163985
   query23  33702   33578   33597   33578
   query24  10159   312230993099
   query25  689 388 414 388
   query26  1670153 163 153
   query27  2958294 282 282
   query28  7429204920242024
   query29  1180472 452 452
   query30  235 161 163 161
   query31  983 812 781 781
   query32  107 64  61  61
   query33  699 338 347 338
   query34  925 529 490 490
   query35  865 759 742 742
   query36  993 877 873 873
   query37  196 79  77  77
   query38  2888278827572757
   query39  861 809 804 804
   query40  256 116 113 113
   query41  45  43  44  43
   query42  124 99  99  99
   query43  451 417 411 411
   query44  1177735 746 735
   query45  210 175 178 175
   query46  1093830 769 769
   query47  1835172717431727
   query48  354 288 291 288
   query49  901 422 419 419
   query50  908 436 431 431
   query51  6684671166486648
   query52  101 88  88  88
   query53  253 178 177 177
   query54  624 440 451 440
   query55  76  77  73  73
   query56  302 253 251 251
   query57  1117103810261026
   query58  279 266 275 266
   query59  2573233223932332
   query60  308 278 277 277
   query61  97  93  94  93
   query62  889 656 639 639
   query63  208 180 182 180
   query64  5650191118961896
   query65  3152309030853085
   query66  1315340 351 340
   query67  15513   14696   14769   14696
   query68  4306566 581 566
   query69  437 327 313 313
   query70  1187104910961049
   query71  371 283 271 271
   query72  7037272024802480
   query73  756 324 378 324
   query74  6077566357175663
   query75  3363268427402684
   query76  2169122812771228
   query77  416 306 308 306
   query78  9492900388978897
   query79  2722538 535 535
   query80  1143503 516 503
   query81  580 218 228 218
   query82  1009131 128 128
   query83  237 170 171 170
   query84  265 81  79  79
   query85  1259320 300 300
   query86  480 297 312 297
   query87  3284310530683068
   query88  3904242924162416
   query89  391 287 280 280
   query90  1743192 191 191
   query91  126 100 160 100
   query92  65  49  48  48
   query93  2055614 627 614
   query94  829 293 298 293
   query95  379 272 265 265
   query96  611 282 285 282
   query97  3211308130393039
   query98  231 194 197 194
   query99  1596128212701270
   Total cold run time: 263191 ms
   Total hot run time: 169248 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](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.31 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 495e6d801ba58b975d624dee2a8ac291967fe481, 
data reload: false
   
   query1   0.020.020.02
   query2   0.070.030.03
   query3   0.250.040.05
   query4   1.790.060.06
   query5   0.540.530.52
   query6   1.230.620.62
   query7   0.020.010.01
   query8   0.030.020.03
   query9   0.540.490.48
   query10  0.530.540.54
   query11  0.120.080.09
   query12  0.120.090.09
   query13  0.620.610.61
   query14  0.780.780.83
   query15  0.790.760.76
   query16  0.390.360.38
   query17  1.021.001.02
   query18  0.240.240.24
   query19  1.921.821.84
   query20  0.010.010.02
   query21  15.47   0.580.60
   query22  1.941.921.91
   query23  17.40   1.080.92
   query24  4.651.231.16
   query25  0.410.140.05
   query26  0.550.160.15
   query27  0.050.040.04
   query28  8.050.740.71
   query29  12.60   2.332.32
   query30  0.590.550.56
   query31  2.820.390.39
   query32  3.350.490.49
   query33  3.063.073.10
   query34  15.27   4.814.76
   query35  4.864.844.84
   query36  1.041.021.02
   query37  0.060.040.05
   query38  0.030.020.02
   query39  0.020.010.02
   query40  0.160.140.14
   query41  0.060.020.02
   query42  0.020.010.02
   query43  0.020.020.02
   Total cold run time: 103.51 s
   Total hot run time: 31.31 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](nereids) adjust broadcast/shuffle join [doris]

2024-08-06 Thread via GitHub


englefly commented on PR #37823:
URL: https://github.com/apache/doris/pull/37823#issuecomment-2270588232

   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] [Optimize](Row store) pick #37145, #38236 [doris]

2024-08-06 Thread via GitHub


lxr599 commented on PR #38932:
URL: https://github.com/apache/doris/pull/38932#issuecomment-2270589094

   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](log) Remove unnecessary warning log (#37093) [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 203803 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 1bba06f3af26603221cd12e4e950e4f6c2f92406, 
data reload: false
   
   query1   920 418 375 375
   query2   6555283329172833
   query3   6917218 203 203
   query4   21319   18167   18131   18131
   query5   19721   649165526491
   query6   291 226 222 222
   query7   4152308 316 308
   query8   403 398 397 397
   query9   3133267025902590
   query10  419 307 296 296
   query11  11325   10637   10739   10637
   query12  128 76  75  75
   query13  5600709 711 709
   query14  17827   13284   13271   13271
   query15  369 238 254 238
   query16  6461283 266 266
   query17  17131442889 889
   query18  2316430 413 413
   query19  208 157 153 153
   query20  81  78  84  78
   query21  194 98  92  92
   query22  5196508249954995
   query23  32534   31974   32034   31974
   query24  7061646865716468
   query25  535 439 424 424
   query26  641 167 165 165
   query27  2037302 301 301
   query28  6197233623122312
   query29  2945279526352635
   query30  241 165 170 165
   query31  901 726 745 726
   query32  70  65  63  63
   query33  400 270 255 255
   query34  883 483 486 483
   query35  1123946 943 943
   query36  1280115712271157
   query37  90  61  63  61
   query38  3095287729452877
   query39  1391131913191319
   query40  275 97  94  94
   query41  49  45  43  43
   query42  88  82  86  82
   query43  748 717 681 681
   query44  1137724 717 717
   query45  250 244 241 241
   query46  1228971 982 971
   query47  1991186017161716
   query48  1023742 708 708
   query49  648 368 383 368
   query50  859 640 612 612
   query51  4776469446554655
   query52  97  88  88  88
   query53  454 321 333 321
   query54  2651247024762470
   query55  93  80  94  80
   query56  248 223 216 216
   query57  1177106710961067
   query58  224 215 193 193
   query59  4075392340803923
   query60  218 211 215 211
   query61  101 95  97  95
   query62  831 507 524 507
   query63  482 345 347 345
   query64  2609156513791379
   query65  3688360935193519
   query66  815 379 384 379
   query67  16289   15530   15001   15001
   query68  10171   679 662 662
   query69  577 356 349 349
   query70  1786140313421342
   query71  419 314 301 301
   query72  6561351235483512
   query73  746 320 327 320
   query74  6354583758135813
   query75  5402384236973697
   query76  6331111211321112
   query77  1092260 258 258
   query78  12853   14508   12033   12033
   query79  8738629 651 629
   query80  717 404 412 404
   query81  494 232 236 232
   query82  766 102 94  94
   query83  168 135 133 133
   query84  254 70  72  70
   query85  785 333 339 333
   query86  320 315 293 293
   query87  3196305230053005
   query88  4501229922972297
   query89  401 294 314 294
   query90  1861212 209 209
   query91  180 157 142 142
   query92  60  55  52  52
   query93  4629573 554 554
   query94  625 206 209 206
   query95  1135108310611061
   query96  643 326 333 326
   query97  6543633863646338
   query98  202 174 178 174
   query99  2623941 886 886
   Total cold run time: 314929 ms
   Total hot run time: 203803 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] [Fix](inverted index) fix missed array inverted index null bitmap #38907 [doris]

2024-08-06 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 495e6d801ba58b975d624dee2a8ac291967fe481 with 
default session variables
   Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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.4 seconds inserted 1000 Rows, about 467K 
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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41413 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9e2969a81fc74a93ddc23b8491abd511ea32c2d7, 
data reload: false
   
   -- Round 1 --
   q1   17628   408540694069
   q2   2016202 205 202
   q3   10463   131813601318
   q4   10162   820 875 820
   q5   7641298429372937
   q6   220 140 142 140
   q7   1058612 619 612
   q8   9423176819361768
   q9   8498659866056598
   q10  8731385238373837
   q11  438 251 259 251
   q12  409 229 233 229
   q13  17770   294229322932
   q14  272 244 242 242
   q15  518 486 500 486
   q16  527 391 387 387
   q17  964 909 885 885
   q18  7885723771837183
   q19  1398121612201216
   q20  549 330 353 330
   q21  5253474146904690
   q22  345 284 281 281
   Total cold run time: 112168 ms
   Total hot run time: 41413 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4037401240124012
   q2   327 224 223 223
   q3   2980300930703009
   q4   2006195819341934
   q5   5515552054375437
   q6   238 138 132 132
   q7   2089173117661731
   q8   3316338733243324
   q9   8660865087198650
   q10  3932406239423942
   q11  562 461 467 461
   q12  762 595 608 595
   q13  16484   309330973093
   q14  301 294 287 287
   q15  520 486 478 478
   q16  450 415 421 415
   q17  1746172617371726
   q18  8193769576587658
   q19  1714173017191719
   q20  2065186718901867
   q21  5773543152835283
   q22  540 453 481 453
   Total cold run time: 72210 ms
   Total hot run time: 56429 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](inverted index) fix multi match result error [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.71 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9f9ffa465d0578d000ae05d95b20029173ebd253, 
data reload: false
   
   query1   0.040.040.04
   query2   0.080.040.03
   query3   0.220.040.04
   query4   1.680.060.06
   query5   0.480.490.48
   query6   1.150.720.71
   query7   0.020.010.02
   query8   0.050.040.04
   query9   0.570.500.52
   query10  0.570.580.58
   query11  0.160.110.12
   query12  0.150.120.13
   query13  0.610.620.60
   query14  0.760.790.80
   query15  0.910.850.88
   query16  0.360.350.35
   query17  1.011.051.01
   query18  0.210.220.20
   query19  1.811.721.71
   query20  0.010.010.01
   query21  15.38   0.770.66
   query22  3.908.421.12
   query23  17.74   1.301.25
   query24  2.270.220.21
   query25  0.180.080.08
   query26  0.330.220.22
   query27  0.460.240.23
   query28  13.17   1.000.97
   query29  12.55   3.343.34
   query30  0.250.060.05
   query31  2.870.400.40
   query32  3.250.490.49
   query33  2.962.942.90
   query34  15.47   4.284.20
   query35  4.314.304.29
   query36  0.690.470.48
   query37  0.190.160.16
   query38  0.150.150.14
   query39  0.040.040.03
   query40  0.160.130.14
   query41  0.100.050.05
   query42  0.060.050.04
   query43  0.050.040.04
   Total cold run time: 107.38 s
   Total hot run time: 29.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] [opt](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 49642 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 83dd9966c9cd901657eec5d5abadd7dfc2f1a2b6, 
data reload: false
   
   -- Round 1 --
   q1   18071   434943344334
   q2   2080155 144 144
   q3   10331   186319161863
   q4   10365   123313161233
   q5   8402392439433924
   q6   233 123 125 123
   q7   2050161915781578
   q8   9264272727072707
   q9   10883   10510   10330   10330
   q10  8605351435343514
   q11  422 252 252 252
   q12  477 301 300 300
   q13  18344   392939943929
   q14  349 337 324 324
   q15  503 454 454 454
   q16  680 569 569 569
   q17  1125934 956 934
   q18  7205676568476765
   q19  1769163115741574
   q20  532 318 306 306
   q21  4421410640404040
   q22  520 445 446 445
   Total cold run time: 116631 ms
   Total hot run time: 49642 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4327427242794272
   q2   315 233 229 229
   q3   4186413341784133
   q4   2768273727462737
   q5   7237719071917190
   q6   243 121 118 118
   q7   3237287428012801
   q8   4364448244384438
   q9   17399   17128   16962   16962
   q10  4245425642844256
   q11  752 659 682 659
   q12  1033846 883 846
   q13  7024375237303730
   q14  454 424 417 417
   q15  498 453 459 453
   q16  738 686 686 686
   q17  3859375237553752
   q18  8749871688418716
   q19  1714171616181618
   q20  2435215121062106
   q21  8583843184588431
   q22  1025977 978 977
   Total cold run time: 85185 ms
   Total hot run time: 79527 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](Exception) throw exception in defer may result std::terminate [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.85 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e35b5269c04c5d735ed2bb626e41e40771e17ffb, 
data reload: false
   
   query1   0.050.040.04
   query2   0.070.040.04
   query3   0.220.050.05
   query4   1.680.060.07
   query5   0.480.470.48
   query6   1.130.720.71
   query7   0.020.020.01
   query8   0.050.040.04
   query9   0.570.520.52
   query10  0.590.570.57
   query11  0.160.120.12
   query12  0.150.130.13
   query13  0.600.610.60
   query14  0.770.800.80
   query15  0.920.860.86
   query16  0.350.360.35
   query17  0.971.021.01
   query18  0.210.210.21
   query19  1.851.771.75
   query20  0.010.000.01
   query21  15.38   0.740.65
   query22  3.806.982.05
   query23  18.18   1.331.24
   query24  2.260.220.22
   query25  0.170.080.08
   query26  0.320.220.21
   query27  0.460.240.23
   query28  13.16   0.990.97
   query29  12.64   3.313.31
   query30  0.250.060.06
   query31  2.880.420.41
   query32  3.220.480.48
   query33  2.952.982.95
   query34  15.43   4.264.26
   query35  4.294.304.30
   query36  0.670.470.48
   query37  0.200.170.17
   query38  0.170.150.16
   query39  0.040.030.04
   query40  0.160.140.14
   query41  0.100.050.05
   query42  0.050.050.04
   query43  0.050.040.04
   Total cold run time: 107.68 s
   Total hot run time: 30.85 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](optimizer) Remove unused code for unify code [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.32 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 685b2d134a6fa3bcb540757953d6f1378ed376e2, 
data reload: false
   
   query1   0.050.040.04
   query2   0.080.040.03
   query3   0.220.040.05
   query4   1.680.070.06
   query5   0.480.490.48
   query6   1.150.720.72
   query7   0.020.010.01
   query8   0.050.050.05
   query9   0.560.520.52
   query10  0.570.570.57
   query11  0.160.120.12
   query12  0.140.120.12
   query13  0.600.610.60
   query14  0.780.800.80
   query15  0.950.860.87
   query16  0.360.370.35
   query17  1.001.000.98
   query18  0.230.210.21
   query19  1.831.741.75
   query20  0.010.030.01
   query21  15.39   0.760.66
   query22  4.057.041.50
   query23  18.02   1.391.29
   query24  2.250.230.23
   query25  0.190.090.08
   query26  0.320.220.21
   query27  0.460.250.25
   query28  13.16   1.010.97
   query29  12.53   3.323.31
   query30  0.260.050.06
   query31  2.870.400.42
   query32  3.240.500.49
   query33  2.992.962.95
   query34  15.41   4.264.26
   query35  4.304.264.30
   query36  0.680.480.49
   query37  0.190.170.16
   query38  0.170.160.16
   query39  0.040.030.04
   query40  0.150.140.14
   query41  0.100.050.04
   query42  0.060.050.05
   query43  0.050.040.04
   Total cold run time: 107.8 s
   Total hot run time: 30.32 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] [chore](show partitions) show partitions print commit version [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.86 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit c7586e6d46629d8647f3815ef87bda21ba819b2c, 
data reload: false
   
   query1   0.050.040.04
   query2   0.070.040.04
   query3   0.220.040.04
   query4   1.680.060.07
   query5   0.480.480.49
   query6   1.140.720.71
   query7   0.020.020.01
   query8   0.050.050.05
   query9   0.560.530.52
   query10  0.560.550.56
   query11  0.160.120.12
   query12  0.150.120.12
   query13  0.610.610.60
   query14  0.770.790.79
   query15  0.940.880.86
   query16  0.340.360.35
   query17  1.000.980.98
   query18  0.230.220.21
   query19  1.821.781.76
   query20  0.030.010.01
   query21  15.41   0.750.67
   query22  4.328.361.17
   query23  17.82   1.341.32
   query24  2.260.220.23
   query25  0.190.080.08
   query26  0.330.220.21
   query27  0.460.230.23
   query28  13.19   1.010.96
   query29  12.55   3.303.26
   query30  0.250.060.05
   query31  2.850.410.39
   query32  3.260.490.49
   query33  2.952.962.93
   query34  15.48   4.244.27
   query35  4.284.284.27
   query36  0.690.470.49
   query37  0.190.170.17
   query38  0.160.150.15
   query39  0.040.030.03
   query40  0.160.130.14
   query41  0.100.040.05
   query42  0.060.050.04
   query43  0.050.050.04
   Total cold run time: 107.93 s
   Total hot run time: 29.86 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] [function](cast)Make string casting to integers more like MySQL's behavior [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.89 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit ad92efd343eac4184a59fdfadbf26f606a1f4d13, 
data reload: false
   
   query1   0.040.040.04
   query2   0.070.040.04
   query3   0.220.050.05
   query4   1.680.070.06
   query5   0.500.480.48
   query6   1.160.720.72
   query7   0.020.020.01
   query8   0.050.040.04
   query9   0.580.500.52
   query10  0.550.570.57
   query11  0.160.120.12
   query12  0.150.120.12
   query13  0.620.620.58
   query14  0.770.800.79
   query15  0.900.860.86
   query16  0.350.360.35
   query17  0.971.000.97
   query18  0.210.210.21
   query19  1.831.721.72
   query20  0.010.020.01
   query21  15.40   0.780.65
   query22  4.268.121.30
   query23  17.92   1.351.28
   query24  2.220.230.22
   query25  0.190.090.09
   query26  0.320.220.22
   query27  0.470.240.23
   query28  13.18   1.010.96
   query29  12.58   3.253.25
   query30  0.260.070.06
   query31  2.850.410.40
   query32  3.250.500.48
   query33  2.962.972.91
   query34  15.46   4.244.22
   query35  4.304.304.31
   query36  0.680.480.48
   query37  0.200.160.16
   query38  0.170.150.15
   query39  0.040.040.04
   query40  0.160.120.12
   query41  0.090.050.05
   query42  0.060.040.04
   query43  0.050.040.05
   Total cold run time: 107.91 s
   Total hot run time: 29.89 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] [Optimize](Row store) pick #37145, #38236 [doris]

2024-08-06 Thread via GitHub


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

   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] [opt](log) Remove unnecessary warning log (#37093) [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.1 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1bba06f3af26603221cd12e4e950e4f6c2f92406, 
data reload: false
   
   query1   0.030.030.02
   query2   0.080.020.02
   query3   0.250.050.05
   query4   1.800.070.07
   query5   0.540.520.52
   query6   1.240.620.66
   query7   0.020.010.01
   query8   0.030.020.03
   query9   0.540.510.48
   query10  0.530.550.53
   query11  0.130.090.09
   query12  0.120.090.09
   query13  0.620.620.60
   query14  0.780.780.79
   query15  0.770.750.77
   query16  0.370.380.36
   query17  1.040.980.96
   query18  0.220.270.25
   query19  1.891.861.83
   query20  0.010.010.01
   query21  15.46   0.580.56
   query22  1.891.761.77
   query23  17.26   0.961.09
   query24  6.071.241.14
   query25  0.360.110.05
   query26  0.680.160.15
   query27  0.050.040.04
   query28  6.710.730.74
   query29  12.62   2.342.32
   query30  0.610.540.53
   query31  2.820.400.37
   query32  3.380.500.50
   query33  3.103.093.04
   query34  15.27   4.824.81
   query35  4.874.834.84
   query36  1.061.011.01
   query37  0.060.040.05
   query38  0.040.020.02
   query39  0.020.020.01
   query40  0.160.140.15
   query41  0.070.010.01
   query42  0.020.010.01
   query43  0.020.010.02
   Total cold run time: 103.61 s
   Total hot run time: 31.1 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](nereids) fix partition_prune or expression evaluate wrongly [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 169209 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 e5118a617a05e9764a0d9000855fe24ac61ad6d8, 
data reload: false
   
   query1   912 378 370 370
   query2   6479174117141714
   query3   210 219 210
   query4   20282   17349   17126   17126
   query5   3660537 504 504
   query6   269 175 176 175
   query7   4601304 294 294
   query8   259 195 197 195
   query9   8504240123932393
   query10  428 274 287 274
   query11  10597   10182   99829982
   query12  125 87  89  87
   query13  1634381 373 373
   query14  9320703868156815
   query15  216 162 167 162
   query16  6942463 443 443
   query17  958 568 559 559
   query18  1799292 289 289
   query19  214 152 148 148
   query20  93  86  89  86
   query21  203 101 106 101
   query22  4045404639803980
   query23  33796   33669   33406   33406
   query24  10297   316031143114
   query25  708 449 431 431
   query26  1700161 160 160
   query27  2976291 292 291
   query28  7388206420372037
   query29  1255520 441 441
   query30  227 157 155 155
   query31  945 752 805 752
   query32  101 52  61  52
   query33  669 355 327 327
   query34  1001505 513 505
   query35  898 767 771 767
   query36  1043919 871 871
   query37  286 86  82  82
   query38  2989277127702770
   query39  878 839 829 829
   query40  251 112 110 110
   query41  47  43  42  42
   query42  127 101 103 101
   query43  480 442 424 424
   query44  1186751 728 728
   query45  211 175 180 175
   query46  1096792 786 786
   query47  1815174117171717
   query48  358 293 286 286
   query49  933 431 440 431
   query50  884 432 433 432
   query51  6729669765436543
   query52  104 93  89  89
   query53  261 184 178 178
   query54  623 447 472 447
   query55  76  73  75  73
   query56  299 264 252 252
   query57  1145101010521010
   query58  274 274 271 271
   query59  2580237423572357
   query60  304 269 269 269
   query61  95  98  100 98
   query62  884 666 652 652
   query63  208 176 182 176
   query64  5662191818851885
   query65  3173310631233106
   query66  1299326 338 326
   query67  15338   14943   15026   14943
   query68  4346566 560 560
   query69  472 307 293 293
   query70  109510471047
   query71  444 276 275 275
   query72  7741269324942494
   query73  780 337 329 329
   query74  6055569156465646
   query75  3661271727062706
   query76  2806117512731175
   query77  639 305 309 305
   query78  9413889088318831
   query79  2364543 533 533
   query80  1264506 510 506
   query81  558 228 230 228
   query82  786 131 131 131
   query83  321 170 170 170
   query84  280 81  79  79
   query85  2027327 308 308
   query86  459 293 310 293
   query87  3269315031043104
   query88  3850243524142414
   query89  398 293 295 293
   query90  1921196 195 195
   query91  127 100 104 100
   query92  57  48  49  48
   query93  2558622 629 622
   query94  954 298 299 298
   query95  397 276 273 273
   query96  619 290 284 284
   query97  3233305130453045
   query98  223 197 197 197
   query99  1645130212501250
   Total cold run time: 266583 ms
   Total hot run time: 169209 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] [Enhancement](wal) modify wal api which hard to use [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 169572 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 e665c3df377fb2d811b64a2f7e4353aa17947e1a, 
data reload: false
   
   query1   910 376 364 364
   query2   6456175217041704
   query3   6649208 220 208
   query4   18956   17526   17332   17332
   query5   3609525 519 519
   query6   281 173 178 173
   query7   4611293 298 293
   query8   271 206 198 198
   query9   8530238723342334
   query10  465 261 251 251
   query11  10440   10053   10082   10053
   query12  116 88  86  86
   query13  1634368 361 361
   query14  9279671368106713
   query15  196 161 163 161
   query16  6824452 472 452
   query17  915 551 535 535
   query18  1919275 275 275
   query19  188 149 140 140
   query20  94  84  85  84
   query21  199 99  96  96
   query22  4450410041914100
   query23  33737   33809   33575   33575
   query24  10214   318230983098
   query25  691 390 420 390
   query26  1764152 151 151
   query27  3080281 284 281
   query28  7423205720142014
   query29  1312442 437 437
   query30  244 155 161 155
   query31  927 771 776 771
   query32  108 61  59  59
   query33  687 327 332 327
   query34  938 503 507 503
   query35  905 747 757 747
   query36  1059903 874 874
   query37  277 86  82  82
   query38  2991283027692769
   query39  871 811 831 811
   query40  292 111 110 110
   query41  45  43  44  43
   query42  118 99  96  96
   query43  465 415 422 415
   query44  1167729 718 718
   query45  209 177 180 177
   query46  1085799 770 770
   query47  1846173817701738
   query48  364 296 287 287
   query49  1014409 439 409
   query50  890 437 423 423
   query51  6785677367716771
   query52  102 90  92  90
   query53  257 177 183 177
   query54  611 460 451 451
   query55  72  77  71  71
   query56  262 248 258 248
   query57  1152105710431043
   query58  277 289 265 265
   query59  2646253023732373
   query60  286 282 291 282
   query61  95  93  94  93
   query62  894 644 659 644
   query63  206 185 179 179
   query64  5635197919451945
   query65  3181307331123073
   query66  1326340 340 340
   query67  15289   14832   14886   14832
   query68  4328559 582 559
   query69  451 306 308 306
   query70  1089108211001082
   query71  420 286 280 280
   query72  7175280824592459
   query73  767 325 328 325
   query74  5973564056775640
   query75  3350269827472698
   query76  2304121912741219
   query77  435 297 296 296
   query78  9540889088948890
   query79  2405531 538 531
   query80  1130492 492 492
   query81  547 225 228 225
   query82  770 138 131 131
   query83  230 167 169 167
   query84  259 75  77  75
   query85  1897308 299 299
   query86  478 274 272 272
   query87  3287316631583158
   query88  3789238224182382
   query89  380 284 293 284
   query90  1799195 191 191
   query91  121 97  98  97
   query92  60  48  51  48
   query93  2487610 634 610
   query94  835 284 304 284
   query95  376 279 263 263
   query96  615 281 275 275
   query97  3213308330363036
   query98  212 202 195 195
   query99  1628126412961264
   Total cold run time: 263141 ms
   Total hot run time: 169572 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](testcase) make set global cases non parallel [doris]

2024-08-06 Thread via GitHub


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

   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] [opt](log) Remove unnecessary warning log (#37093) [doris]

2024-08-06 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 1bba06f3af26603221cd12e4e950e4f6c2f92406 with 
default session variables
   Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:  58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:  33 seconds loaded 861443392 Bytes, about 24 MB/s
   Insert into select:   21.7 seconds inserted 1000 Rows, about 460K 
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] [fix](testcase) make set global cases non parallel [doris]

2024-08-06 Thread via GitHub


BiteThet merged PR #38919:
URL: https://github.com/apache/doris/pull/38919


-- 
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: [fix](testcase) make set global cases non parallel (#38919)

2024-08-06 Thread panxiaolei
This is an automated email from the ASF dual-hosted git repository.

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


The following commit(s) were added to refs/heads/master by this push:
 new 38005ac51ee [fix](testcase) make set global cases non parallel (#38919)
38005ac51ee is described below

commit 38005ac51eeebae0fd192832c824220b7449dc51
Author: zclllhhjj 
AuthorDate: Tue Aug 6 15:46:53 2024 +0800

[fix](testcase) make set global cases non parallel (#38919)

make set global cases non parallel
---
 regression-test/suites/variable_p0/set_and_unset_variable.groovy | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/regression-test/suites/variable_p0/set_and_unset_variable.groovy 
b/regression-test/suites/variable_p0/set_and_unset_variable.groovy
index 0ad043cb96c..f29a56bd6d0 100644
--- a/regression-test/suites/variable_p0/set_and_unset_variable.groovy
+++ b/regression-test/suites/variable_p0/set_and_unset_variable.groovy
@@ -15,7 +15,7 @@
 // specific language governing permissions and limitations
 // under the License.
 
-suite("set_and_unset_variable") {
+suite("set_and_unset_variable", "nonConcurrent") {
 qt_cmd """UNSET VARIABLE ALL"""
 qt_cmd """UNSET global VARIABLE ALL"""
 


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



[PR] [test](inverted index) add an Inverted Index Testing Switch (#38077) [doris]

2024-08-06 Thread via GitHub


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

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


-- 
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](nereids) fix partition_prune or expression evaluate wrongly [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e5118a617a05e9764a0d9000855fe24ac61ad6d8, 
data reload: false
   
   query1   0.050.040.04
   query2   0.080.050.04
   query3   0.230.040.05
   query4   1.680.060.06
   query5   0.480.490.49
   query6   1.170.730.72
   query7   0.030.020.01
   query8   0.050.050.05
   query9   0.590.520.50
   query10  0.570.590.58
   query11  0.150.120.12
   query12  0.150.120.12
   query13  0.620.620.59
   query14  0.780.790.81
   query15  0.900.870.88
   query16  0.340.340.35
   query17  0.990.961.01
   query18  0.220.210.22
   query19  1.861.741.80
   query20  0.010.010.02
   query21  15.40   0.770.68
   query22  4.108.221.21
   query23  18.06   1.351.36
   query24  2.270.220.22
   query25  0.180.080.08
   query26  0.330.220.22
   query27  0.470.240.23
   query28  13.15   1.000.97
   query29  12.52   3.303.29
   query30  0.260.050.06
   query31  2.870.410.41
   query32  3.240.510.48
   query33  2.932.942.93
   query34  15.48   4.254.27
   query35  4.304.294.30
   query36  0.680.470.48
   query37  0.180.160.16
   query38  0.160.150.15
   query39  0.040.040.03
   query40  0.160.130.13
   query41  0.100.040.04
   query42  0.050.040.04
   query43  0.050.040.04
   Total cold run time: 107.93 s
   Total hot run time: 30 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] [test](inverted index) add an Inverted Index Testing Switch (#38077) [doris]

2024-08-06 Thread via GitHub


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

   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](inverted index) add an Inverted Index Testing Switch (#38077) [doris]

2024-08-06 Thread via GitHub


zzzxl1993 commented on PR #38947:
URL: https://github.com/apache/doris/pull/38947#issuecomment-2270609256

   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] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41461 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5f84d72352fb204767fbb35cefe2b0ebfff02f55, 
data reload: false
   
   -- Round 1 --
   q1   17901   404940584049
   q2   2026202 197 197
   q3   10473   131813071307
   q4   10169   794 913 794
   q5   7666294129752941
   q6   223 136 135 135
   q7   1048625 608 608
   q8   9449177219401772
   q9   9550660065906590
   q10  8767386938193819
   q11  426 250 251 250
   q12  450 232 229 229
   q13  17757   294529392939
   q14  276 240 240 240
   q15  517 485 487 485
   q16  523 387 390 387
   q17  960 920 934 920
   q18  7990726472697264
   q19  1482121512151215
   q20  565 328 336 328
   q21  5363471347644713
   q22  351 279 280 279
   Total cold run time: 113932 ms
   Total hot run time: 41461 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4096401040354010
   q2   335 227 219 219
   q3   3006298931492989
   q4   2016203919591959
   q5   5603544254255425
   q6   224 130 128 128
   q7   2162181218411812
   q8   3302333733543337
   q9   8614870087828700
   q10  3917400339673967
   q11  555 471 469 469
   q12  767 619 598 598
   q13  15953   314431043104
   q14  320 304 275 275
   q15  522 492 490 490
   q16  467 423 418 418
   q17  1787173317161716
   q18  8213767676737673
   q19  1720171617031703
   q20  2120185118961851
   q21  5769550652345234
   q22  525 457 458 457
   Total cold run time: 71993 ms
   Total hot run time: 56534 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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 168830 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 9e2969a81fc74a93ddc23b8491abd511ea32c2d7, 
data reload: false
   
   query1   908 377 362 362
   query2   6459171617161716
   query3   6660209 215 209
   query4   19539   17487   17117   17117
   query5   3657537 523 523
   query6   281 172 170 170
   query7   4605296 300 296
   query8   259 202 198 198
   query9   8531238723782378
   query10  453 303 280 280
   query11  10378   999098989898
   query12  122 91  90  90
   query13  1616380 372 372
   query14  9355692369036903
   query15  199 166 169 166
   query16  6896468 477 468
   query17  956 574 563 563
   query18  1927296 292 292
   query19  205 151 148 148
   query20  93  87  85  85
   query21  206 101 102 101
   query22  4155403039673967
   query23  33863   33803   33110   33110
   query24  10125   312731233123
   query25  690 404 400 400
   query26  1755157 158 157
   query27  2873278 286 278
   query28  7455205120402040
   query29  1200457 450 450
   query30  234 151 154 151
   query31  969 783 782 782
   query32  100 54  56  54
   query33  682 319 318 318
   query34  920 512 514 512
   query35  869 778 802 778
   query36  1101898 888 888
   query37  184 84  87  84
   query38  2990282927992799
   query39  887 823 810 810
   query40  250 113 112 112
   query41  46  45  45  45
   query42  119 95  96  95
   query43  471 430 443 430
   query44  1161741 719 719
   query45  206 182 178 178
   query46  1092817 796 796
   query47  1806169717221697
   query48  361 287 290 287
   query49  936 419 421 419
   query50  888 440 433 433
   query51  6774673166796679
   query52  98  88  91  88
   query53  260 189 182 182
   query54  629 446 448 446
   query55  77  77  73  73
   query56  273 257 259 257
   query57  1144104610671046
   query58  264 279 273 273
   query59  2567247823392339
   query60  303 269 281 269
   query61  98  98  97  97
   query62  874 647 633 633
   query63  213 188 181 181
   query64  5589194619031903
   query65  3137312230913091
   query66  1165329 332 329
   query67  15071   14779   14609   14609
   query68  4379576 575 575
   query69  683 394 305 305
   query70  1096108410131013
   query71  459 293 278 278
   query72  7586272624892489
   query73  782 332 335 332
   query74  5992564156885641
   query75  3580271227322712
   query76  3312118112401181
   query77  568 324 308 308
   query78  9424887188648864
   query79  2530544 527 527
   query80  1431504 498 498
   query81  568 229 223 223
   query82  755 127 134 127
   query83  249 170 169 169
   query84  278 77  81  77
   query85  1727305 291 291
   query86  467 304 317 304
   query87  3293312031093109
   query88  3836243024282428
   query89  392 300 283 283
   query90  1806199 192 192
   query91  125 100 152 100
   query92  58  51  53  51
   query93  2243615 621 615
   query94  788 302 277 277
   query95  384 271 272 271
   query96  598 284 292 284
   query97  3203308431433084
   query98  248 203 207 203
   query99  1637127712841277
   Total cold run time: 264706 ms
   Total hot run time: 168830 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] [Enhancement](wal) modify wal api which hard to use [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.25 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e665c3df377fb2d811b64a2f7e4353aa17947e1a, 
data reload: false
   
   query1   0.050.040.04
   query2   0.070.030.03
   query3   0.230.050.05
   query4   1.660.060.06
   query5   0.490.480.49
   query6   1.160.720.71
   query7   0.020.010.01
   query8   0.050.040.04
   query9   0.570.530.51
   query10  0.570.560.57
   query11  0.160.110.12
   query12  0.150.120.13
   query13  0.610.620.60
   query14  0.770.800.80
   query15  0.910.860.86
   query16  0.340.360.35
   query17  0.980.991.00
   query18  0.220.210.21
   query19  1.851.751.74
   query20  0.010.010.01
   query21  15.39   0.780.67
   query22  4.357.751.50
   query23  18.13   1.361.39
   query24  2.240.230.22
   query25  0.170.080.08
   query26  0.320.220.21
   query27  0.460.230.24
   query28  13.15   1.010.98
   query29  12.55   3.273.31
   query30  0.250.060.05
   query31  2.870.390.40
   query32  3.240.480.48
   query33  2.912.932.98
   query34  15.39   4.224.23
   query35  4.284.304.30
   query36  0.690.480.46
   query37  0.180.160.16
   query38  0.150.160.15
   query39  0.050.040.04
   query40  0.160.130.13
   query41  0.100.050.05
   query42  0.060.050.05
   query43  0.040.050.04
   Total cold run time: 108 s
   Total hot run time: 30.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] [fix](deploy)Fix unnecessary file lock release in LocalFileDeployManager which causes lots of exception log. [doris]

2024-08-06 Thread via GitHub


biohazard4321 commented on PR #38510:
URL: https://github.com/apache/doris/pull/38510#issuecomment-2270613858

   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](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 203619 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 83dd9966c9cd901657eec5d5abadd7dfc2f1a2b6, 
data reload: false
   
   query1   933 401 405 401
   query2   6522287526922692
   query3   6923207 207 207
   query4   20025   18051   18093   18051
   query5   19730   648565606485
   query6   294 210 231 210
   query7   4164313 319 313
   query8   435 443 457 443
   query9   3089265826002600
   query10  429 310 299 299
   query11  11366   10738   10692   10692
   query12  122 76  76  76
   query13  5602690 703 690
   query14  1   13249   13669   13249
   query15  366 248 241 241
   query16  6471292 265 265
   query17  14861497894 894
   query18  2271428 414 414
   query19  210 154 153 153
   query20  79  84  80  80
   query21  191 103 98  98
   query22  5195506549954995
   query23  32736   31809   31902   31809
   query24  6897664166086608
   query25  537 438 429 429
   query26  517 169 169 169
   query27  1814300 300 300
   query28  6152236223442344
   query29  2951267027452670
   query30  253 173 168 168
   query31  916 747 750 747
   query32  71  65  59  59
   query33  395 258 266 258
   query34  838 495 489 489
   query35  1125938 932 932
   query36  1274115412381154
   query37  91  61  64  61
   query38  3036290528952895
   query39  1381132113221321
   query40  209 99  94  94
   query41  47  43  48  43
   query42  81  92  81  81
   query43  685 699 634 634
   query44  1132717 716 716
   query45  251 238 235 235
   query46  1241974 998 974
   query47  1825203417881788
   query48  1015717 729 717
   query49  612 389 375 375
   query50  859 605 607 605
   query51  4784465046854650
   query52  95  84  85  84
   query53  454 330 335 330
   query54  2680247424912474
   query55  86  80  74  74
   query56  251 222 210 210
   query57  1142120711091109
   query58  222 204 189 189
   query59  4480419038573857
   query60  220 212 208 208
   query61  98  92  94  92
   query62  832 518 492 492
   query63  492 353 351 351
   query64  2550155214751475
   query65  3628357435833574
   query66  779 374 390 374
   query67  15628   14858   15484   14858
   query68  8634656 681 656
   query69  577 348 374 348
   query70  2028164415631563
   query71  415 308 308 308
   query72  6554351635223516
   query73  740 319 319 319
   query74  6264581758055805
   query75  5245365937263659
   query76  5263114512121145
   query77  897 257 246 246
   query78  12704   12094   11641   11641
   query79  13037   666 652 652
   query80  1631412 417 412
   query81  501 237 237 237
   query82  1697107 100 100
   query83  170 134 138 134
   query84  265 72  72  72
   query85  900 337 341 337
   query86  323 295 296 295
   query87  3260304129792979
   query88  5458232022932293
   query89  484 296 308 296
   query90  1976217 213 213
   query91  179 141 144 141
   query92  61  56  52  52
   query93  6959585 580 580
   query94  746 218 215 215
   query95  1113106310771063
   query96  652 331 329 329
   query97  6567634063836340
   query98  191 169 181 169
   query99  3040884 880 880
   Total cold run time: 319573 ms
   Total hot run time: 203619 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 

Re: [PR] [test](inverted index) add an Inverted Index Testing Switch (#38077) [doris]

2024-08-06 Thread via GitHub


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

   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] [improvement](mtmv) Support to use view when create mtmv [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.45 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9e2969a81fc74a93ddc23b8491abd511ea32c2d7, 
data reload: false
   
   query1   0.040.040.04
   query2   0.070.040.04
   query3   0.220.050.05
   query4   1.680.070.07
   query5   0.490.480.48
   query6   1.150.720.71
   query7   0.020.010.02
   query8   0.050.040.04
   query9   0.560.510.50
   query10  0.560.560.57
   query11  0.150.120.12
   query12  0.150.120.12
   query13  0.620.610.59
   query14  0.770.800.80
   query15  0.900.860.86
   query16  0.350.360.35
   query17  0.990.960.99
   query18  0.220.210.22
   query19  1.861.751.78
   query20  0.000.010.01
   query21  15.42   0.750.67
   query22  4.317.441.91
   query23  17.96   1.231.21
   query24  2.240.220.21
   query25  0.190.080.08
   query26  0.320.220.22
   query27  0.460.240.23
   query28  13.15   0.980.97
   query29  12.59   3.303.29
   query30  0.250.060.05
   query31  2.880.410.41
   query32  3.250.500.49
   query33  2.972.872.98
   query34  15.44   4.294.22
   query35  4.284.304.29
   query36  0.690.470.49
   query37  0.180.170.16
   query38  0.170.150.15
   query39  0.040.040.03
   query40  0.150.130.12
   query41  0.090.040.04
   query42  0.060.050.05
   query43  0.040.040.04
   Total cold run time: 107.98 s
   Total hot run time: 30.45 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](index) fix inverted index compound file entry size int32 overflow #38891 [doris]

2024-08-06 Thread via GitHub


xiaokang merged PR #38928:
URL: https://github.com/apache/doris/pull/38928


-- 
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 branch-2.1 updated: [fix](index) fix inverted index compound file entry size int32 overflow #38891 (#38928)

2024-08-06 Thread kxiao
This is an automated email from the ASF dual-hosted git repository.

kxiao pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.1 by this push:
 new 21a67dba5d8 [fix](index) fix inverted index compound file entry size 
int32 overflow #38891 (#38928)
21a67dba5d8 is described below

commit 21a67dba5d87d948fdf4d013fcaf209f0a5d56b8
Author: Kang 
AuthorDate: Tue Aug 6 15:57:09 2024 +0800

[fix](index) fix inverted index compound file entry size int32 overflow 
#38891 (#38928)
---
 be/src/olap/rowset/segment_v2/inverted_index_file_writer.h | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/be/src/olap/rowset/segment_v2/inverted_index_file_writer.h 
b/be/src/olap/rowset/segment_v2/inverted_index_file_writer.h
index 03306110a28..1d17bed4a4a 100644
--- a/be/src/olap/rowset/segment_v2/inverted_index_file_writer.h
+++ b/be/src/olap/rowset/segment_v2/inverted_index_file_writer.h
@@ -51,7 +51,7 @@ private:
 class FileInfo {
 public:
 std::string filename;
-int32_t filesize;
+int64_t filesize;
 };
 
 void sort_files(std::vector& file_infos);
@@ -95,4 +95,4 @@ private:
 size_t _file_size = 0;
 };
 } // namespace segment_v2
-} // namespace doris
\ No newline at end of file
+} // namespace doris


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



Re: [PR] [opt](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.35 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 83dd9966c9cd901657eec5d5abadd7dfc2f1a2b6, 
data reload: false
   
   query1   0.020.030.02
   query2   0.070.020.02
   query3   0.250.050.04
   query4   1.790.060.06
   query5   0.530.530.52
   query6   1.290.610.63
   query7   0.020.010.01
   query8   0.040.030.03
   query9   0.520.480.48
   query10  0.530.530.54
   query11  0.120.080.08
   query12  0.110.080.09
   query13  0.620.610.62
   query14  0.780.770.79
   query15  0.770.760.76
   query16  0.370.370.36
   query17  0.991.011.01
   query18  0.250.230.25
   query19  1.901.771.77
   query20  0.010.010.02
   query21  15.47   0.560.55
   query22  2.062.741.88
   query23  16.87   1.171.09
   query24  6.361.191.54
   query25  0.360.150.03
   query26  0.720.160.15
   query27  0.040.050.04
   query28  6.070.720.73
   query29  12.71   2.342.33
   query30  0.560.520.53
   query31  2.810.390.38
   query32  3.360.500.49
   query33  3.083.113.07
   query34  15.26   4.794.80
   query35  4.884.884.87
   query36  1.081.001.01
   query37  0.060.050.04
   query38  0.030.020.02
   query39  0.020.020.01
   query40  0.160.140.14
   query41  0.070.010.01
   query42  0.020.010.02
   query43  0.030.020.02
   Total cold run time: 103.06 s
   Total hot run time: 31.35 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](function) MicroSecondsSub without scale [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41543 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 2a47ae10b2391c75a1d870e0a72a4f37b3a0b0bf, 
data reload: false
   
   -- Round 1 --
   q1   17666   412140734073
   q2   2026203 197 197
   q3   10471   138313911383
   q4   10184   815 898 815
   q5   7644284529552845
   q6   218 136 138 136
   q7   1060621 608 608
   q8   9433187719221877
   q9   8493659265936592
   q10  8736382338343823
   q11  438 248 256 248
   q12  444 233 235 233
   q13  17756   296029272927
   q14  277 245 250 245
   q15  516 488 493 488
   q16  532 392 393 392
   q17  970 922 901 901
   q18  8034724372787243
   q19  1421121612161216
   q20  567 327 349 327
   q21  5249469647394696
   q22  359 278 286 278
   Total cold run time: 112494 ms
   Total hot run time: 41543 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4090401239913991
   q2   328 220 221 220
   q3   2972300331133003
   q4   2002197720201977
   q5   5552547754895477
   q6   226 131 130 130
   q7   2107175918351759
   q8   3326336333093309
   q9   8688867387138673
   q10  3966404639533953
   q11  548 448 460 448
   q12  787 603 602 602
   q13  11592   312730973097
   q14  309 280 278 278
   q15  529 492 498 492
   q16  449 420 421 420
   q17  1749170617151706
   q18  8125778277217721
   q19  1749170717051705
   q20  2045185318741853
   q21  5865548353795379
   q22  513 454 454 454
   Total cold run time: 67517 ms
   Total hot run time: 56647 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] [test](inverted index) add an Inverted Index Testing Switch [doris]

2024-08-06 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 37.74% (8102/21467) 
Line Coverage: 29.38% (66352/225861)
Region Coverage: 28.89% (34241/118532)
Branch Coverage: 24.77% (17593/71034)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/b0e93279c84eed4acc3ca33bc143bc1a778518cb_b0e93279c84eed4acc3ca33bc143bc1a778518cb/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] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 169487 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 5f84d72352fb204767fbb35cefe2b0ebfff02f55, 
data reload: false
   
   query1   924 379 362 362
   query2   6454173616971697
   query3   6670212 222 212
   query4   19842   17454   17284   17284
   query5   3652510 521 510
   query6   261 172 171 171
   query7   4598303 295 295
   query8   269 198 202 198
   query9   8514240123882388
   query10  434 279 277 277
   query11  10368   10019   99539953
   query12  124 91  94  91
   query13  1629389 386 386
   query14  10032   707368576857
   query15  206 164 163 163
   query16  6877481 411 411
   query17  948 572 562 562
   query18  1882297 301 297
   query19  196 148 149 148
   query20  92  88  90  88
   query21  205 108 104 104
   query22  4292398239803980
   query23  33766   33549   33827   33549
   query24  10302   317230863086
   query25  712 435 451 435
   query26  1706163 166 163
   query27  2961303 291 291
   query28  7395208820292029
   query29  1187532 451 451
   query30  237 154 160 154
   query31  966 763 770 763
   query32  98  55  62  55
   query33  689 341 328 328
   query34  956 510 517 510
   query35  876 790 765 765
   query36  1064893 889 889
   query37  191 84  78  78
   query38  2923279427772777
   query39  882 833 824 824
   query40  248 118 115 115
   query41  45  42  43  42
   query42  124 106 97  97
   query43  476 436 408 408
   query44  1138727 732 727
   query45  211 179 181 179
   query46  1098822 792 792
   query47  1801172117491721
   query48  362 293 294 293
   query49  939 416 429 416
   query50  898 432 435 432
   query51  6765668567206685
   query52  101 93  93  93
   query53  252 181 184 181
   query54  611 458 452 452
   query55  92  73  74  73
   query56  266 250 261 250
   query57  1135104310571043
   query58  267 284 305 284
   query59  2469243524692435
   query60  320 269 272 269
   query61  98  94  97  94
   query62  892 654 653 653
   query63  216 191 180 180
   query64  5728189218971892
   query65  3171308431203084
   query66  1310331 328 328
   query67  15292   14643   14841   14643
   query68  4413564 588 564
   query69  479 303 312 303
   query70  1112109110741074
   query71  493 281 286 281
   query72  7800273624732473
   query73  762 332 332 332
   query74  5987568656095609
   query75  3466273826902690
   query76  2541120412991204
   query77  486 312 302 302
   query78  9393887288998872
   query79  2349538 548 538
   query80  1132509 493 493
   query81  570 229 230 229
   query82  778 137 135 135
   query83  264 177 174 174
   query84  270 82  82  82
   query85  1951315 302 302
   query86  454 266 292 266
   query87  3294308430983084
   query88  3846240824252408
   query89  389 291 289 289
   query90  1918203 208 203
   query91  127 102 103 102
   query92  64  48  51  48
   query93  2358636 620 620
   query94  868 293 325 293
   query95  392 278 275 275
   query96  612 283 285 283
   query97  3239311130733073
   query98  221 204 194 194
   query99  1634125012831250
   Total cold run time: 265367 ms
   Total hot run time: 169487 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](log) Remove unnecessary log for analysis [doris]

2024-08-06 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 83dd9966c9cd901657eec5d5abadd7dfc2f1a2b6 with 
default session variables
   Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:  59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:  33 seconds loaded 861443392 Bytes, about 24 MB/s
   Insert into select:   21.5 seconds inserted 1000 Rows, about 465K 
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] [fix] (scan) push down expr in agg and mor [doris]

2024-08-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.18 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5f84d72352fb204767fbb35cefe2b0ebfff02f55, 
data reload: false
   
   query1   0.040.040.04
   query2   0.070.030.04
   query3   0.230.050.05
   query4   1.670.070.07
   query5   0.470.480.48
   query6   1.140.720.71
   query7   0.020.010.01
   query8   0.050.050.05
   query9   0.580.510.52
   query10  0.570.560.57
   query11  0.160.120.12
   query12  0.150.130.14
   query13  0.610.600.60
   query14  0.770.800.79
   query15  0.900.860.87
   query16  0.360.360.36
   query17  0.991.000.97
   query18  0.230.210.21
   query19  1.851.761.75
   query20  0.010.010.02
   query21  15.41   0.770.67
   query22  4.037.641.23
   query23  17.89   1.371.33
   query24  2.280.230.22
   query25  0.180.080.08
   query26  0.320.210.22
   query27  0.460.240.23
   query28  13.16   1.020.97
   query29  12.53   3.353.36
   query30  0.250.060.06
   query31  2.860.410.41
   query32  3.230.500.48
   query33  2.973.003.03
   query34  15.45   4.294.26
   query35  4.274.314.31
   query36  0.680.470.49
   query37  0.180.170.16
   query38  0.160.150.15
   query39  0.040.030.04
   query40  0.160.140.12
   query41  0.090.060.05
   query42  0.050.040.04
   query43  0.040.040.04
   Total cold run time: 107.56 s
   Total hot run time: 30.18 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](cloud-balance) use right file size instead of block size [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 42093 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 4b7e5cea63c17ea5668c76c2abc9dc2b87540721, 
data reload: false
   
   -- Round 1 --
   q1   17710   439341294129
   q2   2036201 196 196
   q3   10615   141914271419
   q4   10278   855 927 855
   q5   7661300929952995
   q6   226 141 140 140
   q7   1067613 614 613
   q8   9448192620061926
   q9   8530661366906613
   q10  8710386538653865
   q11  439 258 247 247
   q12  421 227 225 225
   q13  17760   293729572937
   q14  276 245 252 245
   q15  528 488 499 488
   q16  522 388 383 383
   q17  971 935 929 929
   q18  8676736472417241
   q19  1424123212281228
   q20  556 324 344 324
   q21  5502481648894816
   q22  355 286 279 279
   Total cold run time: 113711 ms
   Total hot run time: 42093 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4163408640344034
   q2   326 224 222 222
   q3   3032312732183127
   q4   2083198220081982
   q5   5576552554685468
   q6   223 132 133 132
   q7   2190184917691769
   q8   3348339933823382
   q9   8753878287648764
   q10  3998398039823980
   q11  560 469 463 463
   q12  754 578 574 574
   q13  13253   313631313131
   q14  294 277 275 275
   q15  535 499 482 482
   q16  460 425 424 424
   q17  1798172717591727
   q18  8248777177817771
   q19  1735176017431743
   q20  2082189018381838
   q21  5874559054475447
   q22  516 482 474 474
   Total cold run time: 69801 ms
   Total hot run time: 57209 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](nereids) adjust broadcast/shuffle join [doris]

2024-08-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40414 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 030b8420d7a07fdc8da2fb21af9198a06f50c947, 
data reload: false
   
   -- Round 1 --
   q1   17626   400340164003
   q2   2023184 202 184
   q3   10454   126913211269
   q4   10168   842 944 842
   q5   7530274528192745
   q6   221 134 133 133
   q7   1027605 595 595
   q8   9425181219381812
   q9   8456660465766576
   q10  7047247824952478
   q11  438 252 249 249
   q12  428 231 225 225
   q13  17767   293629462936
   q14  267 243 237 237
   q15  527 492 498 492
   q16  521 410 396 396
   q17  956 892 916 892
   q18  7966721371507150
   q19  1420121712151215
   q20  557 321 320 320
   q21  5261476047004700
   q22  1018982 965 965
   Total cold run time: 03 ms
   Total hot run time: 40414 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4054402639823982
   q2   326 225 218 218
   q3   2798277028142770
   q4   1884196719651965
   q5   5462552253345334
   q6   235 134 133 133
   q7   2092168816611661
   q8   3219336133363336
   q9   8679864586358635
   q10  3474350634383438
   q11  557 465 477 465
   q12  782 649 620 620
   q13  16304   302430983024
   q14  312 265 285 265
   q15  525 510 485 485
   q16  490 426 416 416
   q17  1753174517441744
   q18  8033762876567628
   q19  1713173617141714
   q20  2053182718781827
   q21  5708550054625462
   q22  1101103710131013
   Total cold run time: 71554 ms
   Total hot run time: 56135 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



  1   2   3   4   5   6   7   8   9   10   >