Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-07-08 Thread via GitHub


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


-- 
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)agg funs case insensitive [doris]

2025-07-08 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-07-08 Thread via GitHub


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

   run p0


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

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

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


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



Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-07-03 Thread via GitHub


hello-stephen commented on PR #50444:
URL: https://github.com/apache/doris/pull/50444#issuecomment-3034310391

   # FE UT Coverage Report
   Increment line coverage `  100.00% (7/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_ee57d1325f94b99dc2953b9ebae42823eb5bf30d/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_ee57d1325f94b99dc2953b9ebae42823eb5bf30d/fe_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](nereids)agg funs case insensitive [doris]

2025-07-03 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.58 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit ee57d1325f94b99dc2953b9ebae42823eb5bf30d, 
data reload: false
   
   query1   0.040.040.04
   query2   0.080.040.04
   query3   0.240.080.08
   query4   1.620.100.11
   query5   0.440.460.43
   query6   1.150.660.68
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.600.520.53
   query10  0.570.560.57
   query11  0.170.110.12
   query12  0.150.120.12
   query13  0.630.610.62
   query14  0.800.810.82
   query15  0.920.890.86
   query16  0.390.380.38
   query17  1.061.051.03
   query18  0.230.210.21
   query19  2.011.821.91
   query20  0.020.010.01
   query21  15.38   0.910.55
   query22  0.761.220.68
   query23  14.96   1.400.64
   query24  6.841.740.70
   query25  0.490.290.13
   query26  0.620.170.15
   query27  0.060.050.05
   query28  9.700.930.45
   query29  12.54   3.983.28
   query30  0.250.090.07
   query31  2.840.570.40
   query32  3.230.560.49
   query33  3.063.233.09
   query34  15.96   5.424.75
   query35  4.874.904.93
   query36  0.690.500.49
   query37  0.090.060.06
   query38  0.040.040.03
   query39  0.030.020.02
   query40  0.180.130.13
   query41  0.080.020.02
   query42  0.030.030.03
   query43  0.030.040.04
   Total cold run time: 103.91 s
   Total hot run time: 29.58 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)agg funs case insensitive [doris]

2025-07-03 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 184922 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 ee57d1325f94b99dc2953b9ebae42823eb5bf30d, 
data reload: false
   
   query1   997 385 394 385
   query2   6547166016891660
   query3   6739216 212 212
   query4   26670   23326   23820   23326
   query5   4764578 425 425
   query6   297 215 184 184
   query7   4623492 286 286
   query8   274 214 209 209
   query9   8625261626602616
   query10  491 319 281 281
   query11  15772   15076   14912   14912
   query12  153 103 100 100
   query13  1632531 390 390
   query14  8587579457255725
   query15  204 181 185 181
   query16  7183656 497 497
   query17  1193715 584 584
   query18  1993407 309 309
   query19  202 195 162 162
   query20  123 117 111 111
   query21  214 121 104 104
   query22  4338414140604060
   query23  33918   32962   33126   32962
   query24  8521240123842384
   query25  580 504 418 418
   query26  1238269 156 156
   query27  2743516 358 358
   query28  4356213821162116
   query29  808 634 433 433
   query30  279 214 187 187
   query31  891 834 765 765
   query32  74  67  63  63
   query33  564 361 305 305
   query34  853 839 520 520
   query35  773 812 727 727
   query36  942 994 900 900
   query37  112 98  74  74
   query38  4207414739673967
   query39  1666142113981398
   query40  232 115 105 105
   query41  54  52  51  51
   query42  130 104 104 104
   query43  514 525 471 471
   query44  1322817 816 816
   query45  176 167 155 155
   query46  844 1016623 623
   query47  1735179817121712
   query48  384 417 312 312
   query49  741 484 392 392
   query50  645 710 432 432
   query51  4101407541644075
   query52  114 108 100 100
   query53  226 251 191 191
   query54  571 578 506 506
   query55  85  80  84  80
   query56  314 295 297 295
   query57  1181117711131113
   query58  263 253 259 253
   query59  2603268926432643
   query60  321 329 322 322
   query61  119 122 120 120
   query62  803 724 669 669
   query63  227 190 190 190
   query64  43781018699 699
   query65  4244413741864137
   query66  1133412 314 314
   query67  15768   15678   15424   15424
   query68  8717879 528 528
   query69  481 307 279 279
   query70  1212112110881088
   query71  464 336 315 315
   query72  5720475848294758
   query73  738 654 355 355
   query74  9159907586458645
   query75  4019316127412741
   query76  36801138722 722
   query77  773 413 303 303
   query78  10216   10065   92989298
   query79  4518824 582 582
   query80  647 518 452 452
   query81  473 254 219 219
   query82  596 135 96  96
   query83  275 257 240 240
   query84  299 114 82  82
   query85  775 383 317 317
   query86  331 297 279 279
   query87  4503439543064306
   query88  3117231623052305
   query89  445 323 296 296
   query90  1936215 213 213
   query91  148 161 109 109
   query92  71  62  54  54
   query93  2817980 590 590
   query94  674 387 305 305
   query95  390 301 291 291
   query96  501 623 282 282
   query97  2716274026262626
   query98  233 216 203 203
   query99  1414137212871287
   Total cold run time: 279432 ms
   Total hot run time: 184922 ms
   ```
   
   


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

Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-07-03 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33810 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ee57d1325f94b99dc2953b9ebae42823eb5bf30d, 
data reload: false
   
   -- Round 1 --
   q1   17585   522750675067
   q2   1938288 180 180
   q3   10429   1281711 711
   q4   10254   1009513 513
   q5   7992245522962296
   q6   186 162 128 128
   q7   869 749 611 611
   q8   9312120110111011
   q9   6797508751555087
   q10  6917239919411941
   q11  488 287 271 271
   q12  335 348 216 216
   q13  17800   365331133113
   q14  229 235 222 222
   q15  562 478 488 478
   q16  425 422 374 374
   q17  608 847 349 349
   q18  7542723572037203
   q19  1663957 536 536
   q20  320 347 217 217
   q21  3811314323092309
   q22  10631018977 977
   Total cold run time: 107125 ms
   Total hot run time: 33810 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5199511650885088
   q2   239 323 220 220
   q3   2158262122962296
   q4   1398175913381338
   q5   4181449245474492
   q6   223 178 127 127
   q7   2051196518211821
   q8   2680259325342534
   q9   7374727673247276
   q10  310728822882
   q11  594 512 503 503
   q12  679 818 650 650
   q13  3495407732413241
   q14  291 304 293 293
   q15  531 486 484 484
   q16  456 571 444 444
   q17  1167147114381438
   q18  7921791077047704
   q19  815 784 912 784
   q20  1966207318481848
   q21  4772433243514332
   q22  1089102910101010
   Total cold run time: 52386 ms
   Total hot run time: 50805 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](nereids)agg funs case insensitive [doris]

2025-07-03 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.58 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5f33e7f666a9cac4667e0089ed101ee342378cdc, 
data reload: false
   
   query1   0.040.030.04
   query2   0.070.040.04
   query3   0.250.070.07
   query4   1.620.110.11
   query5   0.430.430.42
   query6   1.150.660.65
   query7   0.030.010.02
   query8   0.050.040.04
   query9   0.600.510.52
   query10  0.580.570.56
   query11  0.160.120.11
   query12  0.150.120.12
   query13  0.620.610.62
   query14  0.810.830.82
   query15  0.900.900.88
   query16  0.400.390.38
   query17  1.061.071.13
   query18  0.230.210.21
   query19  2.001.871.90
   query20  0.010.010.01
   query21  15.41   0.910.55
   query22  0.751.180.74
   query23  14.82   1.400.64
   query24  6.871.360.69
   query25  0.520.120.06
   query26  0.590.170.14
   query27  0.070.050.06
   query28  9.360.950.44
   query29  12.62   4.033.35
   query30  0.240.090.07
   query31  2.830.600.38
   query32  3.240.560.47
   query33  3.103.083.12
   query34  16.12   5.404.76
   query35  4.834.894.81
   query36  0.690.510.50
   query37  0.090.070.06
   query38  0.050.040.04
   query39  0.040.020.02
   query40  0.180.150.14
   query41  0.080.020.02
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 103.73 s
   Total hot run time: 29.58 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)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 184550 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 5f33e7f666a9cac4667e0089ed101ee342378cdc, 
data reload: false
   
   query1   1005379 387 379
   query2   6523168316791679
   query3   6742214 208 208
   query4   26126   23746   22861   22861
   query5   4329578 429 429
   query6   303 220 216 216
   query7   4621488 281 281
   query8   261 211 210 210
   query9   8605263526482635
   query10  464 339 278 278
   query11  15639   15097   15403   15097
   query12  155 110 104 104
   query13  1654535 408 408
   query14  9067556655925566
   query15  207 190 177 177
   query16  7409644 488 488
   query17  1194712 585 585
   query18  1994406 307 307
   query19  194 191 163 163
   query20  123 119 114 114
   query21  213 122 106 106
   query22  4213419744514197
   query23  35003   33693   33397   33397
   query24  8449231823632318
   query25  528 433 390 390
   query26  1218252 138 138
   query27  2763503 341 341
   query28  4270213121232123
   query29  728 536 424 424
   query30  277 215 183 183
   query31  927 830 757 757
   query32  70  61  60  60
   query33  559 399 304 304
   query34  770 856 519 519
   query35  755 833 750 750
   query36  949 988 862 862
   query37  102 95  67  67
   query38  4068415440584058
   query39  1497138614141386
   query40  203 113 101 101
   query41  55  56  53  53
   query42  123 109 110 109
   query43  506 486 458 458
   query44  1283815 809 809
   query45  181 170 163 163
   query46  832 994 620 620
   query47  1747180517181718
   query48  384 415 310 310
   query49  721 453 371 371
   query50  622 684 396 396
   query51  4143410439963996
   query52  103 104 99  99
   query53  223 248 189 189
   query54  582 561 500 500
   query55  81  85  81  81
   query56  294 303 306 303
   query57  1178119110871087
   query58  255 259 252 252
   query59  2651264924822482
   query60  334 315 313 313
   query61  126 119 115 115
   query62  762 712 675 675
   query63  216 178 180 178
   query64  42951005694 694
   query65  4279413641644136
   query66  1104398 341 341
   query67  15701   15624   15396   15396
   query68  8733897 522 522
   query69  460 295 275 275
   query70  1209110610651065
   query71  449 323 283 283
   query72  5579475646754675
   query73  691 590 345 345
   query74  9016909087828782
   query75  4130315026702670
   query76  37091140701 701
   query77  773 369 279 279
   query78  10178   10063   94109410
   query79  2048824 590 590
   query80  600 507 429 429
   query81  498 251 225 225
   query82  467 121 96  96
   query83  243 247 235 235
   query84  255 101 83  83
   query85  788 343 353 343
   query86  375 284 296 284
   query87  4431446143034303
   query88  3545224122382238
   query89  383 312 278 278
   query90  1847199 195 195
   query91  139 137 106 106
   query92  66  60  61  60
   query93  1583938 585 585
   query94  678 407 306 306
   query95  367 290 274 274
   query96  485 560 274 274
   query97  2703281226642664
   query98  230 210 216 210
   query99  1485137312551255
   Total cold run time: 275101 ms
   Total hot run time: 184550 ms
   ```
   
   


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

Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33711 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5f33e7f666a9cac4667e0089ed101ee342378cdc, 
data reload: false
   
   -- Round 1 --
   q1   17630   515850485048
   q2   1927277 186 186
   q3   10320   1275693 693
   q4   10219   1029514 514
   q5   7518236323322332
   q6   173 159 125 125
   q7   867 730 595 595
   q8   9323126611001100
   q9   6930505050335033
   q10  6900236719461946
   q11  475 288 264 264
   q12  342 349 210 210
   q13  17767   370231303130
   q14  218 224 206 206
   q15  539 474 485 474
   q16  413 416 383 383
   q17  565 856 342 342
   q18  7596728170627062
   q19  1205958 545 545
   q20  320 357 217 217
   q21  3816320623592359
   q22  1050999 947 947
   Total cold run time: 106113 ms
   Total hot run time: 33711 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5098506950705069
   q2   231 324 224 224
   q3   2206266223192319
   q4   1370181113711371
   q5   4202450845564508
   q6   210 162 121 121
   q7   2041195518191819
   q8   2668264926552649
   q9   7430726172947261
   q10  3097336028402840
   q11  584 561 494 494
   q12  666 809 592 592
   q13  3638410334533453
   q14  287 299 285 285
   q15  537 476 484 476
   q16  440 514 455 455
   q17  1252167613941394
   q18  7937768975337533
   q19  811 804 953 804
   q20  2016204919871987
   q21  4981461546364615
   q22  1130105010311031
   Total cold run time: 52832 ms
   Total hot run time: 51300 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](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.09 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   query1   0.040.030.03
   query2   0.080.040.04
   query3   0.260.070.07
   query4   1.610.110.11
   query5   0.420.420.42
   query6   1.170.650.67
   query7   0.030.020.02
   query8   0.040.040.04
   query9   0.590.520.52
   query10  0.560.570.58
   query11  0.160.110.11
   query12  0.150.130.11
   query13  0.620.620.61
   query14  0.830.800.82
   query15  0.900.860.87
   query16  0.390.390.40
   query17  1.061.091.02
   query18  0.230.210.21
   query19  2.011.821.86
   query20  0.020.010.02
   query21  15.40   0.890.60
   query22  0.741.140.61
   query23  15.05   1.370.65
   query24  7.241.930.45
   query25  0.490.320.09
   query26  0.610.160.14
   query27  0.070.060.06
   query28  9.290.890.46
   query29  12.58   4.013.30
   query30  0.250.090.06
   query31  2.840.580.39
   query32  3.230.560.48
   query33  3.043.043.14
   query34  15.96   5.414.73
   query35  4.824.814.81
   query36  0.670.530.48
   query37  0.090.070.06
   query38  0.060.040.04
   query39  0.040.020.02
   query40  0.180.140.15
   query41  0.090.030.02
   query42  0.040.020.02
   query43  0.040.040.03
   Total cold run time: 103.99 s
   Total hot run time: 29.09 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)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 184272 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 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   query1   1031396 385 385
   query2   6511165616291629
   query3   6734209 212 209
   query4   27190   23636   23504   23504
   query5   4340571 417 417
   query6   304 226 218 218
   query7   4624498 290 290
   query8   267 226 218 218
   query9   8616261326132613
   query10  486 328 290 290
   query11  15256   15463   14814   14814
   query12  159 112 109 109
   query13  1678529 419 419
   query14  9481559456035594
   query15  208 189 176 176
   query16  7518597 480 480
   query17  1176705 566 566
   query18  1995387 290 290
   query19  189 181 151 151
   query20  115 124 110 110
   query21  215 120 101 101
   query22  4047410439133913
   query23  33947   32942   33240   32942
   query24  8363235423332333
   query25  515 476 385 385
   query26  1224273 143 143
   query27  2761515 334 334
   query28  4317215221172117
   query29  738 603 462 462
   query30  292 223 192 192
   query31  938 843 781 781
   query32  74  66  64  64
   query33  563 369 334 334
   query34  785 829 518 518
   query35  792 837 731 731
   query36  929 976 867 867
   query37  122 102 75  75
   query38  4103406341074063
   query39  1502141814211418
   query40  211 114 101 101
   query41  54  53  49  49
   query42  120 110 105 105
   query43  506 499 465 465
   query44  1282814 802 802
   query45  172 168 160 160
   query46  844 988 618 618
   query47  1715179217031703
   query48  385 414 305 305
   query49  741 481 379 379
   query50  644 673 406 406
   query51  4056413240454045
   query52  115 112 104 104
   query53  223 248 178 178
   query54  570 564 503 503
   query55  86  83  86  83
   query56  312 299 274 274
   query57  1167118911161116
   query58  258 247 264 247
   query59  2604254525172517
   query60  331 317 330 317
   query61  124 125 136 125
   query62  811 715 653 653
   query63  220 181 185 181
   query64  4255992 654 654
   query65  4227417341644164
   query66  1073402 310 310
   query67  15709   15449   15433   15433
   query68  7838919 514 514
   query69  462 306 265 265
   query70  1153109910861086
   query71  446 315 288 288
   query72  5780469447154694
   query73  666 600 348 348
   query74  9062899688768876
   query75  3739317626642664
   query76  35021130719 719
   query77  775 378 301 301
   query78  999410113   93349334
   query79  2441810 588 588
   query80  606 507 433 433
   query81  487 266 220 220
   query82  520 125 93  93
   query83  249 244 237 237
   query84  244 109 84  84
   query85  807 353 315 315
   query86  378 311 284 284
   query87  4417439742534253
   query88  3703225222502250
   query89  382 310 349 310
   query90  1856199 202 199
   query91  140 139 108 108
   query92  76  59  56  56
   query93  2250931 571 571
   query94  632 405 306 306
   query95  373 284 281 281
   query96  492 565 280 280
   query97  2698275425702570
   query98  233 210 203 203
   query99  1349139012901290
   Total cold run time: 274670 ms
   Total hot run time: 184272 ms
   ```
   
   


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

Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


hello-stephen commented on PR #50444:
URL: https://github.com/apache/doris/pull/50444#issuecomment-3027199275

   # FE UT Coverage Report
   Increment line coverage `  100.00% (7/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_40b5b066e6cc850240c25e11890ac84ccb992d55/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_40b5b066e6cc850240c25e11890ac84ccb992d55/fe_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](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33781 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   -- Round 1 --
   q1   17620   517551555155
   q2   1939283 183 183
   q3   10576   1306695 695
   q4   10267   1058549 549
   q5   8019234023192319
   q6   187 155 125 125
   q7   867 728 585 585
   q8   9301124810101010
   q9   6884510551325105
   q10  6882240719701970
   q11  482 283 262 262
   q12  340 339 210 210
   q13  17781   364531243124
   q14  234 224 206 206
   q15  532 476 488 476
   q16  427 420 381 381
   q17  571 845 343 343
   q18  7458726470977097
   q19  1212943 530 530
   q20  327 338 215 215
   q21  3720252822862286
   q22  1029968 955 955
   Total cold run time: 106655 ms
   Total hot run time: 33781 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5119505050565050
   q2   236 324 225 225
   q3   2117268623152315
   q4   1393175213301330
   q5   4200447345304473
   q6   215 170 128 128
   q7   1977198618181818
   q8   2584271626012601
   q9   7293726473227264
   q10  3091328128952895
   q11  583 518 537 518
   q12  681 770 658 658
   q13  3790393233443344
   q14  285 306 268 268
   q15  509 474 498 474
   q16  468 521 444 444
   q17  1193157713741374
   q18  7901769673747374
   q19  741 883 1049883
   q20  1919196818291829
   q21  4657426542854265
   q22  10491021988 988
   Total cold run time: 52001 ms
   Total hot run time: 50518 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](nereids)agg funs case insensitive [doris]

2025-07-02 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


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

   run p0


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

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

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


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



Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


hello-stephen commented on PR #50444:
URL: https://github.com/apache/doris/pull/50444#issuecomment-3021619076

   # FE UT Coverage Report
   Increment line coverage `  100.00% (7/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_40b5b066e6cc850240c25e11890ac84ccb992d55/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/50444_40b5b066e6cc850240c25e11890ac84ccb992d55/fe_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](nereids)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.5 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   query1   0.040.040.03
   query2   0.080.040.04
   query3   0.240.080.08
   query4   1.610.120.11
   query5   0.440.430.41
   query6   1.180.660.67
   query7   0.020.010.02
   query8   0.050.030.04
   query9   0.600.510.53
   query10  0.570.570.58
   query11  0.160.110.11
   query12  0.140.110.12
   query13  0.630.610.62
   query14  0.800.820.81
   query15  0.900.890.86
   query16  0.390.370.40
   query17  1.091.061.08
   query18  0.230.220.21
   query19  1.901.961.83
   query20  0.010.010.02
   query21  15.40   0.880.54
   query22  0.741.200.65
   query23  14.94   1.370.65
   query24  7.601.000.69
   query25  0.520.110.09
   query26  0.610.170.15
   query27  0.050.060.05
   query28  8.750.940.45
   query29  12.52   3.963.29
   query30  0.250.090.07
   query31  2.840.600.38
   query32  3.260.560.47
   query33  3.093.143.10
   query34  16.16   5.404.82
   query35  4.824.864.86
   query36  0.710.490.48
   query37  0.090.080.06
   query38  0.050.050.04
   query39  0.030.030.03
   query40  0.180.140.14
   query41  0.080.030.02
   query42  0.040.020.03
   query43  0.040.020.02
   Total cold run time: 103.85 s
   Total hot run time: 29.5 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)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 185290 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 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   query1   1023381 389 381
   query2   6563173917381738
   query3   6748212 209 209
   query4   26092   23414   22981   22981
   query5   4340594 472 472
   query6   295 220 207 207
   query7   4642508 296 296
   query8   273 224 216 216
   query9   8611266226682662
   query10  526 328 289 289
   query11  15768   15131   14865   14865
   query12  173 106 104 104
   query13  1642557 402 402
   query14  9773569558255695
   query15  197 195 173 173
   query16  7638637 460 460
   query17  1186700 570 570
   query18  2022403 297 297
   query19  188 192 159 159
   query20  124 116 113 113
   query21  206 126 105 105
   query22  4005403139653965
   query23  33804   33173   33090   33090
   query24  8271240423982398
   query25  557 448 388 388
   query26  718 268 152 152
   query27  2701514 344 344
   query28  4207212221142114
   query29  636 558 472 472
   query30  282 220 191 191
   query31  878 814 766 766
   query32  71  63  64  63
   query33  546 356 312 312
   query34  799 849 511 511
   query35  786 795 745 745
   query36  962 970 861 861
   query37  114 99  79  79
   query38  4246422841324132
   query39  1489148014101410
   query40  219 121 109 109
   query41  80  74  57  57
   query42  121 111 110 110
   query43  522 524 476 476
   query44  1355830 818 818
   query45  180 172 168 168
   query46  877 1049651 651
   query47  1742179216741674
   query48  389 436 337 337
   query49  719 493 384 384
   query50  666 683 448 448
   query51  4163417240984098
   query52  117 113 105 105
   query53  233 262 199 199
   query54  598 587 522 522
   query55  85  79  81  79
   query56  319 313 311 311
   query57  1184118210971097
   query58  268 282 265 265
   query59  2691273926512651
   query60  327 325 294 294
   query61  122 123 123 123
   query62  818 715 661 661
   query63  232 191 191 191
   query64  30901096653 653
   query65  4253418642114186
   query66  865 421 318 318
   query67  15542   15528   15376   15376
   query68  8402937 531 531
   query69  462 300 264 264
   query70  1224110910871087
   query71  455 337 307 307
   query72  5653476650094766
   query73  740 685 356 356
   query74  9037902588588858
   query75  3944319127802780
   query76  35631150746 746
   query77  777 401 299 299
   query78  1   10153   93929392
   query79  2147826 582 582
   query80  593 506 441 441
   query81  501 254 228 228
   query82  449 126 95  95
   query83  253 257 233 233
   query84  253 110 94  94
   query85  781 377 316 316
   query86  388 311 292 292
   query87  4405444143484348
   query88  3395226522822265
   query89  389 316 282 282
   query90  1927214 210 210
   query91  147 137 111 111
   query92  71  60  53  53
   query93  1612967 592 592
   query94  671 410 282 282
   query95  380 290 277 277
   query96  496 573 282 282
   query97  2757272026782678
   query98  227 223 202 202
   query99  1424142312931293
   Total cold run time: 272402 ms
   Total hot run time: 185290 ms
   ```
   
   


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

Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34112 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 40b5b066e6cc850240c25e11890ac84ccb992d55, 
data reload: false
   
   -- Round 1 --
   q1   17590   525650855085
   q2   1960299 185 185
   q3   10322   1284725 725
   q4   10295   1007515 515
   q5   8422229223682292
   q6   194 159 129 129
   q7   924 731 621 621
   q8   9320129311001100
   q9   7025505250215021
   q10  6943236619531953
   q11  483 293 276 276
   q12  343 342 211 211
   q13  17839   384032643264
   q14  225 228 212 212
   q15  562 498 473 473
   q16  470 438 400 400
   q17  638 881 374 374
   q18  7598723672427236
   q19  1585934 555 555
   q20  317 350 221 221
   q21  3860319323302330
   q22  10261003934 934
   Total cold run time: 107941 ms
   Total hot run time: 34112 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5341518551695169
   q2   241 318 224 224
   q3   2171266822762276
   q4   1349173413241324
   q5   4326433243934332
   q6   206 163 126 126
   q7   1949192317961796
   q8   2573254225202520
   q9   7110699470396994
   q10  3106323428042804
   q11  565 507 494 494
   q12  715 775 645 645
   q13  3555402233263326
   q14  290 302 262 262
   q15  511 474 493 474
   q16  434 476 417 417
   q17  1104152312991299
   q18  7293722970777077
   q19  803 813 844 813
   q20  1898194618141814
   q21  4676438542064206
   q22  1086103810141014
   Total cold run time: 51302 ms
   Total hot run time: 49406 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](nereids)agg funs case insensitive [doris]

2025-06-30 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-06-25 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-05-27 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-05-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 28.92 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 885013078f2608e4d779054cdbe4601eaf741689, 
data reload: false
   
   query1   0.040.040.03
   query2   0.140.100.10
   query3   0.250.190.20
   query4   1.590.200.20
   query5   0.450.430.43
   query6   1.160.660.64
   query7   0.030.020.01
   query8   0.040.030.04
   query9   0.590.530.52
   query10  0.560.560.56
   query11  0.160.110.11
   query12  0.140.110.11
   query13  0.610.600.60
   query14  0.780.820.82
   query15  0.870.830.86
   query16  0.370.370.38
   query17  1.021.041.06
   query18  0.230.200.21
   query19  2.031.821.83
   query20  0.010.020.01
   query21  15.40   0.920.52
   query22  0.771.230.69
   query23  14.85   1.390.61
   query24  6.871.190.63
   query25  0.570.240.08
   query26  0.630.160.14
   query27  0.060.050.05
   query28  10.27   0.930.45
   query29  12.53   3.993.28
   query30  0.260.100.07
   query31  2.820.590.39
   query32  3.240.560.50
   query33  3.113.103.11
   query34  15.94   5.124.48
   query35  4.534.504.53
   query36  0.660.500.49
   query37  0.090.070.06
   query38  0.060.040.05
   query39  0.030.020.03
   query40  0.160.140.13
   query41  0.070.020.02
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 104.06 s
   Total hot run time: 28.92 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)agg funs case insensitive [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192437 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 885013078f2608e4d779054cdbe4601eaf741689, 
data reload: false
   
   query1   1415107510441044
   query2   6387179117931791
   query3   10988   443944524439
   query4   52994   25389   23044   23044
   query5   5050553 449 449
   query6   345 225 201 201
   query7   4877488 300 300
   query8   325 255 252 252
   query9   5447271126892689
   query10  454 320 279 279
   query11  15242   14938   14835   14835
   query12  167 113 108 108
   query13  1035552 401 401
   query14  10117   635263326332
   query15  198 200 183 183
   query16  7011645 463 463
   query17  1045747 575 575
   query18  1564399 301 301
   query19  189 185 158 158
   query20  131 127 115 115
   query21  211 130 113 113
   query22  4678451044014401
   query23  34276   33524   33907   33524
   query24  7139241124242411
   query25  477 487 399 399
   query26  731 276 164 164
   query27  2435515 343 343
   query28  3185214721792147
   query29  571 568 430 430
   query30  273 223 191 191
   query31  880 860 758 758
   query32  76  68  61  61
   query33  445 382 306 306
   query34  792 872 561 561
   query35  797 844 763 763
   query36  927 997 895 895
   query37  112 104 78  78
   query38  4247433042424242
   query39  1559146014731460
   query40  215 126 112 112
   query41  55  51  57  51
   query42  127 114 117 114
   query43  501 520 489 489
   query44  1354834 831 831
   query45  185 175 166 166
   query46  847 1043658 658
   query47  1853189218311831
   query48  385 440 336 336
   query49  694 519 467 467
   query50  677 703 398 398
   query51  4254428642254225
   query52  118 113 102 102
   query53  225 267 190 190
   query54  587 575 512 512
   query55  92  84  92  84
   query56  332 331 306 306
   query57  1182119411211121
   query58  277 273 291 273
   query59  2669271127012701
   query60  341 332 338 332
   query61  130 127 131 127
   query62  746 736 678 678
   query63  231 192 195 192
   query64  18161027667 667
   query65  4364417342164173
   query66  759 402 294 294
   query67  16030   15639   15456   15456
   query68  7627894 529 529
   query69  538 314 276 276
   query70  1184110910641064
   query71  504 334 294 294
   query72  5576465048174650
   query73  1225636 362 362
   query74  9009906889288928
   query75  3910316726952695
   query76  41731196760 760
   query77  657 360 360 360
   query78  10109   10092   94269426
   query79  6519773 567 567
   query80  637 516 420 420
   query81  498 248 222 222
   query82  747 125 96  96
   query83  352 256 232 232
   query84  290 100 82  82
   query85  776 398 307 307
   query86  383 315 282 282
   query87  4400444743434343
   query88  4177228922582258
   query89  457 306 280 280
   query90  1879202 204 202
   query91  138 145 108 108
   query92  78  58  52  52
   query93  4059915 571 571
   query94  656 405 300 300
   query95  358 285 280 280
   query96  498 582 280 280
   query97  2712279726632663
   query98  229 202 202 202
   query99  1445137212541254
   Total cold run time: 305638 ms
   Total hot run time: 192437 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] [fix](nereids)agg funs case insensitive [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33599 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 885013078f2608e4d779054cdbe4601eaf741689, 
data reload: false
   
   -- Round 1 --
   q1   25977   509149494949
   q2   2068278 190 190
   q3   10378   1243700 700
   q4   10232   977 520 520
   q5   7531230822852285
   q6   185 161 131 131
   q7   884 730 613 613
   q8   9300121110791079
   q9   6841506051045060
   q10  6925236819451945
   q11  488 312 298 298
   q12  345 346 220 220
   q13  17780   365630643064
   q14  230 222 216 216
   q15  524 488 484 484
   q16  430 434 380 380
   q17  611 848 370 370
   q18  7619707470337033
   q19  1545947 541 541
   q20  348 347 221 221
   q21  3590256523422342
   q22  10321036958 958
   Total cold run time: 114863 ms
   Total hot run time: 33599 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5110500650175006
   q2   233 320 233 233
   q3   2151262223002300
   q4   1374175913451345
   q5   4341431643434316
   q6   214 171 131 131
   q7   2012191017231723
   q8   2548252925472529
   q9   7123719770097009
   q10  2910320927242724
   q11  588 535 486 486
   q12  667 773 627 627
   q13  3518388332053205
   q14  266 310 281 281
   q15  513 474 472 472
   q16  451 490 448 448
   q17  1139153313501350
   q18  7716749373867386
   q19  784 810 932 810
   q20  2047207419271927
   q21  4839436143504350
   q22  1067103710151015
   Total cold run time: 51611 ms
   Total hot run time: 49673 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](nereids)agg funs case insensitive [doris]

2025-05-22 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.93 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 49fc248b413826973b182584177763c8e02753af, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.100.11
   query3   0.250.190.20
   query4   1.600.190.19
   query5   0.590.580.59
   query6   1.210.700.72
   query7   0.020.010.01
   query8   0.040.040.03
   query9   0.580.520.50
   query10  0.560.570.57
   query11  0.160.100.11
   query12  0.150.110.11
   query13  0.610.600.60
   query14  1.141.181.16
   query15  0.870.860.86
   query16  0.390.380.39
   query17  0.991.051.01
   query18  0.210.200.20
   query19  1.861.771.81
   query20  0.010.010.01
   query21  15.40   0.890.53
   query22  0.741.190.71
   query23  14.86   1.360.61
   query24  6.811.451.08
   query25  0.480.330.07
   query26  0.610.160.15
   query27  0.060.060.05
   query28  9.770.860.43
   query29  12.53   3.963.31
   query30  0.260.100.07
   query31  2.810.590.38
   query32  3.230.550.46
   query33  2.993.153.07
   query34  15.80   5.114.57
   query35  4.564.574.55
   query36  0.670.490.48
   query37  0.080.060.06
   query38  0.050.030.03
   query39  0.030.020.02
   query40  0.170.140.13
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.040.040.03
   Total cold run time: 103.48 s
   Total hot run time: 29.93 s
   ```
   
   


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

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

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


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



Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 190330 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 49fc248b413826973b182584177763c8e02753af, 
data reload: false
   
   query1   1379109210811081
   query2   6380189019641890
   query3   11144   464546804645
   query4   25516   23819   23510   23510
   query5   4760616 467 467
   query6   305 194 194 194
   query7   3992509 272 272
   query8   295 239 243 239
   query9   8520256425892564
   query10  458 302 261 261
   query11  15421   15044   14807   14807
   query12  152 112 105 105
   query13  1552507 381 381
   query14  8398594861295948
   query15  210 195 168 168
   query16  7144617 476 476
   query17  1138727 549 549
   query18  1961412 319 319
   query19  205 196 165 165
   query20  134 124 121 121
   query21  201 121 107 107
   query22  4471439943924392
   query23  34531   33708   33417   33417
   query24  8884245924282428
   query25  498 461 440 440
   query26  1222264 147 147
   query27  2773512 335 335
   query28  4836215221502150
   query29  728 571 440 440
   query30  263 221 188 188
   query31  941 885 793 793
   query32  75  66  65  65
   query33  533 370 347 347
   query34  792 879 527 527
   query35  790 875 748 748
   query36  978 1021912 912
   query37  120 109 78  78
   query38  4189414042094140
   query39  1506144314231423
   query40  220 121 111 111
   query41  55  50  52  50
   query42  123 103 116 103
   query43  521 523 494 494
   query44  1312818 802 802
   query45  177 181 170 170
   query46  872 1030645 645
   query47  1811183517991799
   query48  380 412 303 303
   query49  752 494 420 420
   query50  640 704 409 409
   query51  4200423141364136
   query52  105 112 100 100
   query53  233 257 182 182
   query54  591 583 497 497
   query55  84  89  86  86
   query56  295 310 294 294
   query57  1183117911211121
   query58  286 272 267 267
   query59  2780281927762776
   query60  338 332 326 326
   query61  150 149 174 149
   query62  805 753 697 697
   query63  221 197 186 186
   query64  42371138816 816
   query65  4398439843664366
   query66  1256405 309 309
   query67  15961   15501   15218   15218
   query68  8856886 519 519
   query69  487 298 264 264
   query70  1221112711001100
   query71  474 329 285 285
   query72  5794477024382438
   query73  747 646 349 349
   query74  9242912887858785
   query75  3981317526642664
   query76  36931162743 743
   query77  783 384 303 303
   query78  10032   10022   93529352
   query79  5999821 561 561
   query80  676 506 437 437
   query81  473 258 225 225
   query82  529 128 95  95
   query83  275 246 239 239
   query84  285 97  84  84
   query85  769 358 307 307
   query86  325 293 311 293
   query87  4471441143124312
   query88  2895222522212221
   query89  442 325 278 278
   query90  2121212 216 212
   query91  139 140 109 109
   query92  73  62  57  57
   query93  3772952 580 580
   query94  679 403 307 307
   query95  376 299 287 287
   query96  492 564 280 280
   query97  3131319130943094
   query98  228 206 201 201
   query99  1452138112781278
   Total cold run time: 286293 ms
   Total hot run time: 190330 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] [fix](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33906 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 49fc248b413826973b182584177763c8e02753af, 
data reload: false
   
   -- Round 1 --
   q1   26265   548650045004
   q2   2086275 188 188
   q3   10390   1276699 699
   q4   10236   1002539 539
   q5   7570239523062306
   q6   177 161 134 134
   q7   921 733 610 610
   q8   9335128311331133
   q9   6867511751155115
   q10  6836231718551855
   q11  482 284 284 284
   q12  361 344 210 210
   q13  17802   363130883088
   q14  241 233 224 224
   q15  532 472 487 472
   q16  444 456 404 404
   q17  593 873 374 374
   q18  7831734671017101
   q19  1944944 564 564
   q20  339 323 223 223
   q21  3933336024032403
   q22  10611029976 976
   Total cold run time: 116246 ms
   Total hot run time: 33906 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5157507350445044
   q2   234 327 241 241
   q3   2179260222762276
   q4   1367179414171417
   q5   4483442744394427
   q6   212 169 127 127
   q7   1989192917341734
   q8   2557258125452545
   q9   7281722771627162
   q10  2986317427102710
   q11  584 517 491 491
   q12  669 735 629 629
   q13  3469385832263226
   q14  273 290 273 273
   q15  533 490 498 490
   q16  455 497 462 462
   q17  1136157313721372
   q18  7922750775547507
   q19  801 808 858 808
   q20  2012198518131813
   q21  5116475846684668
   q22  1106108410601060
   Total cold run time: 52521 ms
   Total hot run time: 50482 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](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   PR approved by anyone and no changes requested.


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

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

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


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



Re: [PR] [fix](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


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

   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](nereids)agg funs case insensitive [doris]

2025-04-26 Thread via GitHub


Thearas commented on PR #50444:
URL: https://github.com/apache/doris/pull/50444#issuecomment-2832912495

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting 
information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it 
now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and 
after the optimization?
   


-- 
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