Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-24 Thread via GitHub


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


-- 
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] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.56 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 108443ccec317f4c15349c999894f2b32deb8890, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.030.03
   query3   0.240.070.06
   query4   1.620.100.10
   query5   0.530.500.50
   query6   1.130.730.72
   query7   0.020.010.02
   query8   0.040.030.03
   query9   0.560.510.50
   query10  0.560.550.54
   query11  0.140.100.10
   query12  0.150.120.11
   query13  0.610.600.59
   query14  0.770.780.82
   query15  0.850.830.82
   query16  0.390.370.40
   query17  1.051.051.03
   query18  0.220.210.21
   query19  1.781.861.74
   query20  0.010.010.01
   query21  15.41   0.590.56
   query22  2.522.391.64
   query23  16.91   1.010.86
   query24  3.451.831.68
   query25  0.270.100.08
   query26  0.670.130.13
   query27  0.040.040.04
   query28  8.840.530.51
   query29  12.55   3.193.17
   query30  0.240.070.05
   query31  2.860.370.39
   query32  3.260.460.45
   query33  2.992.972.99
   query34  17.10   4.534.49
   query35  4.494.504.53
   query36  0.660.480.47
   query37  0.090.060.06
   query38  0.050.030.04
   query39  0.030.030.02
   query40  0.170.130.13
   query41  0.080.030.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 103.52 s
   Total hot run time: 30.56 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] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196144 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 108443ccec317f4c15349c999894f2b32deb8890, 
data reload: false
   
   query1   1266919 890 890
   query2   6296192218591859
   query3   11091   441444944414
   query4   61352   28779   23821   23821
   query5   5231440 443 440
   query6   403 174 178 174
   query7   5473315 302 302
   query8   311 220 217 217
   query9   8696260925902590
   query10  473 260 257 257
   query11  17960   15115   15665   15115
   query12  165 99  107 99
   query13  1454432 414 414
   query14  10384   659865636563
   query15  199 177 188 177
   query16  7096488 523 488
   query17  1148576 574 574
   query18  1890324 332 324
   query19  226 167 172 167
   query20  119 113 124 113
   query21  205 100 102 100
   query22  4673440946184409
   query23  34223   34252   33917   33917
   query24  6141286329062863
   query25  526 424 412 412
   query26  652 167 164 164
   query27  1814357 367 357
   query28  4010219621312131
   query29  695 478 450 450
   query30  237 161 157 157
   query31  986 843 861 843
   query32  73  54  57  54
   query33  406 293 296 293
   query34  931 497 538 497
   query35  872 723 720 720
   query36  1091969 940 940
   query37  105 62  70  62
   query38  4002397039423942
   query39  1532146514561456
   query40  206 99  110 99
   query41  48  48  47  47
   query42  113 98  97  97
   query43  509 482 492 482
   query44  1175825 814 814
   query45  182 173 178 173
   query46  1158740 717 717
   query47  2025187919061879
   query48  488 371 378 371
   query49  738 412 399 399
   query50  828 428 433 428
   query51  7370733073117311
   query52  101 85  89  85
   query53  257 191 181 181
   query54  566 458 465 458
   query55  79  79  80  79
   query56  282 270 241 241
   query57  1286113711581137
   query58  213 206 213 206
   query59  3225308830173017
   query60  276 256 247 247
   query61  111 107 107 107
   query62  755 687 657 657
   query63  221 181 181 181
   query64  1355648 620 620
   query65  3270317931933179
   query66  706 290 291 290
   query67  15818   15539   15510   15510
   query68  4267574 555 555
   query69  438 267 255 255
   query70  1167112011101110
   query71  339 254 247 247
   query72  6399401539963996
   query73  744 344 362 344
   query74  10128   901590659015
   query75  3358266426952664
   query76  1967103410291029
   query77  487 270 266 266
   query78  10605   965896089608
   query79  2248594 594 594
   query80  1331411 431 411
   query81  500 219 217 217
   query82  943 86  84  84
   query83  162 142 137 137
   query84  279 75  75  75
   query85  982 319 290 290
   query86  373 265 284 265
   query87  4509425942184218
   query88  4104239723712371
   query89  421 289 279 279
   query90  1989181 184 181
   query91  173 146 144 144
   query92  60  47  51  47
   query93  2602571 559 559
   query94  795 287 280 280
   query95  351 263 250 250
   query96  617 279 281 279
   query97  3289313131723131
   query98  208 210 188 188
   query99  1584130412781278
   Total cold run time: 315187 ms
   Total hot run time: 196144 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] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39773 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 108443ccec317f4c15349c999894f2b32deb8890, 
data reload: false
   
   -- Round 1 --
   q1   17561   683366046604
   q2   2055162 181 162
   q3   10573   110312401103
   q4   10574   801 714 714
   q5   7757288828722872
   q6   219 139 133 133
   q7   985 616 609 609
   q8   9361195921001959
   q9   6600643764536437
   q10  7027229822792279
   q11  483 270 258 258
   q12  396 216 212 212
   q13  17794   296230082962
   q14  223 215 212 212
   q15  491 472 475 472
   q16  493 385 380 380
   q17  996 559 547 547
   q18  7311660166746601
   q19  1394995 1104995
   q20  476 197 203 197
   q21  3896326131193119
   q22  10901006946 946
   Total cold run time: 107755 ms
   Total hot run time: 39773 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6553655365856553
   q2   335 233 223 223
   q3   2853280428202804
   q4   2008187018371837
   q5   5798571757385717
   q6   208 129 132 129
   q7   2258177018391770
   q8   3387359235343534
   q9   8934875389368753
   q10  3605353734973497
   q11  596 502 489 489
   q12  807 625 616 616
   q13  9601319131423142
   q14  289 279 282 279
   q15  521 463 483 463
   q16  482 455 442 442
   q17  1848164616201620
   q18  8377777277167716
   q19  1723163815421542
   q20  2132189918681868
   q21  5053501151135011
   q22  1122103310161016
   Total cold run time: 68490 ms
   Total hot run time: 59021 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] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


dataroaring commented on PR #51011:
URL: https://github.com/apache/doris/pull/51011#issuecomment-2961123639

   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]



Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


dataroaring closed pull request #51011: branch-3.0: [feat](hive) add catalog 
level schema cache property #50958 #51057
URL: https://github.com/apache/doris/pull/51011


-- 
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]



[PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 #51057 [doris]

2025-06-10 Thread via GitHub


github-actions[bot] opened a new pull request, #51011:
URL: https://github.com/apache/doris/pull/51011

   Cherry-picked from #50958 #51057


-- 
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]