Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-29 Thread via GitHub


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


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-29 Thread via GitHub


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

   PR approved by anyone and no changes requested.


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-29 Thread via GitHub


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

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


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-28 Thread via GitHub


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

   
   
   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 e9abde09605a333e5576bc0154c75cb87751fc10, 
data reload: false
   
   query1   0.030.020.03
   query2   0.060.030.04
   query3   0.240.080.07
   query4   1.600.100.10
   query5   0.420.410.41
   query6   1.170.660.65
   query7   0.020.020.02
   query8   0.040.040.03
   query9   0.580.500.48
   query10  0.560.560.55
   query11  0.140.110.11
   query12  0.130.120.12
   query13  0.620.620.59
   query14  2.742.762.82
   query15  0.900.830.83
   query16  0.400.380.39
   query17  1.011.061.05
   query18  0.220.210.22
   query19  1.971.842.04
   query20  0.010.010.00
   query21  15.36   0.590.59
   query22  2.292.802.22
   query23  16.98   1.060.83
   query24  3.221.800.97
   query25  0.250.120.13
   query26  0.430.140.14
   query27  0.050.040.04
   query28  9.901.081.06
   query29  12.52   3.243.24
   query30  0.250.070.06
   query31  2.870.380.37
   query32  3.300.460.46
   query33  2.963.073.22
   query34  17.02   4.444.44
   query35  4.594.474.49
   query36  0.670.480.48
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.020.02
   query40  0.160.120.13
   query41  0.070.030.03
   query42  0.030.020.02
   query43  0.040.030.02
   Total cold run time: 105.99 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] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-28 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 190650 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 e9abde09605a333e5576bc0154c75cb87751fc10, 
data reload: false
   
   query1   980 380 377 377
   query2   6525212320912091
   query3   6712213 218 213
   query4   34025   23557   23535   23535
   query5   4389466 454 454
   query6   279 189 175 175
   query7   4615311 308 308
   query8   295 230 228 228
   query9   9576273227232723
   query10  472 260 251 251
   query11  18206   15235   15225   15225
   query12  151 98  108 98
   query13  1674431 424 424
   query14  10243   650369296503
   query15  269 178 187 178
   query16  8125459 469 459
   query17  1616577 558 558
   query18  2130299 304 299
   query19  360 148 189 148
   query20  118 110 111 110
   query21  211 98  99  98
   query22  4592416042064160
   query23  34998   34214   35983   34214
   query24  11456   241324522413
   query25  524 383 374 374
   query26  1117147 150 147
   query27  2889280 277 277
   query28  8034243024472430
   query29  646 395 397 395
   query30  297 147 149 147
   query31  1032803 804 803
   query32  91  55  56  55
   query33  775 305 282 282
   query34  986 533 536 533
   query35  916 745 750 745
   query36  1110969 960 960
   query37  201 72  70  70
   query38  4337426143054261
   query39  1468144214261426
   query40  281 99  101 99
   query41  48  43  42  42
   query42  105 96  94  94
   query43  516 490 492 490
   query44  1203790 786 786
   query45  192 171 162 162
   query46  1173718 709 709
   query47  1941186818271827
   query48  400 324 307 307
   query49  1276382 386 382
   query50  803 391 369 369
   query51  7135696871426968
   query52  101 87  85  85
   query53  254 179 184 179
   query54  1131399 399 399
   query55  79  81  79  79
   query56  257 238 237 237
   query57  1236114111351135
   query58  225 204 214 204
   query59  3211303129942994
   query60  259 240 233 233
   query61  106 105 101 101
   query62  856 681 711 681
   query63  211 182 184 182
   query64  4876655 607 607
   query65  3286320132483201
   query66  1279311 312 311
   query67  16069   15798   15618   15618
   query68  4546559 589 559
   query69  410 246 258 246
   query70  1195109111611091
   query71  346 245 254 245
   query72  6076406140454045
   query73  772 367 360 360
   query74  10548   895490508954
   query75  3429264926452645
   query76  2718108311521083
   query77  523 268 286 268
   query78  10312   936093859360
   query79  2224599 606 599
   query80  1052418 422 418
   query81  523 237 235 235
   query82  634 117 124 117
   query83  254 142 146 142
   query84  240 68  67  67
   query85  1880294 298 294
   query86  512 304 274 274
   query87  4831469046784678
   query88  4101223621902190
   query89  405 301 301 301
   query90  2184190 194 190
   query91  138 109 98  98
   query92  66  52  51  51
   query93  2329529 542 529
   query94  1140295 289 289
   query95  362 243 244 243
   query96  640 278 281 278
   query97  2888264827062648
   query98  212 199 203 199
   query99  1594132813261326
   Total cold run time: 304033 ms
   Total hot run time: 190650 ms
   ```
   
   


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

Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-28 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39805 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e9abde09605a333e5576bc0154c75cb87751fc10, 
data reload: false
   
   -- Round 1 --
   q1   17601   745272367236
   q2   2043186 179 179
   q3   10539   113211391132
   q4   10229   753 678 678
   q5   7610270327162703
   q6   235 146 145 145
   q7   973 627 606 606
   q8   9252182019331820
   q9   6642644264666442
   q10  6940230923312309
   q11  460 259 265 259
   q12  414 219 212 212
   q13  17765   299929992999
   q14  248 210 213 210
   q15  576 545 528 528
   q16  626 579 585 579
   q17  970 596 539 539
   q18  7505662765276527
   q19  1356109210031003
   q20  486 195 181 181
   q21  4055320631953195
   q22  400 324 323 323
   Total cold run time: 106925 ms
   Total hot run time: 39805 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7232727672127212
   q2   331 233 236 233
   q3   2929273030282730
   q4   2168179418201794
   q5   5593570056885688
   q6   225 137 136 136
   q7   2200178418561784
   q8   3379353734963496
   q9   8955908089668966
   q10  3564361135053505
   q11  595 532 497 497
   q12  834 604 594 594
   q13  13463   318532003185
   q14  291 273 260 260
   q15  582 529 513 513
   q16  716 633 632 632
   q17  1778157315481548
   q18  7814749672997299
   q19  1639152615131513
   q20  2040179817861786
   q21  5468521752575217
   q22  636 556 560 556
   Total cold run time: 72432 ms
   Total hot run time: 59144 ms
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-28 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2507098361

   run buildall


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-28 Thread via GitHub


morningman commented on code in PR #44615:
URL: https://github.com/apache/doris/pull/44615#discussion_r1862315775


##
be/src/vec/exec/format/orc/vorc_reader.cpp:
##
@@ -624,15 +625,37 @@ std::tuple 
OrcReader::_make_orc_lite
 }
 }
 
-// check if the slot of expr can be pushed down to orc reader
+// check if the slot of expr can be pushed down to orc reader and make orc 
predicate type
 bool OrcReader::_check_slot_can_push_down(const VExprSPtr& expr) {
 if (!expr->children()[0]->is_slot_ref()) {
 return false;
 }
 const auto* slot_ref = static_cast(expr->children()[0].get());
 // check if the slot exists in orc file and not partition column
-return _col_name_to_file_col_name.contains(slot_ref->expr_name()) &&
-   
!_lazy_read_ctx.predicate_partition_columns.contains(slot_ref->expr_name());
+if (!_col_name_to_file_col_name.contains(slot_ref->expr_name()) &&

Review Comment:
   ```suggestion
   if (!_col_name_to_file_col_name.contains(slot_ref->expr_name()) ||
   ```



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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-27 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.13 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 91c17ee8d451792d45e5aedb71098b9a9441e707, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.040.03
   query3   0.230.080.06
   query4   1.620.100.10
   query5   0.450.410.41
   query6   1.130.660.65
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.570.520.49
   query10  0.560.540.56
   query11  0.140.110.11
   query12  0.130.120.11
   query13  0.600.590.61
   query14  2.702.752.69
   query15  0.900.830.82
   query16  0.370.380.39
   query17  1.061.061.05
   query18  0.220.210.22
   query19  1.951.871.91
   query20  0.020.000.02
   query21  15.42   0.620.60
   query22  2.812.462.16
   query23  17.13   0.860.86
   query24  2.881.091.96
   query25  0.200.060.08
   query26  0.600.140.14
   query27  0.040.040.04
   query28  9.971.121.09
   query29  12.59   3.283.20
   query30  0.240.060.06
   query31  2.880.390.38
   query32  3.270.470.47
   query33  3.013.083.04
   query34  17.10   4.484.50
   query35  4.544.544.49
   query36  0.680.500.49
   query37  0.090.060.06
   query38  0.050.030.03
   query39  0.040.030.02
   query40  0.160.120.12
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.030.040.03
   Total cold run time: 106.65 s
   Total hot run time: 33.13 s
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-27 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196808 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 91c17ee8d451792d45e5aedb71098b9a9441e707, 
data reload: false
   
   query1   1250944 939 939
   query2   6228202920292029
   query3   10941   395840813958
   query4   67593   28635   23589   23589
   query5   4982451 440 440
   query6   409 207 182 182
   query7   5501307 293 293
   query8   319 233 228 228
   query9   8549273027182718
   query10  455 264 271 264
   query11  17028   15212   16016   15212
   query12  158 107 102 102
   query13  1487443 453 443
   query14  10814   713667896789
   query15  209 193 199 193
   query16  7114493 500 493
   query17  1080591 606 591
   query18  1829344 307 307
   query19  202 163 149 149
   query20  118 118 118 118
   query21  209 107 113 107
   query22  4571461245654565
   query23  35172   34694   34407   34407
   query24  5633254625392539
   query25  505 392 397 392
   query26  661 155 155 155
   query27  1911292 290 290
   query28  4426250224682468
   query29  682 416 417 416
   query30  220 176 149 149
   query31  1024834 867 834
   query32  65  60  56  56
   query33  404 287 297 287
   query34  958 538 525 525
   query35  900 772 762 762
   query36  1081973 975 973
   query37  123 78  76  76
   query38  4479448545204485
   query39  1526146614851466
   query40  206 109 98  98
   query41  44  42  44  42
   query42  113 98  98  98
   query43  543 503 493 493
   query44  1186841 818 818
   query45  187 169 171 169
   query46  1159730 713 713
   query47  2067194019641940
   query48  424 338 321 321
   query49  728 399 388 388
   query50  849 398 416 398
   query51  7373731471557155
   query52  98  89  87  87
   query53  259 184 181 181
   query54  526 415 388 388
   query55  84  76  78  76
   query56  246 236 265 236
   query57  1318119411781178
   query58  223 222 219 219
   query59  3237296030302960
   query60  270 250 240 240
   query61  112 112 112 112
   query62  772 656 677 656
   query63  212 193 187 187
   query64  1454663 645 645
   query65  3270321932213219
   query66  690 303 304 303
   query67  16108   15636   15527   15527
   query68  3733571 579 571
   query69  427 280 256 256
   query70  1186109411381094
   query71  370 254 255 254
   query72  6442411039863986
   query73  771 360 369 360
   query74  10212   893489618934
   query75  3409268226502650
   query76  1778110911141109
   query77  522 296 285 285
   query78  10501   955094589458
   query79  1840599 608 599
   query80  1250423 476 423
   query81  529 242 227 227
   query82  460 118 115 115
   query83  182 150 147 147
   query84  290 73  68  68
   query85  1005308 305 305
   query86  384 309 315 309
   query87  4698447645124476
   query88  3570222921822182
   query89  421 312 295 295
   query90  2034192 191 191
   query91  147 106 102 102
   query92  70  49  52  49
   query93  2546549 548 548
   query94  901 301 268 268
   query95  354 251 249 249
   query96  631 279 282 279
   query97  2867268526712671
   query98  212 197 195 195
   query99  2048132013171317
   Total cold run time: 320364 ms
   Total hot run time: 196808 ms
   ```
   
   


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

Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-27 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39882 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 91c17ee8d451792d45e5aedb71098b9a9441e707, 
data reload: false
   
   -- Round 1 --
   q1   17570   746172437243
   q2   2051177 160 160
   q3   10663   109512211095
   q4   10565   727 748 727
   q5   7884279527202720
   q6   241 160 156 156
   q7   979 638 615 615
   q8   9246186319161863
   q9   6603639464486394
   q10  7035232323792323
   q11  460 269 259 259
   q12  423 218 213 213
   q13  17759   301530463015
   q14  255 211 217 211
   q15  581 523 522 522
   q16  646 604 592 592
   q17  974 574 551 551
   q18  7225658167626581
   q19  1310983 1021983
   q20  477 178 178 178
   q21  3981326531713171
   q22  378 313 310 310
   Total cold run time: 107306 ms
   Total hot run time: 39882 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7253730772297229
   q2   320 226 225 225
   q3   2916277729602777
   q4   2063177018641770
   q5   5714570156145614
   q6   223 148 146 146
   q7   2276183418231823
   q8   3403357535273527
   q9   8866892088838883
   q10  3623353735613537
   q11  596 506 515 506
   q12  799 602 575 575
   q13  11384   329632713271
   q14  302 271 279 271
   q15  591 523 527 523
   q16  695 642 641 641
   q17  1863164716071607
   q18  8263779275147514
   q19  1767167815541554
   q20  2147192818971897
   q21  5570529253505292
   q22  679 567 606 567
   Total cold run time: 71313 ms
   Total hot run time: 59749 ms
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-27 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2504589320

   run buildall


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-27 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2504140158

   run external


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.08 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit f06e0b50cb695b0c9af5e3ef1b627b545846ddd4, 
data reload: false
   
   query1   0.040.030.02
   query2   0.060.040.03
   query3   0.230.070.08
   query4   1.600.100.10
   query5   0.420.420.42
   query6   1.140.660.65
   query7   0.020.020.02
   query8   0.040.030.04
   query9   0.590.520.51
   query10  0.540.550.57
   query11  0.140.100.10
   query12  0.140.110.12
   query13  0.610.610.60
   query14  2.692.822.74
   query15  0.900.840.82
   query16  0.390.390.39
   query17  1.061.051.06
   query18  0.220.220.21
   query19  1.971.882.02
   query20  0.020.010.01
   query21  15.36   0.600.57
   query22  2.852.201.96
   query23  16.96   1.150.70
   query24  3.021.451.15
   query25  0.140.190.12
   query26  0.490.140.14
   query27  0.040.050.04
   query28  10.07   1.111.07
   query29  12.53   3.253.23
   query30  0.250.060.06
   query31  2.890.400.38
   query32  3.280.490.48
   query33  3.023.033.09
   query34  16.91   4.504.58
   query35  4.604.584.55
   query36  0.670.490.48
   query37  0.090.060.07
   query38  0.040.040.03
   query39  0.030.020.02
   query40  0.150.130.13
   query41  0.070.020.03
   query42  0.030.020.02
   query43  0.030.040.03
   Total cold run time: 106.34 s
   Total hot run time: 33.08 s
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197189 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 f06e0b50cb695b0c9af5e3ef1b627b545846ddd4, 
data reload: false
   
   query1   1255949 894 894
   query2   6261207220502050
   query3   10858   418639763976
   query4   67679   28198   23565   23565
   query5   4946455 447 447
   query6   431 204 189 189
   query7   5481309 297 297
   query8   311 234 226 226
   query9   8600275227512751
   query10  437 261 245 245
   query11  16913   15281   15878   15281
   query12  152 102 110 102
   query13  1451421 420 420
   query14  10883   760775557555
   query15  205 183 187 183
   query16  7119495 514 495
   query17  1025584 566 566
   query18  1833309 297 297
   query19  207 160 151 151
   query20  114 114 111 111
   query21  206 104 107 104
   query22  4712431645714316
   query23  34995   34511   34447   34447
   query24  5486261325912591
   query25  472 401 414 401
   query26  653 163 156 156
   query27  1871296 283 283
   query28  4241251524572457
   query29  680 419 417 417
   query30  215 151 148 148
   query31  1038810 855 810
   query32  64  54  59  54
   query33  454 287 302 287
   query34  924 533 526 526
   query35  863 749 744 744
   query36  1133962 978 962
   query37  128 74  81  74
   query38  4551448344304430
   query39  1559148015741480
   query40  210 103 105 103
   query41  49  48  47  47
   query42  120 104 102 102
   query43  568 520 512 512
   query44  1222823 803 803
   query45  190 175 167 167
   query46  1129706 722 706
   query47  2017189519201895
   query48  438 322 337 322
   query49  725 395 414 395
   query50  839 421 393 393
   query51  7381718071397139
   query52  102 90  87  87
   query53  259 178 180 178
   query54  525 401 415 401
   query55  80  75  77  75
   query56  260 234 264 234
   query57  1299117411531153
   query58  218 229 223 223
   query59  3396299529762976
   query60  288 269 249 249
   query61  116 105 122 105
   query62  770 673 659 659
   query63  218 194 194 194
   query64  1385658 678 658
   query65  3255322232353222
   query66  775 298 294 294
   query67  16061   15420   15740   15420
   query68  3783580 581 580
   query69  430 258 258 258
   query70  1232113910601060
   query71  356 263 247 247
   query72  6374402141204021
   query73  775 372 366 366
   query74  10191   897090688970
   query75  3391270926572657
   query76  1791110510591059
   query77  512 317 275 275
   query78  10487   940993489348
   query79  1675612 617 612
   query80  1439421 443 421
   query81  531 231 230 230
   query82  1320121 118 118
   query83  272 158 158 158
   query84  282 76  71  71
   query85  1032290 296 290
   query86  416 276 306 276
   query87  4723456746274567
   query88  3536224922122212
   query89  417 303 306 303
   query90  1985190 188 188
   query91  139 103 106 103
   query92  63  57  53  53
   query93  2065541 563 541
   query94  845 298 305 298
   query95  356 264 256 256
   query96  615 287 275 275
   query97  2874269626792679
   query98  224 196 196 196
   query99  1724131813011301
   Total cold run time: 320156 ms
   Total hot run time: 197189 ms
   ```
   
   


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

Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39745 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit f06e0b50cb695b0c9af5e3ef1b627b545846ddd4, 
data reload: false
   
   -- Round 1 --
   q1   17601   745572667266
   q2   2045169 186 169
   q3   10564   109411981094
   q4   10589   694 747 694
   q5   7603266127322661
   q6   240 146 149 146
   q7   1002631 601 601
   q8   9253181819261818
   q9   6519638564026385
   q10  7042229623012296
   q11  466 261 258 258
   q12  397 220 217 217
   q13  17790   306929772977
   q14  243 206 206 206
   q15  567 545 532 532
   q16  671 607 584 584
   q17  974 522 567 522
   q18  7198663466966634
   q19  13281017960 960
   q20  481 179 181 179
   q21  3971333232343234
   q22  390 330 312 312
   Total cold run time: 106934 ms
   Total hot run time: 39745 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7219720472167204
   q2   329 231 240 231
   q3   2899281929722819
   q4   2044179118171791
   q5   5715569956185618
   q6   231 146 143 143
   q7   2284181917971797
   q8   3413353735083508
   q9   8890896088538853
   q10  3580354135723541
   q11  603 498 505 498
   q12  816 617 625 617
   q13  12816   322432713224
   q14  303 269 283 269
   q15  576 548 527 527
   q16  714 664 646 646
   q17  1851162116261621
   q18  8341770175157515
   q19  1709156215491549
   q20  2135185118881851
   q21  5579548755055487
   q22  616 583 548 548
   Total cold run time: 72663 ms
   Total hot run time: 59857 ms
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   TeamCity be ut coverage result:
Function Coverage: 38.36% (9980/26017) 
Line Coverage: 29.47% (83562/283582)
Region Coverage: 28.59% (42969/150288)
Branch Coverage: 25.20% (21833/86626)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/f06e0b50cb695b0c9af5e3ef1b627b545846ddd4_f06e0b50cb695b0c9af5e3ef1b627b545846ddd4/report/index.html


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2502539690

   run buildall


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2502512203

   run buildall


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.52 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 55170503f5afd25455e0900a2575d77ca1976281, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.030.04
   query3   0.240.080.07
   query4   1.600.100.10
   query5   0.430.420.41
   query6   1.150.650.65
   query7   0.020.010.01
   query8   0.040.030.03
   query9   0.570.500.51
   query10  0.550.560.55
   query11  0.140.100.10
   query12  0.150.120.11
   query13  0.600.620.60
   query14  2.852.732.72
   query15  0.910.830.83
   query16  0.380.380.40
   query17  1.051.071.04
   query18  0.220.210.23
   query19  1.971.882.01
   query20  0.010.010.01
   query21  15.37   0.610.57
   query22  2.732.021.43
   query23  16.96   1.120.81
   query24  2.972.071.19
   query25  0.210.230.05
   query26  0.630.130.13
   query27  0.040.040.04
   query28  9.881.111.08
   query29  12.54   3.253.26
   query30  0.260.080.07
   query31  2.830.380.38
   query32  3.270.460.46
   query33  2.983.083.06
   query34  17.18   4.444.48
   query35  4.484.554.48
   query36  0.690.510.51
   query37  0.100.060.06
   query38  0.040.040.04
   query39  0.030.020.03
   query40  0.170.140.12
   query41  0.080.030.02
   query42  0.030.020.02
   query43  0.030.030.03
   Total cold run time: 106.47 s
   Total hot run time: 32.52 s
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197432 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 55170503f5afd25455e0900a2575d77ca1976281, 
data reload: false
   
   query1   1215927 979 927
   query2   6241210920922092
   query3   10803   403439253925
   query4   67543   31932   23797   23797
   query5   4972473 465 465
   query6   305 184 174 174
   query7   4863304 296 296
   query8   288 234 232 232
   query9   6250277427652765
   query10  422 273 237 237
   query11  15571   15203   15882   15203
   query12  167 103 107 103
   query13  1040432 420 420
   query14  10529   754973227322
   query15  218 183 190 183
   query16  7168458 480 458
   query17  1054585 596 585
   query18  1872316 319 316
   query19  234 163 155 155
   query20  130 115 118 115
   query21  206 109 109 109
   query22  4923467345954595
   query23  34747   34167   34453   34167
   query24  5544252924822482
   query25  500 403 389 389
   query26  680 145 149 145
   query27  2255287 299 287
   query28  4244254125052505
   query29  691 444 428 428
   query30  215 155 153 153
   query31  1013850 847 847
   query32  71  59  59  59
   query33  454 287 288 287
   query34  939 521 535 521
   query35  878 747 749 747
   query36  1107982 1001982
   query37  123 74  77  74
   query38  4483439044274390
   query39  1530146514891465
   query40  210 107 105 105
   query41  50  46  48  46
   query42  115 140 103 103
   query43  556 506 511 506
   query44  1172834 842 834
   query45  183 172 167 167
   query46  1159686 710 686
   query47  2063189819491898
   query48  409 313 313 313
   query49  716 398 402 398
   query50  882 396 399 396
   query51  7397722370977097
   query52  100 88  88  88
   query53  249 181 177 177
   query54  519 410 390 390
   query55  74  78  78  78
   query56  241 280 234 234
   query57  1288119711641164
   query58  212 215 211 211
   query59  3223325030763076
   query60  272 247 245 245
   query61  106 109 108 108
   query62  809 675 671 671
   query63  219 191 196 191
   query64  1375709 622 622
   query65  3275321631883188
   query66  695 298 304 298
   query67  16172   15708   15665   15665
   query68  3632588 561 561
   query69  443 258 260 258
   query70  1239114611641146
   query71  405 248 245 245
   query72  6495408740454045
   query73  784 366 374 366
   query74  9873896090908960
   query75  3415265826662658
   query76  1651105211261052
   query77  502 290 294 290
   query78  10478   951694099409
   query79  1599604 611 604
   query80  843 435 432 432
   query81  517 231 223 223
   query82  1281117 123 117
   query83  207 147 157 147
   query84  283 72  69  69
   query85  1012296 285 285
   query86  351 300 319 300
   query87  4881459745374537
   query88  3779223622312231
   query89  434 297 297 297
   query90  2063190 187 187
   query91  145 100 104 100
   query92  65  50  53  50
   query93  2220531 542 531
   query94  812 300 300 300
   query95  345 256 252 252
   query96  625 277 290 277
   query97  2891268726472647
   query98  221 196 201 196
   query99  2010130313041303
   Total cold run time: 314730 ms
   Total hot run time: 197432 ms
   ```
   
   


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

Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39864 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 55170503f5afd25455e0900a2575d77ca1976281, 
data reload: false
   
   -- Round 1 --
   q1   17582   743972877287
   q2   2039173 167 167
   q3   10775   114411601144
   q4   10533   740 675 675
   q5   7607272126972697
   q6   235 148 146 146
   q7   972 624 614 614
   q8   9238183219251832
   q9   6566637763866377
   q10  7045228723012287
   q11  474 266 249 249
   q12  418 213 213 213
   q13  17795   301730143014
   q14  242 210 212 210
   q15  576 542 518 518
   q16  666 585 594 585
   q17  971 606 533 533
   q18  7181687067966796
   q19  13491011936 936
   q20  470 179 179 179
   q21  4141329930913091
   q22  388 320 314 314
   Total cold run time: 107263 ms
   Total hot run time: 39864 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7224726471957195
   q2   330 228 233 228
   q3   2927282629462826
   q4   2052179417951794
   q5   5731568956715671
   q6   248 138 140 138
   q7   2255186518331833
   q8   3415356935013501
   q9   8837889088848884
   q10  3606353135433531
   q11  604 513 491 491
   q12  828 629 641 629
   q13  11335   325531773177
   q14  305 279 270 270
   q15  596 524 524 524
   q16  696 637 634 634
   q17  1846161315961596
   q18  8279787675087508
   q19  1718166515331533
   q20  2120185318951853
   q21  5483541554045404
   q22  636 565 567 565
   Total cold run time: 71071 ms
   Total hot run time: 59785 ms
   ```
   
   


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


suxiaogang223 commented on PR #44615:
URL: https://github.com/apache/doris/pull/44615#issuecomment-2501613883

   run buildall


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

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

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


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



Re: [PR] [fix](orc) check all the cases before build_search_argument [doris]

2024-11-26 Thread via GitHub


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

   
   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