Re: [PR] [fix](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


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


-- 
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) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 02a79e75fe4401a4cc10144bf9b5b1732788a4fb 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.2 seconds inserted 1000 Rows, about 471K 
ops/s
   ```
   


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

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

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


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



Re: [PR] [fix](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.28 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 02a79e75fe4401a4cc10144bf9b5b1732788a4fb, 
data reload: false
   
   query1   0.020.020.02
   query2   0.070.020.02
   query3   0.240.040.04
   query4   1.800.060.06
   query5   0.540.520.52
   query6   1.290.620.63
   query7   0.010.000.00
   query8   0.030.020.02
   query9   0.520.480.47
   query10  0.530.540.53
   query11  0.120.080.09
   query12  0.110.090.09
   query13  0.610.610.62
   query14  0.780.800.78
   query15  0.790.760.77
   query16  0.360.360.36
   query17  0.981.011.02
   query18  0.220.270.22
   query19  1.941.901.85
   query20  0.020.010.01
   query21  15.49   0.560.56
   query22  2.102.871.71
   query23  17.17   0.960.93
   query24  5.263.271.43
   query25  0.380.100.06
   query26  0.820.150.15
   query27  0.040.040.03
   query28  5.240.730.74
   query29  12.62   2.292.35
   query30  0.600.470.52
   query31  2.800.390.38
   query32  3.390.500.49
   query33  3.073.093.10
   query34  15.26   4.784.78
   query35  4.874.844.84
   query36  1.061.021.02
   query37  0.050.040.05
   query38  0.030.020.02
   query39  0.020.010.01
   query40  0.160.140.14
   query41  0.060.010.01
   query42  0.020.010.02
   query43  0.020.020.02
   Total cold run time: 101.51 s
   Total hot run time: 31.28 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) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 203210 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 02a79e75fe4401a4cc10144bf9b5b1732788a4fb, 
data reload: false
   
   query1   941 394 384 384
   query2   6518285227762776
   query3   6923213 208 208
   query4   20491   17860   17989   17860
   query5   19719   648565226485
   query6   294 215 236 215
   query7   4158295 306 295
   query8   255 240 227 227
   query9   3162270626292629
   query10  430 305 304 304
   query11  11328   10683   10755   10683
   query12  128 78  73  73
   query13  5580696 697 696
   query14  17583   13201   13989   13201
   query15  366 220 234 220
   query16  6466271 256 256
   query17  17141473855 855
   query18  2324409 402 402
   query19  202 144 147 144
   query20  76  78  76  76
   query21  197 93  99  93
   query22  5074490851014908
   query23  32551   31906   32034   31906
   query24  6993646965416469
   query25  515 456 416 416
   query26  524 165 161 161
   query27  1883296 299 296
   query28  6183237023332333
   query29  2829260727132607
   query30  242 163 165 163
   query31  891 757 767 757
   query32  67  63  59  59
   query33  401 242 235 235
   query34  883 460 486 460
   query35  896 954 896
   query36  1439126811591159
   query37  90  57  60  57
   query38  3089293429482934
   query39  1375134513221322
   query40  196 95  91  91
   query41  38  41  36  36
   query42  88  82  86  82
   query43  726 719 839 719
   query44  1117719 717 717
   query45  244 231 232 231
   query46  1226936 970 936
   query47  1901183317901790
   query48  1001699 701 699
   query49  611 375 359 359
   query50  878 646 631 631
   query51  4739467747124677
   query52  84  81  80  80
   query53  444 322 313 313
   query54  2623247224692469
   query55  91  88  79  79
   query56  211 206 216 206
   query57  1194112011081108
   query58  201 215 202 202
   query59  4428396939233923
   query60  220 200 211 200
   query61  91  85  87  85
   query62  823 441 516 441
   query63  469 348 340 340
   query64  2596152515071507
   query65  3661356935893569
   query66  753 378 399 378
   query67  18277   15323   16803   15323
   query68  4887656 647 647
   query69  527 344 343 343
   query70  1406148315581483
   query71  384 306 325 306
   query72  6207339834313398
   query73  719 332 322 322
   query74  6327590558625862
   query75  4331377337993773
   query76  2985115811821158
   query77  453 251 252 251
   query78  12458   11594   11917   11594
   query79  6769622 645 622
   query80  2831401 394 394
   query81  530 233 229 229
   query82  139497  99  97
   query83  261 132 127 127
   query84  249 73  68  68
   query85  1378305 294 294
   query86  362 309 291 291
   query87  3260299530432995
   query88  4684236723602360
   query89  338 283 282 282
   query90  1702210 207 207
   query91  184 146 134 134
   query92  53  54  54  54
   query93  2262566 591 566
   query94  906 199 206 199
   query95  1113106310331033
   query96  651 331 342 331
   query97  6461637463536353
   query98  193 170 171 170
   query99  30641006856 856
   Total cold run time: 303255 ms
   Total hot run time: 203210 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](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 49421 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 02a79e75fe4401a4cc10144bf9b5b1732788a4fb, 
data reload: false
   
   -- Round 1 --
   q1   17771   439943094309
   q2   2026155 142 142
   q3   10470   191119511911
   q4   10309   123513221235
   q5   8500382439033824
   q6   228 123 121 121
   q7   1988159816001598
   q8   9321271227162712
   q9   10519   10310   10207   10207
   q10  8611357335263526
   q11  428 246 247 246
   q12  468 295 301 295
   q13  18351   395140353951
   q14  355 325 321 321
   q15  512 452 452 452
   q16  678 565 569 565
   q17  1139980 920 920
   q18  7299678269326782
   q19  1724160015421542
   q20  528 294 315 294
   q21  413940894089
   q22  493 379 398 379
   Total cold run time: 116162 ms
   Total hot run time: 49421 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4324430342844284
   q2   324 218 223 218
   q3   4185415941574157
   q4   2728274127382738
   q5   7201712571527125
   q6   237 117 115 115
   q7   3239288928452845
   q8   4355445044694450
   q9   16935   16692   16674   16674
   q10  4258423542454235
   q11  758 690 686 686
   q12  1019852 880 852
   q13  6363373537223722
   q14  462 416 430 416
   q15  512 459 463 459
   q16  726 681 711 681
   q17  3844386038323832
   q18  8850893488038803
   q19  1718170016221622
   q20  2376216721262126
   q21  8639853485378534
   q22  999 934 927 927
   Total cold run time: 84052 ms
   Total hot run time: 79501 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](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


zhiqiang- commented on PR #35264:
URL: https://github.com/apache/doris/pull/35264#issuecomment-2126710073

   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) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 203305 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 48b02148221f9eea270e634e2761256d8d16dd29, 
data reload: false
   
   query1   942 401 374 374
   query2   6523289626662666
   query3   6922215 209 209
   query4   21147   17936   18013   17936
   query5   19729   646365176463
   query6   282 219 230 219
   query7   4154296 308 296
   query8   243 255 233 233
   query9   3101266525882588
   query10  405 296 297 296
   query11  11244   10726   10771   10726
   query12  128 84  72  72
   query13  5585674 683 674
   query14  17395   13746   13354   13354
   query15  370 226 230 226
   query16  6458271 253 253
   query17  17421455876 876
   query18  2321406 404 404
   query19  207 145 145 145
   query20  84  80  80  80
   query21  193 95  94  94
   query22  5276507350945073
   query23  32777   31866   32104   31866
   query24  7010655065556550
   query25  519 438 411 411
   query26  520 169 162 162
   query27  1817297 300 297
   query28  6121235723242324
   query29  2925280826292629
   query30  250 163 167 163
   query31  941 750 768 750
   query32  69  65  62  62
   query33  390 271 250 250
   query34  872 466 478 466
   query35  1141893 956 893
   query36  1360129511931193
   query37  86  61  61  61
   query38  3072293129182918
   query39  1360133113361331
   query40  202 94  93  93
   query41  38  42  36  36
   query42  89  80  84  80
   query43  742 630 712 630
   query44  1100710 706 706
   query45  239 233 233 233
   query46  1207960 997 960
   query47  1977165617241656
   query48  989 715 689 689
   query49  630 375 366 366
   query50  860 574 580 574
   query51  4776473445824582
   query52  88  78  81  78
   query53  435 319 325 319
   query54  2644244124762441
   query55  94  85  81  81
   query56  236 222 219 219
   query57  1229103011431030
   query58  222 202 187 187
   query59  4513409938723872
   query60  213 200 200 200
   query61  93  86  87  86
   query62  727 479 468 468
   query63  483 338 329 329
   query64  2338150413821382
   query65  3641358235603560
   query66  776 372 381 372
   query67  16524   15900   15220   15220
   query68  6698641 654 641
   query69  566 355 366 355
   query70  1562144812761276
   query71  400 303 315 303
   query72  6463344334733443
   query73  730 321 321 321
   query74  6330587059145870
   query75  4607381237603760
   query76  4411118012181180
   query77  544 261 254 254
   query78  12661   12060   11940   11940
   query79  8880656 657 656
   query80  2010400 389 389
   query81  500 232 230 230
   query82  1458103 94  94
   query83  166 132 136 132
   query84  257 69  70  69
   query85  1157306 301 301
   query86  358 297 302 297
   query87  3198302230553022
   query88  5193237623722372
   query89  369 304 302 302
   query90  1820208 210 208
   query91  178 137 134 134
   query92  58  52  54  52
   query93  4947564 607 564
   query94  761 204 206 204
   query95  1096105110751051
   query96  654 343 339 339
   query97  6485644064046404
   query98  183 171 164 164
   query99  29681004946 946
   Total cold run time: 310454 ms
   Total hot run time: 203305 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](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 50008 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 48b02148221f9eea270e634e2761256d8d16dd29, 
data reload: false
   
   -- Round 1 --
   q1   17715   441743494349
   q2   2057155 148 148
   q3   10537   193119471931
   q4   10334   124813071248
   q5   8611389639223896
   q6   236 125 123 123
   q7   2018157916031579
   q8   9360271226902690
   q9   10826   10503   10513   10503
   q10  8635352835183518
   q11  435 236 255 236
   q12  468 299 300 299
   q13  18353   397439963974
   q14  359 327 327 327
   q15  520 445 463 445
   q16  685 567 567 567
   q17  1129950 963 950
   q18  7207704570427042
   q19  1695160815501550
   q20  521 305 281 281
   q21  4475415039713971
   q22  488 387 381 381
   Total cold run time: 116664 ms
   Total hot run time: 50008 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4355428542584258
   q2   317 220 219 219
   q3   4166416141344134
   q4   2746273327352733
   q5   7269716871807168
   q6   236 125 117 117
   q7   3212286428432843
   q8   4380447745214477
   q9   17398   17255   17245   17245
   q10  4276426742574257
   q11  788 703 684 684
   q12  1054855 867 855
   q13  6931374237173717
   q14  444 425 431 425
   q15  506 460 447 447
   q16  729 685 673 673
   q17  3824385138613851
   q18  8650868587798685
   q19  1700169816561656
   q20  2369212020942094
   q21  8642850685778506
   q22  980 915 924 915
   Total cold run time: 84972 ms
   Total hot run time: 79959 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](function) money format #34680 [doris]

2024-05-23 Thread via GitHub


zhiqiang- commented on PR #35264:
URL: https://github.com/apache/doris/pull/35264#issuecomment-2126612042

   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) money format #34680 [doris]

2024-05-22 Thread via GitHub


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

   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](function) money format #34680 [doris]

2024-05-22 Thread via GitHub


zhiqiang- commented on PR #35264:
URL: https://github.com/apache/doris/pull/35264#issuecomment-2126204975

   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