Re: [PR] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-03 Thread via GitHub


dataroaring merged PR #33183:
URL: https://github.com/apache/doris/pull/33183


-- 
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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-03 Thread via GitHub


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

   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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-03 Thread via GitHub


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

   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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit bfae15fcb666d988207628e59806ecec61d3e5ff with 
default session variables
   Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:  59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:  32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:   16.3 seconds inserted 1000 Rows, about 613K 
ops/s
   ```
   


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

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

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


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



Re: [PR] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.86 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit bfae15fcb666d988207628e59806ecec61d3e5ff, 
data reload: false
   
   query1   0.040.040.04
   query2   0.070.040.04
   query3   0.230.040.04
   query4   1.680.060.06
   query5   0.480.470.49
   query6   1.130.660.65
   query7   0.020.010.01
   query8   0.050.050.05
   query9   0.560.510.51
   query10  0.570.580.55
   query11  0.150.110.11
   query12  0.140.110.12
   query13  0.610.590.60
   query14  0.760.790.81
   query15  0.860.850.84
   query16  0.360.340.35
   query17  0.980.991.00
   query18  0.260.250.26
   query19  1.791.731.77
   query20  0.010.010.01
   query21  15.42   0.820.72
   query22  3.295.281.58
   query23  17.83   1.381.00
   query24  1.870.220.23
   query25  0.130.090.08
   query26  0.290.170.19
   query27  0.080.080.08
   query28  13.46   1.000.95
   query29  12.53   3.413.35
   query30  0.260.070.05
   query31  2.850.380.37
   query32  3.310.480.47
   query33  2.892.852.92
   query34  15.52   4.344.32
   query35  4.364.394.36
   query36  0.670.470.47
   query37  0.200.180.16
   query38  0.170.160.17
   query39  0.050.040.05
   query40  0.180.140.15
   query41  0.090.050.05
   query42  0.060.050.06
   query43  0.040.040.04
   Total cold run time: 106.3 s
   Total hot run time: 29.86 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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 182331 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 bfae15fcb666d988207628e59806ecec61d3e5ff, 
data reload: false
   
   query1   1219111911201119
   query2   6483179618081796
   query3   6661213 223 213
   query4   24983   21468   21551   21468
   query5   4183400 401 400
   query6   289 200 192 192
   query7   4601308 305 305
   query8   243 179 181 179
   query9   8473227022682268
   query10  574 269 279 269
   query11  14966   14491   14434   14434
   query12  144 100 95  95
   query13  1643369 377 369
   query14  8666675367876753
   query15  221 179 177 177
   query16  7158287 276 276
   query17  995 601 581 581
   query18  1905299 286 286
   query19  214 164 163 163
   query20  102 99  92  92
   query21  197 127 131 127
   query22  4929483548004800
   query23  33643   32981   32913   32913
   query24  12644   320232403202
   query25  703 399 409 399
   query26  1901166 163 163
   query27  3022328 329 328
   query28  6850187818571857
   query29  1389598 611 598
   query30  302 168 165 165
   query31  989 731 737 731
   query32  99  63  60  60
   query33  720 260 262 260
   query34  1004484 506 484
   query35  832 698 702 698
   query36  996 861 889 861
   query37  289 80  76  76
   query38  3585343633773377
   query39  1585154615451545
   query40  297 141 138 138
   query41  49  47  48  47
   query42  113 104 102 102
   query43  441 409 397 397
   query44  1098703 702 702
   query45  277 266 266 266
   query46  1083793 775 775
   query47  1878181617871787
   query48  384 305 310 305
   query49  1165384 363 363
   query50  796 399 415 399
   query51  6675668166686668
   query52  110 99  101 99
   query53  363 291 289 289
   query54  321 243 239 239
   query55  90  84  80  80
   query56  245 225 236 225
   query57  1215113411391134
   query58  267 228 227 227
   query59  2512245624302430
   query60  267 234 254 234
   query61  112 109 108 108
   query62  692 448 455 448
   query63  313 288 283 283
   query64  6439310831673108
   query65  3073298730482987
   query66  1436324 322 322
   query67  15487   14845   14840   14840
   query68  9134561 576 561
   query69  557 351 326 326
   query70  1388112311011101
   query71  481 283 273 273
   query72  6395257224322432
   query73  1546328 333 328
   query74  6752638664356386
   query75  3552233622432243
   query76  5283108412331084
   query77  607 251 240 240
   query78  10819   10208   10076   10076
   query79  8913545 530 530
   query80  1493425 416 416
   query81  511 240 241 240
   query82  474 116 113 113
   query83  213 165 164 164
   query84  268 90  90  90
   query85  1069287 282 282
   query86  361 271 279 271
   query87  3671352834743474
   query88  3796234523422342
   query89  556 367 369 367
   query90  2050174 187 174
   query91  135 107 103 103
   query92  66  50  53  50
   query93  6424546 529 529
   query94  1278198 202 198
   query95  1097110010891089
   query96  616 278 272 272
   query97  2678248224722472
   query98  242 215 209 209
   query99  1276852 815 815
   Total cold run time: 300301 ms
   Total hot run time: 182331 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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39705 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit bfae15fcb666d988207628e59806ecec61d3e5ff, 
data reload: false
   
   -- Round 1 --
   q1   17618   416941194119
   q2   2023200 185 185
   q3   10808   128214221282
   q4   10424   886 1020886
   q5   8032305630083008
   q6   224 144 139 139
   q7   1129668 618 618
   q8   10084   213420962096
   q9   7549694468516851
   q10  8642354535243524
   q11  422 243 234 234
   q12  384 224 209 209
   q13  17774   289929182899
   q14  283 246 240 240
   q15  521 493 490 490
   q16  512 402 372 372
   q17  955 919 897 897
   q18  7538655864076407
   q19  1603154615281528
   q20  616 312 312 312
   q21  3606311231013101
   q22  370 308 329 308
   Total cold run time: 17 ms
   Total hot run time: 39705 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4099404240164016
   q2   326 220 216 216
   q3   2978295029302930
   q4   1890184818241824
   q5   5244519752565197
   q6   208 130 127 127
   q7   2239180318201803
   q8   3260331832953295
   q9   9316910891339108
   q10  3769383138323831
   q11  539 454 450 450
   q12  720 534 544 534
   q13  10729   292328872887
   q14  287 271 255 255
   q15  514 484 472 472
   q16  457 402 406 402
   q17  1705169416831683
   q18  7651733373397333
   q19  1645165116571651
   q20  1961172317271723
   q21  4977480247204720
   q22  486 435 441 435
   Total cold run time: 65000 ms
   Total hot run time: 54892 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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


Lchangliang commented on PR #33183:
URL: https://github.com/apache/doris/pull/33183#issuecomment-2032240157

   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] (cloud-merge) Fix the is not same in invertedIndex and catalog [doris]

2024-04-02 Thread via GitHub


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

   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