Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


qidaye merged PR #44361:
URL: https://github.com/apache/doris/pull/44361


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.68 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 9f063ffe153f96436faa24cdbcdf3389146ebc60, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.040.03
   query3   0.240.070.08
   query4   1.590.100.11
   query5   0.410.400.40
   query6   1.140.660.66
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.560.510.48
   query10  0.550.560.56
   query11  0.140.110.10
   query12  0.150.110.11
   query13  0.610.610.60
   query14  2.802.832.80
   query15  0.890.830.82
   query16  0.380.380.37
   query17  1.040.950.99
   query18  0.230.210.21
   query19  1.981.771.83
   query20  0.020.010.02
   query21  15.40   0.630.59
   query22  2.842.212.00
   query23  16.90   1.100.84
   query24  2.991.800.98
   query25  0.250.190.14
   query26  0.440.130.13
   query27  0.040.040.05
   query28  10.28   1.091.07
   query29  12.57   3.283.31
   query30  0.250.060.07
   query31  2.880.380.38
   query32  3.270.460.48
   query33  3.012.963.01
   query34  16.94   4.474.44
   query35  4.534.464.42
   query36  0.670.490.48
   query37  0.090.060.06
   query38  0.040.030.04
   query39  0.030.020.02
   query40  0.160.130.12
   query41  0.080.030.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 106.62 s
   Total hot run time: 32.68 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 191637 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 9f063ffe153f96436faa24cdbcdf3389146ebc60, 
data reload: false
   
   query1   869 389 392 389
   query2   4628208520882085
   query3   4213222 207 207
   query4   33406   23606   23470   23470
   query5   3234455 445 445
   query6   246 177 175 175
   query7   3840297 308 297
   query8   273 225 227 225
   query9   8165267026652665
   query10  420 256 256 256
   query11  18042   15198   15400   15198
   query12  153 107 103 103
   query13  1334414 427 414
   query14  9563740675067406
   query15  289 179 196 179
   query16  7404493 465 465
   query17  1391595 545 545
   query18  1951286 283 283
   query19  319 145 146 145
   query20  116 113 108 108
   query21  215 106 101 101
   query22  4607455844554455
   query23  34929   34020   34159   34020
   query24  11403   239424902394
   query25  593 387 379 379
   query26  1616143 149 143
   query27  2601269 288 269
   query28  6911244924312431
   query29  917 412 405 405
   query30  281 146 156 146
   query31  1038836 792 792
   query32  74  60  56  56
   query33  704 286 276 276
   query34  942 516 534 516
   query35  863 699 725 699
   query36  1083932 941 932
   query37  254 80  72  72
   query38  4451419042544190
   query39  1507142914411429
   query40  276 99  96  96
   query41  48  44  44  44
   query42  113 95  96  95
   query43  535 491 481 481
   query44  1218835 814 814
   query45  185 163 163 163
   query46  1151715 704 704
   query47  1983190618791879
   query48  408 318 302 302
   query49  1026382 393 382
   query50  835 374 382 374
   query51  7268711471177114
   query52  96  87  92  87
   query53  253 181 176 176
   query54  740 408 404 404
   query55  82  81  96  81
   query56  263 248 244 244
   query57  1329119911821182
   query58  236 219 212 212
   query59  3250313629262926
   query60  293 238 250 238
   query61  113 111 113 111
   query62  840 675 678 675
   query63  212 185 185 185
   query64  4504665 635 635
   query65  3283320532603205
   query66  1153342 309 309
   query67  16176   15888   15686   15686
   query68  4928542 560 542
   query69  417 253 257 253
   query70  1150114411491144
   query71  349 252 250 250
   query72  6221406842304068
   query73  765 356 372 356
   query74  10338   909790079007
   query75  3449265827122658
   query76  2707101110971011
   query77  464 316 278 278
   query78  10586   944795299447
   query79  1092589 596 589
   query80  721 427 447 427
   query81  554 232 230 230
   query82  654 118 121 118
   query83  209 153 149 149
   query84  251 69  68  68
   query85  978 294 298 294
   query86  325 306 296 296
   query87  4666461944954495
   query88  3146225822212221
   query89  404 297 305 297
   query90  2139189 194 189
   query91  139 105 104 104
   query92  62  57  51  51
   query93  1040529 533 529
   query94  943 284 258 258
   query95  345 253 246 246
   query96  618 280 280 280
   query97  2859269726972697
   query98  213 188 192 188
   query99  1556134613281328
   Total cold run time: 287002 ms
   Total hot run time: 191637 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](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40258 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9f063ffe153f96436faa24cdbcdf3389146ebc60, 
data reload: false
   
   -- Round 1 --
   q1   17619   756473167316
   q2   2049184 189 184
   q3   10527   116212201162
   q4   10209   727 731 727
   q5   7604285427722772
   q6   244 153 152 152
   q7   1009656 625 625
   q8   9461191719451917
   q9   8272644364546443
   q10  7080233023722330
   q11  454 269 264 264
   q12  544 222 220 220
   q13  17787   303330023002
   q14  255 209 207 207
   q15  577 548 531 531
   q16  695 602 595 595
   q17  999 556 602 556
   q18  7448669466406640
   q19  13591059899 899
   q20  476 186 188 186
   q21  3967322232173217
   q22  396 313 324 313
   Total cold run time: 109031 ms
   Total hot run time: 40258 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7368726972957269
   q2   328 226 231 226
   q3   2944280428022802
   q4   1994172417611724
   q5   5429544454725444
   q6   224 142 142 142
   q7   2116169317501693
   q8   3308343134243424
   q9   8533855785858557
   q10  3518346734673467
   q11  603 496 509 496
   q12  835 567 598 567
   q13  11305   301330363013
   q14  303 267 262 262
   q15  563 514 505 505
   q16  665 661 639 639
   q17  1814159315681568
   q18  7710737775927377
   q19  1684149914651465
   q20  2046179718391797
   q21  5361527250245024
   q22  603 570 564 564
   Total cold run time: 69254 ms
   Total hot run time: 58025 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](bloom filter)Fix drop column with bloom filter index [doris]

2024-11-21 Thread via GitHub


qidaye commented on PR #44361:
URL: https://github.com/apache/doris/pull/44361#issuecomment-2490386031

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]