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

2024-12-01 Thread via GitHub


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


-- 
This is an automated 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 showCollationCommand in nereids [doris]

2024-12-01 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-12-01 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-28 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.95 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit b5e0a29fddab0f74d1988578119e29fc1e3e7961, 
data reload: false
   
   query1   0.030.040.03
   query2   0.060.040.03
   query3   0.230.080.06
   query4   1.630.100.11
   query5   0.440.410.42
   query6   1.150.650.65
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.560.530.49
   query10  0.560.560.56
   query11  0.140.100.11
   query12  0.150.110.11
   query13  0.610.590.61
   query14  2.742.762.87
   query15  0.910.840.83
   query16  0.390.380.38
   query17  1.041.101.07
   query18  0.220.200.21
   query19  1.881.761.96
   query20  0.010.010.01
   query21  15.35   0.580.59
   query22  2.802.081.94
   query23  16.98   1.160.89
   query24  3.181.051.24
   query25  0.240.060.07
   query26  0.600.130.13
   query27  0.050.050.04
   query28  10.49   1.101.08
   query29  12.52   3.243.22
   query30  0.240.060.07
   query31  2.880.380.37
   query32  3.300.460.46
   query33  2.993.153.13
   query34  17.01   4.444.45
   query35  4.504.594.53
   query36  0.650.490.49
   query37  0.090.060.06
   query38  0.040.040.03
   query39  0.040.020.03
   query40  0.160.110.13
   query41  0.070.020.03
   query42  0.030.020.02
   query43  0.040.030.04
   Total cold run time: 107.06 s
   Total hot run time: 32.95 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 showCollationCommand in nereids [doris]

2024-11-28 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197102 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 b5e0a29fddab0f74d1988578119e29fc1e3e7961, 
data reload: false
   
   query1   1284957 1002957
   query2   6234209620362036
   query3   10930   406640744066
   query4   67454   26913   23535   23535
   query5   4970447 470 447
   query6   402 187 184 184
   query7   5542299 299 299
   query8   340 233 253 233
   query9   8566272027302720
   query10  423 249 250 249
   query11  17181   15302   15859   15302
   query12  153 102 105 102
   query13  1470441 442 441
   query14  10519   726969216921
   query15  210 199 194 194
   query16  7488518 473 473
   query17  1143592 586 586
   query18  1936339 323 323
   query19  209 163 165 163
   query20  119 121 114 114
   query21  228 102 109 102
   query22  4676433245874332
   query23  35126   34627   34658   34627
   query24  5531250725292507
   query25  501 395 396 395
   query26  657 156 152 152
   query27  1888289 300 289
   query28  4622251024992499
   query29  675 438 422 422
   query30  219 150 157 150
   query31  992 826 821 821
   query32  71  54  60  54
   query33  407 287 291 287
   query34  927 525 509 509
   query35  877 751 765 751
   query36  1093955 950 950
   query37  125 83  76  76
   query38  4376443445224434
   query39  1526148914511451
   query40  204 99  101 99
   query41  47  44  45  44
   query42  114 104 103 103
   query43  536 504 498 498
   query44  1211830 843 830
   query45  192 171 165 165
   query46  1136716 711 711
   query47  2031194419461944
   query48  434 327 330 327
   query49  717 418 395 395
   query50  832 399 394 394
   query51  7449724170617061
   query52  101 86  87  86
   query53  250 176 178 176
   query54  510 397 384 384
   query55  83  77  78  77
   query56  261 234 233 233
   query57  1315119411561156
   query58  239 223 209 209
   query59  3234321929182918
   query60  273 254 250 250
   query61  116 105 110 105
   query62  814 665 672 665
   query63  216 185 191 185
   query64  1417679 632 632
   query65  3305321831953195
   query66  683 306 300 300
   query67  16077   15858   15696   15696
   query68  4017571 550 550
   query69  422 264 254 254
   query70  1248114911421142
   query71  316 256 247 247
   query72  6422414440254025
   query73  762 351 434 351
   query74  9412908590909085
   query75  3337267126722671
   query76  1900104011071040
   query77  484 266 282 266
   query78  10568   953594029402
   query79  2101591 602 591
   query80  1387421 439 421
   query81  517 239 227 227
   query82  1294118 126 118
   query83  272 149 151 149
   query84  283 74  70  70
   query85  1022338 309 309
   query86  416 307 269 269
   query87  4741471146114611
   query88  3650222721922192
   query89  422 309 286 286
   query90  1967187 192 187
   query91  131 101 103 101
   query92  65  49  52  49
   query93  2912547 545 545
   query94  809 307 287 287
   query95  349 242 249 242
   query96  635 272 292 272
   query97  2845268426612661
   query98  220 193 190 190
   query99  1636132013011301
   Total cold run time: 321449 ms
   Total hot run time: 197102 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 showCollationCommand in nereids [doris]

2024-11-27 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39527 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit b5e0a29fddab0f74d1988578119e29fc1e3e7961, 
data reload: false
   
   -- Round 1 --
   q1   17594   752772607260
   q2   2046186 169 169
   q3   10631   105811481058
   q4   10535   739 692 692
   q5   7603270427652704
   q6   242 147 148 147
   q7   981 621 602 602
   q8   9218183219211832
   q9   6406639763836383
   q10  7046227223202272
   q11  470 245 257 245
   q12  426 222 222 222
   q13  17786   301130183011
   q14  251 206 209 206
   q15  573 531 520 520
   q16  651 575 577 575
   q17  966 571 512 512
   q18  7226675166786678
   q19  13421031855 855
   q20  458 187 183 183
   q21  3987310031063100
   q22  390 314 301 301
   Total cold run time: 106828 ms
   Total hot run time: 39527 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7246726072297229
   q2   332 227 226 226
   q3   2885277828862778
   q4   2006180417631763
   q5   5735565956635659
   q6   224 142 143 142
   q7   2234179818061798
   q8   3381358735403540
   q9   8902881688528816
   q10  3620357235143514
   q11  602 504 537 504
   q12  823 611 608 608
   q13  10152   332632603260
   q14  311 283 269 269
   q15  573 527 513 513
   q16  703 645 654 645
   q17  1855166216251625
   q18  8353779677767776
   q19  1723154415971544
   q20  2123190818901890
   q21  5526535552395239
   q22  657 593 589 589
   Total cold run time: 69966 ms
   Total hot run time: 59927 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 showCollationCommand in nereids [doris]

2024-11-27 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-27 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.48 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1479c870f6df8b0aad06f3e7c7cf95fa660cb033, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.030.03
   query3   0.230.080.07
   query4   1.650.100.10
   query5   0.420.430.39
   query6   1.160.680.68
   query7   0.020.010.02
   query8   0.040.030.03
   query9   0.570.510.50
   query10  0.540.550.57
   query11  0.150.110.11
   query12  0.130.120.11
   query13  0.610.600.60
   query14  2.852.882.82
   query15  0.900.830.83
   query16  0.390.380.37
   query17  1.041.051.05
   query18  0.220.210.21
   query19  1.931.802.00
   query20  0.010.010.02
   query21  15.36   0.630.61
   query22  2.672.702.13
   query23  17.02   0.830.92
   query24  3.221.631.27
   query25  0.310.100.19
   query26  0.470.140.14
   query27  0.040.050.04
   query28  9.701.091.06
   query29  12.56   3.233.23
   query30  0.250.060.06
   query31  2.910.400.38
   query32  3.250.470.47
   query33  2.973.093.09
   query34  17.03   4.484.48
   query35  4.544.504.48
   query36  0.670.490.49
   query37  0.090.060.07
   query38  0.050.040.04
   query39  0.030.030.02
   query40  0.160.130.14
   query41  0.080.030.02
   query42  0.040.020.02
   query43  0.030.030.03
   Total cold run time: 106.41 s
   Total hot run time: 33.48 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 showCollationCommand in nereids [doris]

2024-11-27 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197746 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 1479c870f6df8b0aad06f3e7c7cf95fa660cb033, 
data reload: false
   
   query1   12751041974 974
   query2   6270205920142014
   query3   10948   428141004100
   query4   67608   28314   23771   23771
   query5   4903493 457 457
   query6   412 187 184 184
   query7   5633313 296 296
   query8   314 236 235 235
   query9   8986276927572757
   query10  439 263 252 252
   query11  17551   15408   15828   15408
   query12  163 98  108 98
   query13  1552440 398 398
   query14  10851   722569266926
   query15  218 187 183 183
   query16  7116437 475 437
   query17  1404563 572 563
   query18  1826302 307 302
   query19  211 157 162 157
   query20  120 113 119 113
   query21  224 107 108 107
   query22  4804458144644464
   query23  35215   34231   34623   34231
   query24  5429263625612561
   query25  511 392 394 392
   query26  639 154 153 153
   query27  1868287 291 287
   query28  4839250525012501
   query29  665 429 440 429
   query30  212 152 149 149
   query31  1024819 870 819
   query32  64  56  54  54
   query33  405 306 341 306
   query34  930 529 559 529
   query35  901 759 720 720
   query36  1123993 968 968
   query37  123 71  76  71
   query38  4672446944754469
   query39  1553148514951485
   query40  204 101 105 101
   query41  48  44  44  44
   query42  121 99  104 99
   query43  572 498 513 498
   query44  1170821 820 820
   query45  188 177 165 165
   query46  1150721 720 720
   query47  2056193119581931
   query48  446 335 335 335
   query49  718 400 396 396
   query50  845 412 434 412
   query51  7345709871397098
   query52  111 93  88  88
   query53  257 185 183 183
   query54  521 393 397 393
   query55  76  77  79  77
   query56  250 246 241 241
   query57  1273125111761176
   query58  212 217 237 217
   query59  3241309229962996
   query60  270 240 258 240
   query61  111 108 107 107
   query62  781 669 673 669
   query63  217 196 193 193
   query64  1376671 638 638
   query65  3289322532093209
   query66  686 301 301 301
   query67  16094   15689   15679   15679
   query68  4013588 558 558
   query69  423 257 261 257
   query70  1253116111461146
   query71  366 256 250 250
   query72  6421407140914071
   query73  769 356 359 356
   query74  10144   917991239123
   query75  3411269326762676
   query76  1820112711601127
   query77  476 273 278 273
   query78  10454   950593559355
   query79  1622601 598 598
   query80  883 433 436 433
   query81  512 226 226 226
   query82  1287124 121 121
   query83  216 143 158 143
   query84  283 73  68  68
   query85  897 322 331 322
   query86  345 284 293 284
   query87  4681459447774594
   query88  3865224422172217
   query89  428 298 289 289
   query90  2008192 191 191
   query91  140 105 110 105
   query92  65  55  51  51
   query93  2031535 550 535
   query94  775 307 298 298
   query95  353 255 253 253
   query96  621 282 274 274
   query97  2919268726862686
   query98  224 193 193 193
   query99  1609133313271327
   Total cold run time: 321943 ms
   Total hot run time: 197746 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 showCollationCommand in nereids [doris]

2024-11-27 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39800 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1479c870f6df8b0aad06f3e7c7cf95fa660cb033, 
data reload: false
   
   -- Round 1 --
   q1   17584   742272557255
   q2   2043189 165 165
   q3   10593   107012351070
   q4   10462   786 690 690
   q5   7629276926242624
   q6   237 150 146 146
   q7   969 619 611 611
   q8   9255186019071860
   q9   6558640864146408
   q10  7048235523532353
   q11  464 273 255 255
   q12  408 219 218 218
   q13  17764   305329872987
   q14  246 209 211 209
   q15  591 550 520 520
   q16  662 583 584 583
   q17  980 547 551 547
   q18  7438668767266687
   q19  13441054978 978
   q20  457 183 191 183
   q21  3944320131423142
   q22  382 316 309 309
   Total cold run time: 107058 ms
   Total hot run time: 39800 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7301724672507246
   q2   324 235 233 233
   q3   2877284030072840
   q4   2038176317871763
   q5   5714569956245624
   q6   230 147 144 144
   q7   2308184618281828
   q8   3416357335023502
   q9   8818888989578889
   q10  3617358335643564
   q11  604 509 515 509
   q12  839 597 618 597
   q13  12441   329832463246
   q14  300 283 291 283
   q15  580 521 517 517
   q16  714 631 638 631
   q17  1852164416161616
   q18  8420764576437643
   q19  1864150815961508
   q20  2118188219091882
   q21  5561531753905317
   q22  634 556 552 552
   Total cold run time: 72570 ms
   Total hot run time: 59934 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 showCollationCommand in nereids [doris]

2024-11-26 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.35 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   query1   0.040.030.03
   query2   0.070.030.04
   query3   0.240.070.06
   query4   1.620.100.10
   query5   0.440.420.42
   query6   1.160.670.66
   query7   0.010.010.02
   query8   0.040.030.03
   query9   0.570.540.49
   query10  0.550.570.56
   query11  0.140.100.11
   query12  0.140.120.10
   query13  0.620.600.62
   query14  2.832.772.78
   query15  0.910.820.82
   query16  0.380.410.40
   query17  1.081.061.05
   query18  0.230.220.21
   query19  1.981.802.00
   query20  0.020.010.01
   query21  15.36   0.580.59
   query22  2.942.181.52
   query23  16.97   1.010.79
   query24  3.180.961.49
   query25  0.340.060.11
   query26  0.460.140.13
   query27  0.040.040.03
   query28  10.40   1.121.07
   query29  12.54   3.383.30
   query30  0.250.080.07
   query31  2.840.380.37
   query32  3.280.470.47
   query33  2.993.043.02
   query34  16.96   4.494.47
   query35  4.534.464.51
   query36  0.660.510.48
   query37  0.080.060.06
   query38  0.050.040.04
   query39  0.030.020.03
   query40  0.160.130.13
   query41  0.080.020.03
   query42  0.040.020.02
   query43  0.030.030.03
   Total cold run time: 107.28 s
   Total hot run time: 32.35 s
   ```
   
   


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

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

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


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



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

2024-11-20 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 198045 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 bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   query1   1245953 955 953
   query2   6233215321072107
   query3   10819   413039063906
   query4   67621   29619   23458   23458
   query5   5035466 446 446
   query6   437 184 187 184
   query7   5635314 305 305
   query8   327 235 242 235
   query9   9045267926762676
   query10  458 253 258 253
   query11  17625   15382   15843   15382
   query12  164 111 105 105
   query13  1604438 436 436
   query14  10032   774272437243
   query15  225 180 187 180
   query16  7365500 457 457
   query17  1073576 575 575
   query18  1983297 287 287
   query19  196 163 160 160
   query20  128 116 118 116
   query21  203 106 104 104
   query22  4916463946774639
   query23  36003   35081   34704   34704
   query24  5445257524902490
   query25  500 405 430 405
   query26  666 156 152 152
   query27  1810283 291 283
   query28  4445249524812481
   query29  679 435 457 435
   query30  215 160 152 152
   query31  1013803 842 803
   query32  64  53  58  53
   query33  416 292 272 272
   query34  948 521 520 520
   query35  844 766 743 743
   query36  1088961 983 961
   query37  123 77  83  77
   query38  4536448243934393
   query39  1517148214951482
   query40  198 106 104 104
   query41  46  46  42  42
   query42  116 105 107 105
   query43  544 511 514 511
   query44  1183835 843 835
   query45  188 178 167 167
   query46  1182715 713 713
   query47  1995195019501950
   query48  425 326 335 326
   query49  745 386 404 386
   query50  859 396 419 396
   query51  7317736372347234
   query52  100 88  86  86
   query53  266 184 181 181
   query54  503 421 389 389
   query55  78  76  75  75
   query56  256 234 229 229
   query57  1289116411691164
   query58  231 247 222 222
   query59  3347309129242924
   query60  274 260 249 249
   query61  119 123 123 123
   query62  849 693 678 678
   query63  214 190 202 190
   query64  1363682 647 647
   query65  3331322032203220
   query66  630 307 304 304
   query67  15995   15914   15734   15734
   query68  4045561 562 561
   query69  416 261 259 259
   query70  1191110711601107
   query71  317 257 262 257
   query72  6272404941054049
   query73  777 361 365 361
   query74  10083   909289718971
   query75  3422268627032686
   query76  1798110110911091
   query77  492 283 266 266
   query78  10559   946494229422
   query79  1653599 607 599
   query80  896 443 433 433
   query81  503 225 229 225
   query82  1311126 118 118
   query83  250 149 151 149
   query84  282 80  76  76
   query85  920 309 307 307
   query86  342 311 289 289
   query87  4699467745674567
   query88  3772231922372237
   query89  419 296 298 296
   query90  1903194 190 190
   query91  142 107 107 107
   query92  69  50  51  50
   query93  1946543 544 543
   query94  739 302 275 275
   query95  356 251 256 251
   query96  642 275 277 275
   query97  2901272527172717
   query98  213 217 224 217
   query99  1896129713121297
   Total cold run time: 321550 ms
   Total hot run time: 198045 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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40046 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   -- Round 1 --
   q1   17596   754272707270
   q2   2040170 167 167
   q3   10771   107511971075
   q4   10508   771 698 698
   q5   7622277426942694
   q6   240 153 145 145
   q7   965 639 605 605
   q8   9244185919841859
   q9   6513648565316485
   q10  7077229623372296
   q11  470 268 254 254
   q12  411 220 216 216
   q13  17762   303330383033
   q14  248 236 225 225
   q15  574 532 519 519
   q16  685 609 602 602
   q17  998 611 589 589
   q18  7335664566946645
   q19  1338101110421011
   q20  477 182 183 182
   q21  4060316233193162
   q22  395 324 314 314
   Total cold run time: 107329 ms
   Total hot run time: 40046 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7272726573347265
   q2   327 233 233 233
   q3   2967286629262866
   q4   2064189618871887
   q5   5659570956855685
   q6   230 142 137 137
   q7   2224184418291829
   q8   3433357935703570
   q9   8857900789798979
   q10  3601358435763576
   q11  613 506 504 504
   q12  844 641 632 632
   q13  11715   325032623250
   q14  316 272 277 272
   q15  567 510 530 510
   q16  687 618 638 618
   q17  1857166916061606
   q18  8437782275707570
   q19  1761145215351452
   q20  2148192418721872
   q21  5639550354605460
   q22  646 568 590 568
   Total cold run time: 71864 ms
   Total hot run time: 60341 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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40011 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   -- Round 1 --
   q1   17591   760673687368
   q2   2073174 164 164
   q3   10584   110111181101
   q4   10526   736 842 736
   q5   7605272727272727
   q6   240 150 148 148
   q7   986 635 607 607
   q8   9239182619131826
   q9   6494642064156415
   q10  6996227423472274
   q11  471 273 266 266
   q12  416 217 224 217
   q13  17770   303430293029
   q14  255 216 220 216
   q15  579 548 521 521
   q16  668 605 575 575
   q17  986 514 583 514
   q18  7199675867026702
   q19  1342951 917 917
   q20  454 190 181 181
   q21  4113325631923192
   q22  381 320 315 315
   Total cold run time: 106968 ms
   Total hot run time: 40011 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7322731972907290
   q2   323 232 233 232
   q3   2962284330112843
   q4   2063181418261814
   q5   5700571556715671
   q6   241 148 146 146
   q7   2288190318341834
   q8   3434353935393539
   q9   8872894689698946
   q10  3607360435683568
   q11  615 524 511 511
   q12  821 628 608 608
   q13  12000   331133303311
   q14  316 273 295 273
   q15  586 529 524 524
   q16  682 687 641 641
   q17  1859164216001600
   q18  8269789074867486
   q19  1710156315751563
   q20  2115190119281901
   q21  5709538655085386
   q22  649 562 573 562
   Total cold run time: 72143 ms
   Total hot run time: 60249 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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.93 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.030.03
   query3   0.230.080.07
   query4   1.610.110.10
   query5   0.450.420.43
   query6   1.180.660.64
   query7   0.020.010.02
   query8   0.040.030.03
   query9   0.570.520.51
   query10  0.560.560.55
   query11  0.150.100.10
   query12  0.140.110.11
   query13  0.600.600.61
   query14  2.842.872.73
   query15  0.910.840.83
   query16  0.370.370.37
   query17  1.021.031.00
   query18  0.200.200.20
   query19  1.881.892.01
   query20  0.020.010.01
   query21  15.36   0.600.58
   query22  2.811.851.58
   query23  17.03   0.870.98
   query24  3.211.340.50
   query25  0.160.210.09
   query26  0.460.140.13
   query27  0.040.050.04
   query28  10.73   1.101.07
   query29  12.56   3.203.17
   query30  0.250.060.05
   query31  2.880.380.38
   query32  3.250.470.47
   query33  2.963.033.08
   query34  17.11   4.484.52
   query35  4.514.484.50
   query36  0.630.520.48
   query37  0.090.070.06
   query38  0.040.040.03
   query39  0.040.030.02
   query40  0.150.130.12
   query41  0.070.020.03
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 107.3 s
   Total hot run time: 31.93 s
   ```
   
   


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

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

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


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



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

2024-11-20 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196882 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 bf9304d78c66766469c962ecab6610a6feef1a4f, 
data reload: false
   
   query1   1243958 919 919
   query2   6593219621302130
   query3   10938   413239733973
   query4   67883   28600   23754   23754
   query5   4954491 452 452
   query6   402 190 180 180
   query7   5499306 299 299
   query8   315 225 229 225
   query9   8523269826742674
   query10  436 271 254 254
   query11  17341   15386   15941   15386
   query12  159 110 108 108
   query13  1449443 430 430
   query14  10869   766577417665
   query15  218 196 206 196
   query16  7076435 516 435
   query17  1049555 554 554
   query18  1788295 293 293
   query19  195 152 141 141
   query20  113 140 108 108
   query21  205 101 103 101
   query22  4687423744284237
   query23  34732   34236   34249   34236
   query24  5344233824042338
   query25  475 392 372 372
   query26  633 152 149 149
   query27  1660279 291 279
   query28  4319242924242424
   query29  659 414 407 407
   query30  220 146 146 146
   query31  988 809 811 809
   query32  65  56  57  56
   query33  408 288 267 267
   query34  914 502 509 502
   query35  852 709 725 709
   query36  1069945 964 945
   query37  118 77  74  74
   query38  4299423341794179
   query39  1488144914221422
   query40  194 98  94  94
   query41  44  43  43  43
   query42  107 101 96  96
   query43  539 510 504 504
   query44  1148804 815 804
   query45  181 164 169 164
   query46  1124699 698 698
   query47  1949185118481848
   query48  406 324 319 319
   query49  705 380 379 379
   query50  803 387 405 387
   query51  7242712270857085
   query52  107 88  91  88
   query53  258 177 178 177
   query54  517 409 402 402
   query55  80  77  74  74
   query56  250 256 237 237
   query57  1271119011601160
   query58  225 220 210 210
   query59  3379329431583158
   query60  278 261 246 246
   query61  122 108 106 106
   query62  801 671 673 671
   query63  217 184 184 184
   query64  1367668 667 667
   query65  3280321832493218
   query66  755 306 301 301
   query67  16045   15641   15727   15641
   query68  3786576 545 545
   query69  433 258 265 258
   query70  1193115210901090
   query71  345 253 254 253
   query72  6288410242454102
   query73  765 352 359 352
   query74  10261   901991309019
   query75  3405269926642664
   query76  1985967 1089967
   query77  455 279 273 273
   query78  10664   951494359435
   query79  2027605 607 605
   query80  1426413 434 413
   query81  523 245 233 233
   query82  1290122 119 119
   query83  277 161 160 160
   query84  281 71  69  69
   query85  1027307 300 300
   query86  415 297 306 297
   query87  4693469246364636
   query88  3835220021562156
   query89  424 289 291 289
   query90  1985189 187 187
   query91  140 99  103 99
   query92  69  49  54  49
   query93  2981536 551 536
   query94  833 303 297 297
   query95  351 250 247 247
   query96  645 318 282 282
   query97  2934265327162653
   query98  211 208 204 204
   query99  1605130513041304
   Total cold run time: 321124 ms
   Total hot run time: 196882 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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-20 Thread via GitHub


msridhar78 commented on code in PR #43157:
URL: https://github.com/apache/doris/pull/43157#discussion_r1850404063


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowCollationCommand.java:
##
@@ -0,0 +1,96 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.Lists;
+
+import java.util.List;
+
+/**
+ * Represents the command for SHOW COLLATION
+ */
+public class ShowCollationCommand extends Command implements NoForward {

Review Comment:
   done - pls review



-- 
This is an automated 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 showCollationCommand in nereids [doris]

2024-11-14 Thread via GitHub


starocean999 commented on PR #43157:
URL: https://github.com/apache/doris/pull/43157#issuecomment-2477884970

   please add test case


-- 
This is an automated 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 showCollationCommand in nereids [doris]

2024-11-14 Thread via GitHub


starocean999 commented on code in PR #43157:
URL: https://github.com/apache/doris/pull/43157#discussion_r1843145082


##
fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java:
##
@@ -3999,4 +4001,17 @@ public SetUserPropertiesCommand 
visitSetUserProperties(SetUserPropertiesContext
 public SetDefaultStorageVaultCommand 
visitSetDefaultStorageVault(SetDefaultStorageVaultContext ctx) {
 return new 
SetDefaultStorageVaultCommand(stripQuotes(ctx.identifier().getText()));
 }
+
+@Override
+public LogicalPlan visitShowCollation(ShowCollationContext ctx) {
+String wild = null;
+if (ctx.wildWhere() != null) {
+if (ctx.wildWhere().LIKE() != null) {
+wild = ctx.wildWhere().STRING_LITERAL().getText().replace("'", 
"").trim();

Review Comment:
   ```suggestion
   wild = 
stripQuotes(ctx.wildWhere().STRING_LITERAL().getText());
   ```



-- 
This is an automated 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 showCollationCommand in nereids [doris]

2024-11-14 Thread via GitHub


starocean999 commented on code in PR #43157:
URL: https://github.com/apache/doris/pull/43157#discussion_r1843144110


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowCollationCommand.java:
##
@@ -0,0 +1,96 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.Lists;
+
+import java.util.List;
+
+/**
+ * Represents the command for SHOW COLLATION
+ */
+public class ShowCollationCommand extends Command implements NoForward {

Review Comment:
   ```suggestion
   public class ShowCollationCommand extends ShowCommand {
   ```



-- 
This is an automated 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 showCollationCommand in nereids [doris]

2024-11-03 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.19 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 6c745db865ee559454cdb0d509af01d51dacc421, 
data reload: false
   
   query1   0.040.020.03
   query2   0.070.030.03
   query3   0.240.060.06
   query4   1.640.100.10
   query5   0.410.390.40
   query6   1.190.650.65
   query7   0.020.020.02
   query8   0.030.030.03
   query9   0.550.500.49
   query10  0.550.540.57
   query11  0.140.100.11
   query12  0.150.110.10
   query13  0.600.590.59
   query14  2.832.732.71
   query15  0.900.830.83
   query16  0.390.370.35
   query17  1.061.061.01
   query18  0.210.200.20
   query19  1.831.841.88
   query20  0.020.010.01
   query21  15.38   0.600.58
   query22  2.172.781.95
   query23  16.94   1.330.93
   query24  2.910.551.64
   query25  0.280.080.08
   query26  0.470.130.14
   query27  0.040.050.05
   query28  10.85   1.091.08
   query29  12.57   3.233.24
   query30  0.240.060.06
   query31  2.870.380.36
   query32  3.290.470.45
   query33  2.982.983.20
   query34  16.81   4.464.51
   query35  4.494.474.46
   query36  0.640.470.52
   query37  0.090.060.06
   query38  0.050.030.04
   query39  0.040.020.02
   query40  0.160.120.12
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 106.3 s
   Total hot run time: 32.19 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 showCollationCommand in nereids [doris]

2024-11-03 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196417 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 6c745db865ee559454cdb0d509af01d51dacc421, 
data reload: false
   
   query1   1209934 907 907
   query2   6252216721272127
   query3   10804   416039353935
   query4   67971   29359   23654   23654
   query5   4969446 434 434
   query6   407 184 179 179
   query7   5570290 294 290
   query8   314 228 226 226
   query9   9069273627422736
   query10  470 272 254 254
   query11  17454   15685   15708   15685
   query12  159 102 102 102
   query13  1495441 419 419
   query14  10268   716969546954
   query15  206 176 175 175
   query16  7017456 433 433
   query17  1031557 563 557
   query18  1784297 297 297
   query19  204 153 154 153
   query20  124 109 109 109
   query21  204 98  100 98
   query22  4478432444594324
   query23  34643   34059   34397   34059
   query24  5957274028062740
   query25  507 397 391 391
   query26  645 158 157 157
   query27  1686280 298 280
   query28  3927242123922392
   query29  680 428 423 423
   query30  233 153 154 153
   query31  980 799 821 799
   query32  69  57  56  56
   query33  419 270 268 268
   query34  916 523 505 505
   query35  865 732 738 732
   query36  1079950 944 944
   query37  120 76  75  75
   query38  4350427243004272
   query39  1483142614311426
   query40  195 102 98  98
   query41  46  44  47  44
   query42  112 98  103 98
   query43  544 508 502 502
   query44  1191819 828 819
   query45  184 169 165 165
   query46  1115683 699 683
   query47  1961185918771859
   query48  429 326 349 326
   query49  733 400 389 389
   query50  810 404 394 394
   query51  7291714970727072
   query52  101 91  93  91
   query53  254 182 185 182
   query54  533 410 405 405
   query55  76  76  78  76
   query56  257 243 262 243
   query57  1327118111331133
   query58  219 210 212 210
   query59  3340320030303030
   query60  281 261 261 261
   query61  127 153 100 100
   query62  815 663 651 651
   query63  213 182 179 179
   query64  1334644 615 615
   query65  3301321732073207
   query66  705 312 297 297
   query67  16027   15711   15656   15656
   query68  3845592 572 572
   query69  417 252 261 252
   query70  1203119710521052
   query71  343 251 251 251
   query72  6350399840433998
   query73  764 350 349 349
   query74  10354   901089538953
   query75  3410266326822663
   query76  18381101994 994
   query77  443 282 267 267
   query78  10635   942094039403
   query79  1577583 578 578
   query80  881 425 464 425
   query81  511 238 239 238
   query82  1300113 115 113
   query83  218 138 139 138
   query84  281 69  68  68
   query85  925 296 292 292
   query86  338 304 299 299
   query87  4874469048284690
   query88  3630219721512151
   query89  423 286 291 286
   query90  1998193 187 187
   query91  134 96  102 96
   query92  64  50  51  50
   query93  1951537 541 537
   query94  778 293 271 271
   query95  352 250 248 248
   query96  615 278 288 278
   query97  2879269326922692
   query98  210 205 200 200
   query99  1735132113301321
   Total cold run time: 318815 ms
   Total hot run time: 196417 ms
   ```
   
   


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

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

2024-11-03 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41429 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 6c745db865ee559454cdb0d509af01d51dacc421, 
data reload: false
   
   -- Round 1 --
   q1   17580   745373257325
   q2   2050167 156 156
   q3   10639   106811941068
   q4   10568   917 925 917
   q5   7755304530593045
   q6   239 150 150 150
   q7   1038615 602 602
   q8   9367199620071996
   q9   6571638964336389
   q10  7115240924182409
   q11  458 257 266 257
   q12  415 225 213 213
   q13  17771   304930163016
   q14  246 212 210 210
   q15  569 528 518 518
   q16  662 598 584 584
   q17  979 504 565 504
   q18  7322667168126671
   q19  13301006970 970
   q20  471 185 190 185
   q21  3984324333303243
   q22  1128100110201001
   Total cold run time: 108257 ms
   Total hot run time: 41429 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7311728872877287
   q2   333 228 223 223
   q3   3060301831493018
   q4   2114182218441822
   q5   5714578258755782
   q6   225 144 142 142
   q7   2301181918011801
   q8   3443348335503483
   q9   8953895988748874
   q10  3615356235413541
   q11  603 539 518 518
   q12  855 614 632 614
   q13  10357   322232153215
   q14  299 299 281 281
   q15  571 513 508 508
   q16  678 647 646 646
   q17  1868162916501629
   q18  8233795176697669
   q19  1731158715411541
   q20  2102186819041868
   q21  5670546655065466
   q22  1140109410401040
   Total cold run time: 71176 ms
   Total hot run time: 60968 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 showCollationCommand in nereids [doris]

2024-11-03 Thread via GitHub


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

   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 showCollationCommand in nereids [doris]

2024-11-03 Thread via GitHub


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

   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