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

2025-01-15 Thread via GitHub


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

   
   
   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 ddfc98ba864c2ea69c57bce1eec8c4a07a56f72d, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.040.03
   query3   0.240.070.06
   query4   1.610.100.10
   query5   0.420.440.41
   query6   1.160.640.65
   query7   0.030.020.01
   query8   0.040.020.03
   query9   0.590.530.51
   query10  0.580.560.55
   query11  0.140.100.10
   query12  0.140.110.11
   query13  0.610.600.60
   query14  2.762.712.69
   query15  0.910.830.83
   query16  0.360.400.38
   query17  1.051.051.01
   query18  0.220.210.21
   query19  1.981.852.00
   query20  0.010.010.01
   query21  15.36   0.980.59
   query22  0.740.930.66
   query23  15.15   1.450.53
   query24  2.531.281.50
   query25  0.230.190.07
   query26  0.200.150.14
   query27  0.060.070.05
   query28  13.84   1.040.42
   query29  12.54   3.913.26
   query30  0.250.090.06
   query31  2.820.600.39
   query32  3.220.540.45
   query33  3.033.013.04
   query34  16.71   5.114.50
   query35  4.614.554.51
   query36  0.660.490.48
   query37  0.100.060.06
   query38  0.050.030.03
   query39  0.030.020.03
   query40  0.160.130.12
   query41  0.080.030.03
   query42  0.040.020.02
   query43  0.040.030.02
   Total cold run time: 105.4 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2025-01-15 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 195728 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 ddfc98ba864c2ea69c57bce1eec8c4a07a56f72d, 
data reload: false
   
   query1   1328962 919 919
   query2   6306208220812081
   query3   11095   454444994499
   query4   61505   28744   23317   23317
   query5   5584621 460 460
   query6   447 204 185 185
   query7   5605510 306 306
   query8   337 249 243 243
   query9   8508269927022699
   query10  457 322 254 254
   query11  17469   15055   15836   15055
   query12  165 111 121 111
   query13  1464559 416 416
   query14  11528   734074147340
   query15  213 203 184 184
   query16  6987657 489 489
   query17  1220716 572 572
   query18  1201384 318 318
   query19  198 207 157 157
   query20  114 116 111 111
   query21  207 120 130 120
   query22  4523495546184618
   query23  33972   33401   33508   33401
   query24  5654229822922292
   query25  477 460 403 403
   query26  642 273 152 152
   query27  1834459 330 330
   query28  4192248124542454
   query29  542 548 413 413
   query30  212 193 152 152
   query31  916 865 783 783
   query32  73  62  82  62
   query33  445 351 308 308
   query34  759 878 520 520
   query35  816 832 774 774
   query36  10201056945 945
   query37  129 105 80  80
   query38  4288430742484248
   query39  1534150614671467
   query40  201 115 104 104
   query41  53  54  51  51
   query42  129 103 103 103
   query43  505 536 502 502
   query44  1363859 818 818
   query45  191 181 172 172
   query46  905 1058666 666
   query47  1927193618791879
   query48  395 405 316 316
   query49  722 510 411 411
   query50  674 683 411 411
   query51  7121718770407040
   query52  106 100 88  88
   query53  221 250 184 184
   query54  483 520 418 418
   query55  88  81  82  81
   query56  258 293 247 247
   query57  1247118910931093
   query58  244 236 231 231
   query59  2967303529502950
   query60  269 264 253 253
   query61  118 117 116 116
   query62  744 716 649 649
   query63  232 186 183 183
   query64  13341030662 662
   query65  3271314831683148
   query66  653 401 295 295
   query67  16042   15643   15675   15643
   query68  5030841 541 541
   query69  490 298 255 255
   query70  1198109111411091
   query71  427 286 251 251
   query72  6283385838023802
   query73  820 765 366 366
   query74  9966925890089008
   query75  3219315226792679
   query76  37071198772 772
   query77  465 382 276 276
   query78  10216   10085   96299629
   query79  2394826 600 600
   query80  1088516 464 464
   query81  537 273 237 237
   query82  342 157 121 121
   query83  240 165 162 162
   query84  286 92  73  73
   query85  749 353 296 296
   query86  407 310 302 302
   query87  4573452644154415
   query88  3489222621872187
   query89  396 322 293 293
   query90  1606188 192 188
   query91  137 139 109 109
   query92  65  60  52  52
   query93  2224864 536 536
   query94  767 387 311 311
   query95  334 273 257 257
   query96  483 613 287 287
   query97  2794289227532753
   query98  225 201 198 198
   query99  1281135812651265
   Total cold run time: 312667 ms
   Total hot run time: 195728 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2025-01-15 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32087 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ddfc98ba864c2ea69c57bce1eec8c4a07a56f72d, 
data reload: false
   
   -- Round 1 --
   q1   17575   583254395439
   q2   2050289 169 169
   q3   10613   1250725 725
   q4   10198   956 527 527
   q5   7528236621402140
   q6   188 163 130 130
   q7   893 782 588 588
   q8   9226133511351135
   q9   5229486949244869
   q10  6860231518621862
   q11  468 279 261 261
   q12  334 360 224 224
   q13  17766   367330643064
   q14  224 247 205 205
   q15  521 484 483 483
   q16  620 630 582 582
   q17  549 847 323 323
   q18  6746639764016397
   q19  1215953 530 530
   q20  308 316 187 187
   q21  2805216119441944
   q22  366 332 303 303
   Total cold run time: 102282 ms
   Total hot run time: 32087 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5508545954385438
   q2   250 339 237 237
   q3   2374278524542454
   q4   1536188614241424
   q5   4433476646344634
   q6   164 165 123 123
   q7   2053195418041804
   q8   2633281826882688
   q9   7307728672537253
   q10  3054331527702770
   q11  576 502 501 501
   q12  658 736 631 631
   q13  3466398632753275
   q14  291 301 274 274
   q15  543 485 482 482
   q16  658 696 643 643
   q17  1204176112851285
   q18  7760759373637363
   q19  793 117410541054
   q20  2012207918841884
   q21  5818517550125012
   q22  636 632 567 567
   Total cold run time: 53727 ms
   Total hot run time: 51796 ms
   ```
   
   


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

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

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


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



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

2025-01-15 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2593554294

   run buildall


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

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

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


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



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

2025-01-14 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.42 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 589106a39ac59447391ad2f85272f954a29bdcbb, 
data reload: false
   
   query1   0.040.030.02
   query2   0.080.030.04
   query3   0.230.070.06
   query4   1.630.100.11
   query5   0.420.420.42
   query6   1.160.660.65
   query7   0.020.020.01
   query8   0.040.030.04
   query9   0.590.520.50
   query10  0.550.550.55
   query11  0.140.100.10
   query12  0.140.110.11
   query13  0.610.590.60
   query14  2.832.892.91
   query15  0.900.820.81
   query16  0.380.380.39
   query17  1.050.991.05
   query18  0.220.200.21
   query19  1.911.801.96
   query20  0.020.000.01
   query21  15.37   0.960.59
   query22  0.740.740.64
   query23  15.40   1.350.57
   query24  2.521.251.82
   query25  0.230.210.05
   query26  0.210.140.14
   query27  0.090.050.06
   query28  13.84   1.491.04
   query29  12.56   3.923.22
   query30  0.250.080.06
   query31  2.830.590.39
   query32  3.230.540.47
   query33  3.042.963.01
   query34  17.00   5.084.50
   query35  4.544.464.52
   query36  0.640.480.49
   query37  0.090.060.06
   query38  0.040.040.03
   query39  0.040.020.02
   query40  0.160.130.12
   query41  0.080.030.03
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 105.93 s
   Total hot run time: 31.42 s
   ```
   
   


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

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

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


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



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

2025-01-14 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 195413 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 589106a39ac59447391ad2f85272f954a29bdcbb, 
data reload: false
   
   query1   1325970 939 939
   query2   6272205719141914
   query3   10963   458544924492
   query4   61668   29156   23783   23783
   query5   5568605 454 454
   query6   418 185 182 182
   query7   5557518 296 296
   query8   331 226 222 222
   query9   8514275327382738
   query10  437 311 256 256
   query11  17560   15184   15574   15184
   query12  168 115 106 106
   query13  1428548 461 461
   query14  10492   736272627262
   query15  224 204 193 193
   query16  7219649 445 445
   query17  1137748 589 589
   query18  1943418 318 318
   query19  209 186 159 159
   query20  158 112 108 108
   query21  209 126 104 104
   query22  4229446744074407
   query23  34472   33650   33646   33646
   query24  5498234723492347
   query25  482 467 401 401
   query26  659 292 156 156
   query27  1625508 334 334
   query28  4134255124492449
   query29  550 562 423 423
   query30  211 187 171 171
   query31  975 875 832 832
   query32  71  66  62  62
   query33  425 354 311 311
   query34  784 887 517 517
   query35  816 844 779 779
   query36  10161058951 951
   query37  126 104 77  77
   query38  4190432041684168
   query39  1483147214041404
   query40  217 118 125 118
   query41  55  51  51  51
   query42  117 101 105 101
   query43  561 535 499 499
   query44  1395885 853 853
   query45  183 174 170 170
   query46  913 1068668 668
   query47  1902190618081808
   query48  390 415 332 332
   query49  704 500 391 391
   query50  679 666 409 409
   query51  7017698368926892
   query52  107 105 99  99
   query53  232 270 189 189
   query54  486 513 416 416
   query55  85  80  82  80
   query56  268 272 264 264
   query57  1215119911251125
   query58  246 241 239 239
   query59  3212331929142914
   query60  274 265 257 257
   query61  116 146 111 111
   query62  793 782 704 704
   query63  223 189 197 189
   query64  12861038659 659
   query65  3249314631733146
   query66  719 402 363 363
   query67  15876   15382   15380   15380
   query68  5691847 535 535
   query69  490 291 261 261
   query70  1204113511411135
   query71  416 288 255 255
   query72  6123392637143714
   query73  807 781 356 356
   query74  10190   906588918891
   query75  3307318626482648
   query76  37851188789 789
   query77  491 387 276 276
   query78  999392569256
   query79  3041855 608 608
   query80  697 544 524 524
   query81  499 288 239 239
   query82  247 156 116 116
   query83  179 168 153 153
   query84  289 91  69  69
   query85  751 377 300 300
   query86  373 302 281 281
   query87  4447451443914391
   query88  4246221521892189
   query89  401 328 287 287
   query90  1677195 190 190
   query91  135 146 107 107
   query92  66  59  56  56
   query93  2750886 538 538
   query94  673 386 296 296
   query95  334 267 265 265
   query96  511 619 279 279
   query97  2860285727442744
   query98  233 199 195 195
   query99  1375151614031403
   Total cold run time: 314347 ms
   Total hot run time: 195413 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2025-01-14 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33048 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 589106a39ac59447391ad2f85272f954a29bdcbb, 
data reload: false
   
   -- Round 1 --
   q1   17595   628560546054
   q2   2053319 180 180
   q3   10473   1246756 756
   q4   10268   882 458 458
   q5   8687225020332033
   q6   221 180 148 148
   q7   910 757 606 606
   q8   9242149113061306
   q9   5245498350184983
   q10  6846231718391839
   q11  515 285 258 258
   q12  349 392 236 236
   q13  18154   377130963096
   q14  238 239 202 202
   q15  595 520 522 520
   q16  631 625 596 596
   q17  576 896 330 330
   q18  6850642162966296
   q19  25521039587 587
   q20  314 333 186 186
   q21  2938230420602060
   q22  370 342 318 318
   Total cold run time: 105622 ms
   Total hot run time: 33048 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6618629464796294
   q2   249 339 239 239
   q3   2314266323512351
   q4   1413182613831383
   q5   4332488149474881
   q6   209 184 144 144
   q7   2117197218291829
   q8   2763290327892789
   q9   7256726872327232
   q10  3064328428492849
   q11  627 537 492 492
   q12  684 801 641 641
   q13  3594399532983298
   q14  302 300 277 277
   q15  574 537 525 525
   q16  667 697 641 641
   q17  1253183512901290
   q18  7682741574027402
   q19  828 126512451245
   q20  2000203619291929
   q21  5658535750835083
   q22  616 611 566 566
   Total cold run time: 54820 ms
   Total hot run time: 53380 ms
   ```
   
   


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

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

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


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



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

2025-01-14 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2589777367

   run buildall


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

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

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


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



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

2024-12-27 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.17 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   query1   0.030.040.06
   query2   0.080.040.03
   query3   0.240.070.07
   query4   1.610.100.10
   query5   0.410.420.41
   query6   1.160.650.64
   query7   0.020.010.01
   query8   0.040.030.04
   query9   0.590.500.53
   query10  0.570.580.54
   query11  0.150.110.11
   query12  0.150.110.10
   query13  0.600.600.59
   query14  2.732.762.89
   query15  0.890.830.83
   query16  0.390.380.39
   query17  1.041.011.04
   query18  0.220.220.22
   query19  1.991.821.99
   query20  0.010.010.02
   query21  15.38   0.890.59
   query22  0.760.750.73
   query23  15.29   1.440.54
   query24  3.580.711.73
   query25  0.230.250.08
   query26  0.270.140.13
   query27  0.050.050.06
   query28  13.85   1.491.05
   query29  12.59   4.053.35
   query30  0.250.090.06
   query31  2.830.580.37
   query32  3.220.540.46
   query33  3.123.243.14
   query34  16.95   5.114.49
   query35  4.494.424.50
   query36  0.660.510.49
   query37  0.100.060.06
   query38  0.040.040.03
   query39  0.030.020.02
   query40  0.160.130.13
   query41  0.080.040.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 106.93 s
   Total hot run time: 31.17 s
   ```
   
   


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

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

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


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



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

2024-12-27 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196553 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 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   query1   1300945 955 945
   query2   6377228323532283
   query3   10954   480447274727
   query4   33120   24143   23366   23366
   query5   4651643 456 456
   query6   287 204 189 189
   query7   3994495 309 309
   query8   286 234 226 226
   query9   9499273327202720
   query10  465 304 268 268
   query11  17906   15344   15234   15234
   query12  153 109 105 105
   query13  1564560 415 415
   query14  11263   721272077207
   query15  244 211 192 192
   query16  8036629 467 467
   query17  1520761 565 565
   query18  2132429 315 315
   query19  189 182 159 159
   query20  156 112 113 112
   query21  200 128 106 106
   query22  4774467246144614
   query23  34023   33671   33554   33554
   query24  6486233723062306
   query25  484 460 388 388
   query26  828 272 152 152
   query27  2030473 325 325
   query28  5751249724692469
   query29  686 578 451 451
   query30  214 189 155 155
   query31  1029933 857 857
   query32  91  61  61  61
   query33  486 362 329 329
   query34  774 856 548 548
   query35  808 836 768 768
   query36  10271059958 958
   query37  118 96  78  78
   query38  4296430241034103
   query39  1538148014491449
   query40  222 114 100 100
   query41  50  45  47  45
   query42  128 103 103 103
   query43  517 525 501 501
   query44  1318834 826 826
   query45  187 179 181 179
   query46  902 1069673 673
   query47  1970199019311931
   query48  408 419 340 340
   query49  719 482 395 395
   query50  668 672 410 410
   query51  7454783472347234
   query52  104 98  93  93
   query53  237 255 194 194
   query54  494 500 415 415
   query55  82  79  79  79
   query56  260 272 269 269
   query57  1228121411431143
   query58  239 236 222 222
   query59  3054332729632963
   query60  282 303 259 259
   query61  113 112 108 108
   query62  865 801 773 773
   query63  238 197 198 197
   query64  36731035663 663
   query65  3364323032873230
   query66  744 400 327 327
   query67  16333   16253   15671   15671
   query68  9783755 515 515
   query69  491 295 252 252
   query70  1267115311011101
   query71  434 277 258 258
   query72  6287424437843784
   query73  657 758 367 367
   query74  10290   909087868786
   query75  4617316826862686
   query76  49171188752 752
   query77  1006375 281 281
   query78  10263   10226   93899389
   query79  2714884 608 608
   query80  735 610 425 425
   query81  495 269 226 226
   query82  214 152 122 122
   query83  180 163 143 143
   query84  297 94  70  70
   query85  754 368 311 311
   query86  351 317 282 282
   query87  4451454743734373
   query88  3548222822042204
   query89  444 328 294 294
   query90  2128185 189 185
   query91  135 131 105 105
   query92  68  57  51  51
   query93  2009879 521 521
   query94  686 395 301 301
   query95  326 267 257 257
   query96  499 606 302 302
   query97  2747279527152715
   query98  230 203 200 200
   query99  1643153314131413
   Total cold run time: 300258 ms
   Total hot run time: 196553 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-12-27 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32271 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   -- Round 1 --
   q1   17579   609160176017
   q2   2047303 177 177
   q3   10408   1202727 727
   q4   10181   852 419 419
   q5   7518216419651965
   q6   211 181 151 151
   q7   887 758 582 582
   q8   9217133810971097
   q9   5228496148804880
   q10  6768231218651865
   q11  466 278 255 255
   q12  352 358 221 221
   q13  17756   356830053005
   q14  237 230 209 209
   q15  565 506 496 496
   q16  628 604 582 582
   q17  567 834 328 328
   q18  6968645062966296
   q19  1473959 543 543
   q20  320 321 186 186
   q21  2863219119551955
   q22  358 340 315 315
   Total cold run time: 102597 ms
   Total hot run time: 32271 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6240620161946194
   q2   236 321 236 236
   q3   2220263623052305
   q4   1404182213251325
   q5   4334472046734673
   q6   194 180 141 141
   q7   2096197118031803
   q8   2579280026952695
   q9   7284722472347224
   q10  3068336127962796
   q11  589 520 504 504
   q12  655 725 569 569
   q13  3436375431393139
   q14  293 297 285 285
   q15  571 524 508 508
   q16  671 691 656 656
   q17  1187172112791279
   q18  7691746273807380
   q19  795 114710511051
   q20  1953200919201920
   q21  5746529647904790
   q22  659 571 576 571
   Total cold run time: 53901 ms
   Total hot run time: 52044 ms
   ```
   
   


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

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

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


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



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

2024-12-27 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2563929914

   run buildall


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

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

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


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



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

2024-12-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.46 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   query1   0.030.030.02
   query2   0.100.030.03
   query3   0.240.080.07
   query4   1.590.100.10
   query5   0.410.390.43
   query6   1.150.650.65
   query7   0.020.010.02
   query8   0.040.030.03
   query9   0.600.500.51
   query10  0.570.570.55
   query11  0.140.110.11
   query12  0.140.110.12
   query13  0.600.610.58
   query14  2.842.782.77
   query15  0.890.830.82
   query16  0.380.370.37
   query17  1.001.071.05
   query18  0.230.220.21
   query19  1.951.812.01
   query20  0.010.010.00
   query21  15.36   0.580.61
   query22  2.942.431.58
   query23  16.93   0.890.82
   query24  3.641.471.00
   query25  0.290.220.15
   query26  0.360.140.14
   query27  0.050.040.04
   query28  9.971.121.07
   query29  12.61   3.233.22
   query30  0.240.060.06
   query31  2.850.380.37
   query32  3.250.460.45
   query33  3.183.053.05
   query34  16.92   4.504.53
   query35  4.544.464.55
   query36  0.650.470.51
   query37  0.100.060.07
   query38  0.050.040.03
   query39  0.040.020.02
   query40  0.180.130.13
   query41  0.080.030.03
   query42  0.040.020.02
   query43  0.040.030.04
   Total cold run time: 107.24 s
   Total hot run time: 32.46 s
   ```
   
   


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

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

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


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



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

2024-12-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196707 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 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   query1   1274957 935 935
   query2   6224233523012301
   query3   11104   474546504650
   query4   33515   23402   23399   23399
   query5   4398466 455 455
   query6   280 193 196 193
   query7   4008307 320 307
   query8   310 246 234 234
   query9   9770275027582750
   query10  482 243 241 241
   query11  17930   15244   15168   15168
   query12  159 109 105 105
   query13  1587422 443 422
   query14  9895661368836613
   query15  279 223 190 190
   query16  8217444 480 444
   query17  1632627 619 619
   query18  2209320 349 320
   query19  357 166 164 164
   query20  120 111 111 111
   query21  211 115 110 110
   query22  4824446644844466
   query23  35334   33669   33919   33669
   query24  10342   257425062506
   query25  603 417 408 408
   query26  1190154 163 154
   query27  2286342 340 340
   query28  7041252224922492
   query29  828 417 431 417
   query30  227 148 154 148
   query31  1033853 812 812
   query32  98  57  60  57
   query33  795 302 298 298
   query34  986 531 522 522
   query35  934 770 779 770
   query36  1128958 976 958
   query37  133 74  76  74
   query38  4175422344144223
   query39  1536146214481448
   query40  213 102 100 100
   query41  49  43  43  43
   query42  123 108 110 108
   query43  543 507 510 507
   query44  1324828 836 828
   query45  196 167 171 167
   query46  1177730 702 702
   query47  2071192219161916
   query48  426 326 325 325
   query49  891 398 411 398
   query50  824 397 403 397
   query51  7355718772347187
   query52  107 98  98  98
   query53  267 194 185 185
   query54  1069416 450 416
   query55  83  81  78  78
   query56  273 274 250 250
   query57  1309118111741174
   query58  241 222 223 222
   query59  3516319833503198
   query60  289 277 258 258
   query61  114 128 106 106
   query62  838 725 693 693
   query63  229 210 198 198
   query64  3903707 687 687
   query65  3277325533043255
   query66  702 312 309 309
   query67  16548   15497   15530   15497
   query68  6026563 587 563
   query69  489 264 254 254
   query70  1193113811401138
   query71  511 257 256 256
   query72  6946411741614117
   query73  791 368 375 368
   query74  10093   880088038800
   query75  3953263926952639
   query76  4441112211081108
   query77  675 313 279 279
   query78  10262   943495409434
   query79  1512614 600 600
   query80  1172429 462 429
   query81  505 230 226 226
   query82  232 115 119 115
   query83  199 143 140 140
   query84  291 81  72  72
   query85  966 333 308 308
   query86  353 303 300 300
   query87  4695444544834445
   query88  4138223922032203
   query89  432 291 286 286
   query90  2052189 189 189
   query91  138 103 106 103
   query92  64  52  50  50
   query93  3496562 551 551
   query94  757 281 271 271
   query95  349 256 258 256
   query96  626 275 294 275
   query97  2861262926752629
   query98  218 195 194 194
   query99  1605131413241314
   Total cold run time: 307452 ms
   Total hot run time: 196707 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-12-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39752 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9ccdb8a5ca71d85e7016ed0038b13f9c7abddcda, 
data reload: false
   
   -- Round 1 --
   q1   17607   743174237423
   q2   2048177 176 176
   q3   10681   1159
   q4   10551   710 677 677
   q5   7596263026542630
   q6   257 151 152 151
   q7   1071622 589 589
   q8   9247180719081807
   q9   6566640764636407
   q10  7002231123132311
   q11  466 265 257 257
   q12  422 229 229 229
   q13  17761   287928952879
   q14  250 210 207 207
   q15  544 506 514 506
   q16  687 584 590 584
   q17  977 555 541 541
   q18  7230670666416641
   q19  1375995 930 930
   q20  468 179 185 179
   q21  4204329532063206
   q22  381 311 311 311
   Total cold run time: 107391 ms
   Total hot run time: 39752 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7238726172487248
   q2   334 227 232 227
   q3   2878275729302757
   q4   2037175018231750
   q5   5571564756255625
   q6   225 143 153 143
   q7   2248181617971797
   q8   3335356635203520
   q9   8943896289408940
   q10  3575351935233519
   q11  624 521 531 521
   q12  830 600 590 590
   q13  13167   310330473047
   q14  301 282 285 282
   q15  559 499 500 499
   q16  712 629 670 629
   q17  1852164615931593
   q18  8275772878357728
   q19  1732145016241450
   q20  2070189018451845
   q21  5629551953385338
   q22  654 602 575 575
   Total cold run time: 72789 ms
   Total hot run time: 59623 ms
   ```
   
   


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

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

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


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



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

2024-12-23 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2560146347

   run buildall


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

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

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


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



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

2024-12-20 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.45 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9185e2068331f6ef1126e3bb6683c4f67357b8f8, 
data reload: false
   
   query1   0.040.030.03
   query2   0.070.030.04
   query3   0.240.070.07
   query4   1.600.100.10
   query5   0.410.410.41
   query6   1.170.650.65
   query7   0.030.020.01
   query8   0.040.030.03
   query9   0.600.510.51
   query10  0.550.570.55
   query11  0.140.100.11
   query12  0.140.110.11
   query13  0.610.620.59
   query14  2.842.862.76
   query15  0.900.820.81
   query16  0.380.370.38
   query17  1.031.001.01
   query18  0.230.210.21
   query19  1.901.771.96
   query20  0.020.010.01
   query21  15.38   0.580.59
   query22  2.942.711.75
   query23  16.87   1.040.89
   query24  3.310.691.47
   query25  0.250.210.17
   query26  0.410.140.14
   query27  0.050.040.03
   query28  10.70   1.081.07
   query29  12.62   3.283.27
   query30  0.240.070.06
   query31  2.830.370.38
   query32  3.270.460.45
   query33  3.093.143.24
   query34  17.03   4.464.47
   query35  4.444.474.49
   query36  0.670.480.48
   query37  0.100.060.06
   query38  0.050.040.03
   query39  0.040.020.03
   query40  0.170.130.14
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 107.56 s
   Total hot run time: 32.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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-12-20 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 195965 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 9185e2068331f6ef1126e3bb6683c4f67357b8f8, 
data reload: false
   
   query1   1298953 965 953
   query2   6254236524152365
   query3   10992   468348404683
   query4   33101   23412   23426   23412
   query5   4077445 445 445
   query6   281 172 177 172
   query7   3979297 306 297
   query8   286 221 222 221
   query9   9571271627062706
   query10  492 258 252 252
   query11  18000   15064   15148   15064
   query12  153 105 105 105
   query13  1591430 424 424
   query14  9889664974276649
   query15  295 209 199 199
   query16  8314439 492 439
   query17  1742606 563 563
   query18  2197297 314 297
   query19  382 160 160 160
   query20  129 116 114 114
   query21  208 106 106 106
   query22  4937457845934578
   query23  34476   35689   33697   33697
   query24  10804   248924762476
   query25  522 398 385 385
   query26  709 162 170 162
   query27  2660337 341 337
   query28  7873251924982498
   query29  679 432 416 416
   query30  226 147 146 146
   query31  1032821 834 821
   query32  98  60  63  60
   query33  769 297 290 290
   query34  995 526 516 516
   query35  886 786 758 758
   query36  1108955 961 955
   query37  123 71  75  71
   query38  4188427242214221
   query39  1518144914591449
   query40  210 106 100 100
   query41  44  48  43  43
   query42  117 107 109 107
   query43  550 494 474 474
   query44  1296827 815 815
   query45  190 174 175 174
   query46  1178728 702 702
   query47  2080194619111911
   query48  422 344 328 328
   query49  919 398 384 384
   query50  847 421 396 396
   query51  7291726272527252
   query52  106 93  96  93
   query53  275 182 191 182
   query54  1226446 442 442
   query55  92  78  83  78
   query56  276 270 253 253
   query57  1306117811651165
   query58  250 212 221 212
   query59  3286325430243024
   query60  277 261 264 261
   query61  133 129 130 129
   query62  881 672 682 672
   query63  221 192 198 192
   query64  3881733 640 640
   query65  3266320731963196
   query66  841 311 293 293
   query67  15803   15676   15551   15551
   query68  6483559 543 543
   query69  499 251 254 251
   query70  1156111610411041
   query71  539 249 256 249
   query72  6298408339993999
   query73  900 369 379 369
   query74  10397   896787608760
   query75  4161266826422642
   query76  4189106711601067
   query77  719 283 276 276
   query78  10286   939293519351
   query79  2220599 600 599
   query80  773 427 428 427
   query81  529 248 228 228
   query82  1324129 131 129
   query83  173 150 147 147
   query84  246 74  78  74
   query85  1594306 323 306
   query86  465 296 287 287
   query87  4561437943304330
   query88  3900222621832183
   query89  431 291 305 291
   query90  2116189 189 189
   query91  137 108 105 105
   query92  62  52  50  50
   query93  2666546 551 546
   query94  978 278 280 278
   query95  347 250 250 250
   query96  626 272 279 272
   query97  2883269026672667
   query98  236 202 199 199
   query99  1589132913321329
   Total cold run time: 307581 ms
   Total hot run time: 195965 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-12-20 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40075 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9185e2068331f6ef1126e3bb6683c4f67357b8f8, 
data reload: false
   
   -- Round 1 --
   q1   17624   754073487348
   q2   2057192 182 182
   q3   10659   111312261113
   q4   10584   789 716 716
   q5   7621275327392739
   q6   240 149 148 148
   q7   997 630 598 598
   q8   9254187819211878
   q9   6641647064816470
   q10  6955232123842321
   q11  470 258 264 258
   q12  430 218 218 218
   q13  17800   288628942886
   q14  250 220 209 209
   q15  558 523 497 497
   q16  675 591 581 581
   q17  1003509 564 509
   q18  7283676867386738
   q19  1385985 918 918
   q20  497 187 188 187
   q21  4011324833073248
   q22  373 325 313 313
   Total cold run time: 107367 ms
   Total hot run time: 40075 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7214721180137211
   q2   332 235 233 233
   q3   2926287829362878
   q4   2076186418571857
   q5   5677567956605660
   q6   234 142 146 142
   q7   2250186017641764
   q8   3412355935373537
   q9   8886902389118911
   q10  3591355235743552
   q11  607 511 497 497
   q12  808 605 597 597
   q13  13328   320731363136
   q14  318 296 288 288
   q15  558 514 512 512
   q16  723 653 646 646
   q17  1862164516271627
   q18  8371779676077607
   q19  1755149815231498
   q20  2127185818861858
   q21  5630553654075407
   q22  694 595 635 595
   Total cold run time: 73379 ms
   Total hot run time: 60013 ms
   ```
   
   


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

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

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


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



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

2024-12-19 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2556379604

   run buildall


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

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

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


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



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

2024-12-18 Thread via GitHub


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

   PR approved by anyone and no changes requested.


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

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

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


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



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

2024-12-18 Thread via GitHub


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

   PR approved by at least one committer and no changes requested.


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

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

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


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



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

2024-12-18 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.74 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 6aff26af6f5bb38e64c59b649e6f1088223309ca, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.040.04
   query3   0.240.070.06
   query4   1.630.110.11
   query5   0.420.390.41
   query6   1.140.650.65
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.570.520.48
   query10  0.540.570.56
   query11  0.150.100.10
   query12  0.140.110.10
   query13  0.610.590.60
   query14  2.872.762.89
   query15  0.890.820.81
   query16  0.380.380.38
   query17  1.011.011.04
   query18  0.220.210.21
   query19  1.871.761.96
   query20  0.010.010.01
   query21  15.36   0.580.60
   query22  2.492.412.37
   query23  16.88   1.320.82
   query24  2.930.491.22
   query25  0.240.190.19
   query26  0.270.140.13
   query27  0.050.030.04
   query28  10.83   1.131.08
   query29  12.54   3.283.22
   query30  0.240.050.05
   query31  2.880.380.38
   query32  3.250.470.47
   query33  3.063.143.12
   query34  17.28   4.494.46
   query35  4.544.514.47
   query36  0.670.480.47
   query37  0.100.060.06
   query38  0.040.030.04
   query39  0.040.020.03
   query40  0.170.130.13
   query41  0.080.020.02
   query42  0.040.020.03
   query43  0.030.030.03
   Total cold run time: 106.86 s
   Total hot run time: 32.74 s
   ```
   
   


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

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

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


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



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

2024-12-18 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196362 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 6aff26af6f5bb38e64c59b649e6f1088223309ca, 
data reload: false
   
   query1   1302962 905 905
   query2   6263235823572357
   query3   3   461747494617
   query4   32875   23306   23410   23306
   query5   4102450 470 450
   query6   284 187 186 186
   query7   4001306 298 298
   query8   284 230 222 222
   query9   9542269726842684
   query10  477 239 238 238
   query11  17978   15081   15076   15076
   query12  155 108 106 106
   query13  1570445 424 424
   query14  9540705269276927
   query15  282 197 201 197
   query16  8233486 470 470
   query17  1667607 602 602
   query18  2189322 318 318
   query19  361 173 168 168
   query20  122 115 114 114
   query21  205 107 115 107
   query22  4761456944304430
   query23  34522   33887   34215   33887
   query24  10570   243925002439
   query25  624 382 397 382
   query26  1231154 151 151
   query27  2345334 345 334
   query28  7951245024392439
   query29  825 435 423 423
   query30  227 147 147 147
   query31  1052828 808 808
   query32  103 57  57  57
   query33  762 299 289 289
   query34  1151527 567 527
   query35  900 764 781 764
   query36  1113963 956 956
   query37  139 76  74  74
   query38  4436430244034302
   query39  1491146414461446
   query40  209 97  98  97
   query41  47  42  45  42
   query42  112 107 101 101
   query43  540 492 486 486
   query44  1292843 825 825
   query45  187 174 179 174
   query46  1206768 715 715
   query47  2079195319291929
   query48  414 331 321 321
   query49  906 382 399 382
   query50  880 400 389 389
   query51  7398703271417032
   query52  112 92  92  92
   query53  282 190 185 185
   query54  1159418 405 405
   query55  84  82  84  82
   query56  268 255 274 255
   query57  1288119311561156
   query58  236 221 227 221
   query59  3456319431013101
   query60  277 252 249 249
   query61  108 105 123 105
   query62  870 690 726 690
   query63  220 183 189 183
   query64  4038693 650 650
   query65  3281324232903242
   query66  776 303 312 303
   query67  16675   15584   15529   15529
   query68  5661533 558 533
   query69  501 262 247 247
   query70  1192109711371097
   query71  490 262 245 245
   query72  7101425341484148
   query73  800 368 365 365
   query74  10008   890189908901
   query75  3733262726242624
   query76  3757116811591159
   query77  592 282 259 259
   query78  10329   947493189318
   query79  1827578 595 578
   query80  784 421 421 421
   query81  509 228 226 226
   query82  689 116 123 116
   query83  164 139 149 139
   query84  244 70  79  70
   query85  1316315 328 315
   query86  405 283 308 283
   query87  4484442245084422
   query88  3602222521882188
   query89  470 287 287 287
   query90  1967185 192 185
   query91  135 113 104 104
   query92  59  52  56  52
   query93  1988536 529 529
   query94  752 282 290 282
   query95  348 248 257 248
   query96  639 285 284 284
   query97  2877269526812681
   query98  218 195 199 195
   query99  1590129912931293
   Total cold run time: 304379 ms
   Total hot run time: 196362 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-12-18 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39461 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 6aff26af6f5bb38e64c59b649e6f1088223309ca, 
data reload: false
   
   -- Round 1 --
   q1   17603   742973167316
   q2   2061179 168 168
   q3   10777   106911781069
   q4   10547   758 735 735
   q5   7598267826312631
   q6   234 144 141 141
   q7   982 622 595 595
   q8   9247188019101880
   q9   6587636363356335
   q10  7030228423022284
   q11  468 266 258 258
   q12  425 230 221 221
   q13  17820   284929272849
   q14  240 209 217 209
   q15  564 499 496 496
   q16  691 573 595 573
   q17  968 495 522 495
   q18  7201681266326632
   q19  13441008942 942
   q20  455 190 181 181
   q21  3983313633973136
   q22  376 316 315 315
   Total cold run time: 107201 ms
   Total hot run time: 39461 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7218722872037203
   q2   328 236 232 232
   q3   2897277928412779
   q4   2085188918381838
   q5   5713562856825628
   q6   223 141 138 138
   q7   2214186018061806
   q8   3377353334993499
   q9   9021889189338891
   q10  3621353535543535
   q11  621 499 535 499
   q12  812 617 582 582
   q13  10688   306031323060
   q14  304 289 266 266
   q15  554 503 501 501
   q16  708 628 641 628
   q17  1834162016031603
   q18  8268795577187718
   q19  1735154716241547
   q20  2062183418721834
   q21  5624542955365429
   q22  675 575 610 575
   Total cold run time: 70582 ms
   Total hot run time: 59791 ms
   ```
   
   


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

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

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


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



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

2024-12-18 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2551876277

   run buildall


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

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

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


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



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

2024-12-15 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2543995659

   run buildall


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

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

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


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



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

2024-12-12 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2539139619

   run buildall


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

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

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


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



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

2024-12-02 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2512037328

   run buildall


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

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

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


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



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

2024-12-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197153 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 d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   query1   1279944 953 944
   query2   6220206520812065
   query3   10995   446442954295
   query4   67434   28660   23569   23569
   query5   4946462 455 455
   query6   403 195 194 194
   query7   5481293 302 293
   query8   310 222 218 218
   query9   8404267726632663
   query10  428 244 233 233
   query11  16974   15200   15955   15200
   query12  152 100 102 100
   query13  1431432 426 426
   query14  10548   697676616976
   query15  212 186 194 186
   query16  7168435 490 435
   query17  1298596 596 596
   query18  1839330 326 326
   query19  224 158 163 158
   query20  124 118 118 118
   query21  211 107 111 107
   query22  4986461546624615
   query23  34833   34561   34350   34350
   query24  5778252225382522
   query25  495 372 374 372
   query26  639 148 153 148
   query27  1921284 278 278
   query28  4599251224652465
   query29  659 428 421 421
   query30  208 159 158 158
   query31  1018838 851 838
   query32  68  54  58  54
   query33  459 285 285 285
   query34  919 519 519 519
   query35  905 761 772 761
   query36  1115957 959 957
   query37  120 102 72  72
   query38  4477449244224422
   query39  1518146114721461
   query40  197 95  102 95
   query41  46  42  44  42
   query42  115 97  99  97
   query43  517 512 515 512
   query44  1173801 810 801
   query45  187 174 167 167
   query46  1190774 732 732
   query47  2087193419201920
   query48  403 308 310 308
   query49  724 401 402 401
   query50  858 391 394 391
   query51  7395727870747074
   query52  96  87  91  87
   query53  250 178 172 172
   query54  502 398 389 389
   query55  77  75  75  75
   query56  254 242 243 242
   query57  1240113611401136
   query58  213 204 208 204
   query59  3275310929052905
   query60  267 266 247 247
   query61  108 103 100 100
   query62  792 669 676 669
   query63  207 183 205 183
   query64  1358668 689 668
   query65  3272319532123195
   query66  701 293 310 293
   query67  16173   15635   15798   15635
   query68  3740576 568 568
   query69  433 253 249 249
   query70  1189114611351135
   query71  355 242 243 242
   query72  6355401440174014
   query73  758 362 353 353
   query74  10246   898691608986
   query75  3395270526542654
   query76  1872107011101070
   query77  487 285 273 273
   query78  10559   951895199518
   query79  1349620 591 591
   query80  1017431 441 431
   query81  503 250 236 236
   query82  208 123 117 117
   query83  169 228 147 147
   query84  281 69  66  66
   query85  970 296 329 296
   query86  396 299 309 299
   query87  4732456645574557
   query88  3912223622072207
   query89  416 301 305 301
   query90  2005187 181 181
   query91  137 111 102 102
   query92  60  47  48  47
   query93  2336549 539 539
   query94  843 266 288 266
   query95  345 249 252 249
   query96  613 284 284 284
   query97  2886267127022671
   query98  215 193 197 193
   query99  1612131713161316
   Total cold run time: 318869 ms
   Total hot run time: 197153 ms
   ```
   
   


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

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

2024-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40054 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   -- Round 1 --
   q1   17586   743473307330
   q2   2050183 165 165
   q3   10562   108011551080
   q4   10339   794 701 701
   q5   7612271427432714
   q6   239 146 146 146
   q7   985 657 609 609
   q8   9228184919281849
   q9   6660644664906446
   q10  7047231322902290
   q11  469 262 260 260
   q12  483 231 229 229
   q13  17767   299630092996
   q14  256 211 214 211
   q15  560 527 536 527
   q16  679 594 606 594
   q17  973 571 497 497
   q18  7247673367186718
   q19  1383102210251022
   q20  477 185 185 185
   q21  4020316633033166
   q22  389 327 319 319
   Total cold run time: 107011 ms
   Total hot run time: 40054 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7278724773707247
   q2   328 225 230 225
   q3   2920280729892807
   q4   2100179618971796
   q5   5709567857005678
   q6   227 143 148 143
   q7   2280181818561818
   q8   3404354335323532
   q9   8858905190659051
   q10  3605362635623562
   q11  600 513 502 502
   q12  804 624 645 624
   q13  10925   319932003199
   q14  302 280 264 264
   q15  579 520 510 510
   q16  683 669 647 647
   q17  1859161716151615
   q18  8217775476737673
   q19  1671152915411529
   q20  2124186419111864
   q21  5734540954885409
   q22  676 570 557 557
   Total cold run time: 70883 ms
   Total hot run time: 60252 ms
   ```
   
   


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

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

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


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



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

2024-12-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.12 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   query1   0.030.020.03
   query2   0.060.030.04
   query3   0.230.070.06
   query4   1.630.100.10
   query5   0.430.390.40
   query6   1.150.650.66
   query7   0.020.010.01
   query8   0.040.030.03
   query9   0.580.510.50
   query10  0.560.550.56
   query11  0.130.100.11
   query12  0.140.120.11
   query13  0.610.590.59
   query14  2.832.842.72
   query15  0.910.820.83
   query16  0.390.380.38
   query17  1.061.061.05
   query18  0.220.210.20
   query19  1.921.841.97
   query20  0.020.010.01
   query21  15.36   0.590.58
   query22  2.512.382.37
   query23  17.16   0.850.74
   query24  3.091.591.07
   query25  0.260.130.18
   query26  0.530.140.13
   query27  0.040.040.04
   query28  9.961.111.08
   query29  12.56   3.233.18
   query30  0.250.070.07
   query31  2.870.390.39
   query32  3.260.460.47
   query33  2.983.043.05
   query34  17.01   4.454.47
   query35  4.574.444.49
   query36  0.680.480.48
   query37  0.090.060.06
   query38  0.050.040.03
   query39  0.030.020.02
   query40  0.160.130.13
   query41  0.070.020.03
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 106.52 s
   Total hot run time: 33.12 s
   ```
   
   


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

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

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


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



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

2024-11-29 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.75 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.040.03
   query3   0.230.080.07
   query4   1.620.100.10
   query5   0.420.410.40
   query6   1.160.660.65
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.570.520.51
   query10  0.550.570.56
   query11  0.140.100.11
   query12  0.140.110.12
   query13  0.600.620.59
   query14  2.842.872.81
   query15  0.890.830.82
   query16  0.380.380.39
   query17  1.061.061.05
   query18  0.220.210.21
   query19  1.871.772.07
   query20  0.010.020.01
   query21  15.37   0.600.57
   query22  2.842.591.97
   query23  16.92   0.920.89
   query24  3.500.901.52
   query25  0.140.180.10
   query26  0.470.150.14
   query27  0.040.040.05
   query28  10.09   1.121.09
   query29  12.54   3.213.24
   query30  0.250.070.07
   query31  2.870.370.38
   query32  3.280.460.48
   query33  2.953.013.07
   query34  17.17   4.434.46
   query35  4.494.504.46
   query36  0.670.500.48
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.020.02
   query40  0.170.130.13
   query41  0.070.020.02
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 106.92 s
   Total hot run time: 32.75 s
   ```
   
   


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

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

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


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



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

2024-11-29 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197418 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 d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   query1   1269939 926 926
   query2   6209205720522052
   query3   10993   437043764370
   query4   67188   28975   23585   23585
   query5   4951477 470 470
   query6   421 179 168 168
   query7   5521326 296 296
   query8   296 216 215 215
   query9   8899269527052695
   query10  427 250 250 250
   query11  17195   15366   15929   15366
   query12  162 102 106 102
   query13  1497428 442 428
   query14  9958782669096909
   query15  224 187 202 187
   query16  6973468 503 468
   query17  1089583 587 583
   query18  1796320 312 312
   query19  206 162 171 162
   query20  132 117 119 117
   query21  213 105 111 105
   query22  4735448345784483
   query23  34954   35005   34551   34551
   query24  5415257825742574
   query25  489 384 396 384
   query26  660 151 147 147
   query27  2066286 291 286
   query28  4477250424622462
   query29  655 419 413 413
   query30  217 147 154 147
   query31  1037829 833 829
   query32  64  54  55  54
   query33  431 284 309 284
   query34  919 536 528 528
   query35  881 770 749 749
   query36  1102980 1005980
   query37  129 78  74  74
   query38  4527437243714371
   query39  1518150714801480
   query40  201 97  103 97
   query41  46  42  42  42
   query42  111 101 104 101
   query43  537 503 500 500
   query44  1206826 815 815
   query45  193 167 170 167
   query46  1164744 765 744
   query47  2046193318991899
   query48  421 321 319 319
   query49  740 398 405 398
   query50  858 399 401 399
   query51  7418724071957195
   query52  96  88  87  87
   query53  254 188 181 181
   query54  512 393 388 388
   query55  75  75  77  75
   query56  246 250 241 241
   query57  1263112711001100
   query58  205 200 205 200
   query59  3300316529832983
   query60  259 236 242 236
   query61  105 106 102 102
   query62  765 677 666 666
   query63  220 187 195 187
   query64  1401645 635 635
   query65  3263324532473245
   query66  624 294 293 293
   query67  15914   15788   15627   15627
   query68  4009572 548 548
   query69  430 258 252 252
   query70  1212108011411080
   query71  349 250 244 244
   query72  6462405339863986
   query73  774 356 365 356
   query74  10052   918791229122
   query75  3398266326622662
   query76  1842101411041014
   query77  460 277 258 258
   query78  10471   942194059405
   query79  1815608 609 608
   query80  1445423 441 423
   query81  513 246 228 228
   query82  1328122 124 122
   query83  263 140 144 140
   query84  280 77  69  69
   query85  1019301 290 290
   query86  430 300 300 300
   query87  4757446945054469
   query88  3464223621812181
   query89  475 301 300 300
   query90  1839185 187 185
   query91  141 100 102 100
   query92  65  48  50  48
   query93  2172541 541 541
   query94  762 303 294 294
   query95  340 251 264 251
   query96  610 284 284 284
   query97  2922269426792679
   query98  218 188 191 188
   query99  1640134613071307
   Total cold run time: 319295 ms
   Total hot run time: 197418 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] [Enhancement] (nereids)implement showStorageVaultCommand in nereids [doris]

2024-11-29 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39929 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d6da5390a125cef6369aa126a2af73cf3b3f10bc, 
data reload: false
   
   -- Round 1 --
   q1   17585   755473007300
   q2   2043174 163 163
   q3   10722   107911381079
   q4   10562   795 723 723
   q5   7621271327182713
   q6   240 147 148 147
   q7   981 613 608 608
   q8   9239184119131841
   q9   6697649664066406
   q10  6991225423172254
   q11  457 265 255 255
   q12  418 229 222 222
   q13  17786   300730083007
   q14  248 207 233 207
   q15  572 530 509 509
   q16  670 583 574 574
   q17  971 564 522 522
   q18  7278669766766676
   q19  135210251025
   q20  481 182 181 181
   q21  4026320032313200
   q22  388 317 319 317
   Total cold run time: 107328 ms
   Total hot run time: 39929 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7291727572587258
   q2   327 230 235 230
   q3   2879277229092772
   q4   2092177918471779
   q5   5671562756445627
   q6   225 144 140 140
   q7   2233181318621813
   q8   3359353034973497
   q9   8948903588858885
   q10  3605356835603560
   q11  598 514 511 511
   q12  821 604 608 604
   q13  13251   321332483213
   q14  302 270 280 270
   q15  598 528 523 523
   q16  698 653 632 632
   q17  1837160915981598
   q18  8115785276057605
   q19  1698144915601449
   q20  2130186218411841
   q21  5488547153685368
   q22  630 549 608 549
   Total cold run time: 72796 ms
   Total hot run time: 59724 ms
   ```
   
   


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

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

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


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



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

2024-11-29 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2508847157

   run buildall


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

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

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


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



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

2024-11-29 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.37 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 45350db38363998b1b778cfa11fabdb5b07d8853, 
data reload: false
   
   query1   0.030.030.02
   query2   0.060.040.03
   query3   0.230.070.07
   query4   1.610.100.10
   query5   0.420.420.42
   query6   1.170.650.66
   query7   0.020.020.02
   query8   0.030.030.03
   query9   0.590.500.50
   query10  0.550.540.57
   query11  0.130.100.11
   query12  0.140.120.11
   query13  0.610.610.59
   query14  2.812.722.70
   query15  0.890.830.83
   query16  0.390.370.39
   query17  0.991.011.04
   query18  0.220.210.21
   query19  1.871.881.94
   query20  0.010.010.01
   query21  15.37   0.590.59
   query22  2.861.941.60
   query23  17.22   1.030.81
   query24  3.220.951.14
   query25  0.130.050.22
   query26  0.600.140.14
   query27  0.050.050.05
   query28  10.48   1.111.08
   query29  12.54   3.253.25
   query30  0.250.070.06
   query31  2.870.380.37
   query32  3.270.460.46
   query33  2.983.063.02
   query34  16.89   4.464.47
   query35  4.524.594.50
   query36  0.670.490.49
   query37  0.090.060.07
   query38  0.050.030.03
   query39  0.040.020.03
   query40  0.170.120.13
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.030.030.04
   Total cold run time: 107.19 s
   Total hot run time: 32.37 s
   ```
   
   


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

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

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


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



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

2024-11-29 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 191348 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 45350db38363998b1b778cfa11fabdb5b07d8853, 
data reload: false
   
   query1   971 385 384 384
   query2   6553206120932061
   query3   6720207 208 207
   query4   33878   23553   23557   23553
   query5   4330478 447 447
   query6   277 181 184 181
   query7   4635296 317 296
   query8   289 226 218 218
   query9   9588272927202720
   query10  465 255 242 242
   query11  18654   15233   15472   15233
   query12  152 109 107 107
   query13  1647417 416 416
   query14  10001   737176507371
   query15  299 183 183 183
   query16  8201464 457 457
   query17  1815589 584 584
   query18  2170305 296 296
   query19  369 156 152 152
   query20  169 111 109 109
   query21  206 99  100 99
   query22  4525447342734273
   query23  34818   34250   34065   34065
   query24  3   238625332386
   query25  657 378 381 378
   query26  1828150 153 150
   query27  2742284 276 276
   query28  8055245524252425
   query29  1021400 405 400
   query30  296 159 155 155
   query31  1037766 820 766
   query32  113 53  57  53
   query33  764 288 288 288
   query34  956 544 534 534
   query35  970 743 750 743
   query36  1120930 960 930
   query37  195 71  73  71
   query38  4320415442334154
   query39  1461142514151415
   query40  284 103 101 101
   query41  48  45  44  44
   query42  106 99  98  98
   query43  541 515 499 499
   query44  1203806 813 806
   query45  180 168 171 168
   query46  1161730 729 729
   query47  1946184018221822
   query48  393 311 327 311
   query49  1280382 381 381
   query50  805 385 384 384
   query51  7341708471237084
   query52  97  91  88  88
   query53  270 189 183 183
   query54  1169395 401 395
   query55  83  73  74  73
   query56  275 239 239 239
   query57  1259111811151115
   query58  226 208 217 208
   query59  3189300032313000
   query60  268 242 239 239
   query61  109 102 109 102
   query62  883 688 665 665
   query63  225 185 189 185
   query64  4958653 635 635
   query65  3302319432263194
   query66  1478317 306 306
   query67  15953   15675   15643   15643
   query68  5163550 545 545
   query69  409 250 243 243
   query70  1170111811151115
   query71  314 299 249 249
   query72  6517406841434068
   query73  753 357 373 357
   query74  9966888590038885
   query75  3388267726802677
   query76  30731014995 995
   query77  556 281 277 277
   query78  10499   943993909390
   query79  2468604 615 604
   query80  1065429 421 421
   query81  531 234 241 234
   query82  664 119 110 110
   query83  240 154 144 144
   query84  228 70  68  68
   query85  1929298 308 298
   query86  499 297 288 288
   query87  4738456245804562
   query88  4060223221542154
   query89  415 292 308 292
   query90  2207190 191 190
   query91  142 106 114 106
   query92  67  94  50  50
   query93  1843543 542 542
   query94  1067291 292 291
   query95  365 256 250 250
   query96  609 291 277 277
   query97  2822268226702670
   query98  220 195 202 195
   query99  1552136013261326
   Total cold run time: 305951 ms
   Total hot run time: 191348 ms
   ```
   
   


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

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

2024-11-29 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40105 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 45350db38363998b1b778cfa11fabdb5b07d8853, 
data reload: false
   
   -- Round 1 --
   q1   17810   747672757275
   q2   2046178 178 178
   q3   10612   113011651130
   q4   10250   723 753 723
   q5   7615270826192619
   q6   237 144 145 144
   q7   984 621 619 619
   q8   9244184918971849
   q9   6636645364626453
   q10  6989228323342283
   q11  454 261 261 261
   q12  414 221 220 220
   q13  17775   314730423042
   q14  242 208 218 208
   q15  570 528 513 513
   q16  641 608 586 586
   q17  953 523 563 523
   q18  7432665367796653
   q19  1337103210941032
   q20  475 189 192 189
   q21  4117339932863286
   q22  393 319 319 319
   Total cold run time: 107226 ms
   Total hot run time: 40105 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7273728572557255
   q2   323 226 226 226
   q3   2865282930962829
   q4   2128181917721772
   q5   5557569756505650
   q6   224 144 138 138
   q7   2185178518201785
   q8   3343351034563456
   q9   8952895289188918
   q10  3580357235113511
   q11  600 536 498 498
   q12  821 629 630 629
   q13  11106   320032573200
   q14  297 273 271 271
   q15  578 505 526 505
   q16  665 619 649 619
   q17  1793158015531553
   q18  7976748574997485
   q19  1639143215591432
   q20  2041181418091809
   q21  5457534352935293
   q22  649 568 554 554
   Total cold run time: 70052 ms
   Total hot run time: 59388 ms
   ```
   
   


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

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

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


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



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

2024-11-29 Thread via GitHub


msridhar78 commented on PR #44805:
URL: https://github.com/apache/doris/pull/44805#issuecomment-2508160339

   run buildall


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

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

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


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



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

2024-11-29 Thread via GitHub


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

   
   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