You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/01/30 12:09:00 UTC
[PR] [enhance](mtmv)use version instead of timestamp [doris]
zddr opened a new pull request, #30599:
URL: https://github.com/apache/doris/pull/30599
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916744556
<details>
<summary>TPC-H: <b>Total hot run time: 36955 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 01952b34db77d612b8b760fd88c54ac21b9c8ee6, data reload: false
------ Round 1 ----------------------------------
q1 17633 4445 4417 4417
q2 2044 140 132 132
q3 10600 900 909 900
q4 4966 749 732 732
q5 7696 2769 2760 2760
q6 182 119 118 118
q7 1146 716 710 710
q8 9268 2018 2028 2018
q9 7264 6330 6360 6330
q10 8095 2418 2445 2418
q11 412 200 195 195
q12 763 277 283 277
q13 18115 3270 3320 3270
q14 286 248 245 245
q15 528 490 489 489
q16 453 396 414 396
q17 940 587 527 527
q18 6763 6163 6013 6013
q19 1539 1383 1344 1344
q20 570 323 339 323
q21 6793 3122 3042 3042
q22 814 299 303 299
Total cold run time: 106870 ms
Total hot run time: 36955 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4397 4407 4427 4407
q2 340 228 217 217
q3 3038 2815 2847 2815
q4 1863 1599 1670 1599
q5 5132 5230 5280 5230
q6 192 114 112 112
q7 2167 1767 1794 1767
q8 3101 3221 3245 3221
q9 8299 8293 8275 8275
q10 5791 3557 3561 3557
q11 537 452 462 452
q12 767 571 632 571
q13 10378 3054 3082 3054
q14 277 253 270 253
q15 538 494 483 483
q16 519 456 438 438
q17 1870 1665 1708 1665
q18 7970 7830 7659 7659
q19 6704 1489 1476 1476
q20 2129 1904 1909 1904
q21 4778 4532 4633 4532
q22 542 445 478 445
Total cold run time: 71329 ms
Total hot run time: 54132 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916704864
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916921803
<details>
<summary>TPC-DS: <b>Total hot run time: 172097 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 2988482bf8ce9044e3262fd996a7a12a02520ec1, data reload: false
query1 945 333 318 318
query2 6563 1859 1952 1859
query3 6706 210 207 207
query4 26967 22086 21957 21957
query5 4464 352 400 352
query6 252 156 163 156
query7 4622 266 253 253
query8 244 172 171 171
query9 9118 2237 2228 2228
query10 412 199 197 197
query11 16972 15321 15308 15308
query12 120 69 60 60
query13 1685 371 375 371
query14 9262 6628 6499 6499
query15 230 180 184 180
query16 6517 256 251 251
query17 1901 479 468 468
query18 1927 253 247 247
query19 173 132 134 132
query20 71 71 63 63
query21 193 132 129 129
query22 4733 4658 4626 4626
query23 30971 30323 30120 30120
query24 7260 2738 2728 2728
query25 528 319 305 305
query26 817 132 137 132
query27 2598 284 285 284
query28 4564 1827 1821 1821
query29 951 612 610 610
query30 276 134 132 132
query31 916 706 722 706
query32 92 56 48 48
query33 429 205 211 205
query34 836 467 471 467
query35 841 749 734 734
query36 1292 1227 1197 1197
query37 95 55 54 54
query38 3271 3160 3164 3160
query39 1303 1245 1248 1245
query40 198 88 81 81
query41 39 34 33 33
query42 84 77 86 77
query43 543 475 478 475
query44 1045 678 684 678
query45 188 178 176 176
query46 1044 659 635 635
query47 1471 1415 1483 1415
query48 383 311 311 311
query49 1116 286 284 284
query50 681 310 311 310
query51 5305 5166 5064 5064
query52 89 79 75 75
query53 312 251 258 251
query54 227 181 187 181
query55 81 73 77 73
query56 167 158 163 158
query57 923 888 937 888
query58 189 157 151 151
query59 2296 2392 2343 2343
query60 198 175 172 172
query61 84 83 85 83
query62 574 371 351 351
query63 276 251 264 251
query64 3858 1758 1703 1703
query65 3294 3210 3204 3204
query66 1147 322 316 316
query67 14306 14066 14097 14066
query68 3951 499 496 496
query69 432 310 302 302
query70 1592 1571 1517 1517
query71 277 221 211 211
query72 3721 2809 2847 2809
query73 695 320 323 320
query74 6558 6238 6206 6206
query75 2813 2317 2289 2289
query76 2958 962 925 925
query77 354 227 224 224
query78 9071 8677 8603 8603
query79 1882 486 492 486
query80 1266 323 304 304
query81 500 198 199 198
query82 1024 85 79 79
query83 223 113 120 113
query84 235 72 75 72
query85 1067 364 333 333
query86 458 418 373 373
query87 3527 3307 3229 3229
query88 3034 2254 2255 2254
query89 396 341 345 341
query90 1984 188 186 186
query91 145 117 117 117
query92 51 43 43 43
query93 1748 424 400 400
query94 1157 157 154 154
query95 504 444 454 444
query96 637 325 340 325
query97 4226 4135 4121 4121
query98 204 193 189 189
query99 1097 649 683 649
Total cold run time: 259022 ms
Total hot run time: 172097 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920452700
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916895782
<details>
<summary>TPC-H: <b>Total hot run time: 36557 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2988482bf8ce9044e3262fd996a7a12a02520ec1, data reload: false
------ Round 1 ----------------------------------
q1 17652 4610 4392 4392
q2 2035 136 131 131
q3 10602 902 929 902
q4 4651 710 690 690
q5 7678 2791 2877 2791
q6 182 119 117 117
q7 1131 712 687 687
q8 9273 1995 2018 1995
q9 7149 6291 6314 6291
q10 8073 2412 2385 2385
q11 414 206 198 198
q12 763 273 280 273
q13 18024 3289 3269 3269
q14 276 234 248 234
q15 523 481 485 481
q16 472 424 400 400
q17 940 494 485 485
q18 6757 5917 5846 5846
q19 1576 1372 1406 1372
q20 616 337 326 326
q21 7076 2998 3052 2998
q22 801 306 294 294
Total cold run time: 106664 ms
Total hot run time: 36557 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4359 4435 4477 4435
q2 335 240 234 234
q3 3009 2823 2824 2823
q4 1831 1673 1607 1607
q5 5189 5275 5238 5238
q6 190 114 116 114
q7 2111 1786 1748 1748
q8 3050 3200 3283 3200
q9 8275 8310 8275 8275
q10 5864 3538 3533 3533
q11 530 470 456 456
q12 745 560 568 560
q13 12332 3080 3076 3076
q14 288 259 271 259
q15 532 496 481 481
q16 526 484 477 477
q17 1830 1695 1653 1653
q18 8000 7596 7389 7389
q19 10823 1525 1560 1525
q20 2111 1919 1902 1902
q21 4874 4437 4577 4437
q22 530 444 484 444
Total cold run time: 77334 ms
Total hot run time: 53866 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on code in PR #30599:
URL: https://github.com/apache/doris/pull/30599#discussion_r1473734335
##########
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVMaxTimestampSnapshot.java:
##########
@@ -0,0 +1,59 @@
+// 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.mtmv;
+
+import com.google.common.base.Objects;
+import com.google.gson.annotations.SerializedName;
+
+/**
+ * The version cannot be obtained from the hive table,
Review Comment:
This comment is same as `MTMVTimestampSnapshot`?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920489947
<details>
<summary>ClickBench: <b>Total hot run time: 30.89 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 36229a33cf969265329ed9e24ff8bcf8c079f6fb, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.03 0.02
query3 0.22 0.06 0.06
query4 1.68 0.10 0.09
query5 0.52 0.51 0.51
query6 1.18 0.64 0.64
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.57 0.50 0.50
query10 0.56 0.56 0.54
query11 0.12 0.09 0.09
query12 0.11 0.09 0.09
query13 0.60 0.62 0.61
query14 0.78 0.80 0.80
query15 0.79 0.78 0.77
query16 0.40 0.38 0.39
query17 1.01 1.00 1.03
query18 0.23 0.27 0.24
query19 1.91 1.72 1.75
query20 0.01 0.01 0.00
query21 15.46 0.56 0.57
query22 2.83 2.61 1.86
query23 17.24 0.77 0.71
query24 2.94 1.42 0.79
query25 0.38 0.25 0.22
query26 0.48 0.13 0.13
query27 0.04 0.05 0.05
query28 11.84 0.85 0.82
query29 12.50 3.26 3.20
query30 0.65 0.53 0.56
query31 2.78 0.35 0.36
query32 3.34 0.47 0.49
query33 3.21 3.25 3.19
query34 16.10 4.33 4.31
query35 4.28 4.27 4.29
query36 1.12 1.05 1.05
query37 0.06 0.05 0.05
query38 0.04 0.03 0.02
query39 0.02 0.02 0.01
query40 0.16 0.13 0.14
query41 0.07 0.01 0.02
query42 0.02 0.01 0.02
query43 0.02 0.03 0.02
Total cold run time: 106.43 s
Total hot run time: 30.89 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916949005
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 2988482bf8ce9044e3262fd996a7a12a02520ec1 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.6 seconds inserted 10000000 Rows, about 735K 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on code in PR #30599:
URL: https://github.com/apache/doris/pull/30599#discussion_r1473743135
##########
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVMaxTimestampSnapshot.java:
##########
@@ -0,0 +1,59 @@
+// 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.mtmv;
+
+import com.google.common.base.Objects;
+import com.google.gson.annotations.SerializedName;
+
+/**
+ * The version cannot be obtained from the hive table,
Review Comment:
yes
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916968876
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920612011
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916939594
<details>
<summary>ClickBench: <b>Total hot run time: 31.71 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 2988482bf8ce9044e3262fd996a7a12a02520ec1, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.02
query3 0.24 0.06 0.06
query4 1.65 0.10 0.09
query5 0.52 0.52 0.52
query6 1.19 0.66 0.64
query7 0.02 0.01 0.02
query8 0.04 0.03 0.03
query9 0.55 0.50 0.51
query10 0.55 0.57 0.55
query11 0.13 0.08 0.08
query12 0.11 0.08 0.09
query13 0.60 0.62 0.61
query14 0.79 0.78 0.80
query15 0.79 0.77 0.78
query16 0.38 0.38 0.38
query17 1.03 0.99 0.98
query18 0.23 0.27 0.22
query19 1.85 1.79 1.77
query20 0.01 0.01 0.01
query21 15.40 0.57 0.57
query22 2.20 3.24 2.70
query23 17.10 0.80 0.95
query24 2.60 0.73 0.96
query25 0.27 0.22 0.16
query26 0.40 0.13 0.14
query27 0.05 0.05 0.05
query28 12.88 0.83 0.83
query29 12.53 3.14 3.20
query30 0.61 0.55 0.52
query31 2.79 0.34 0.35
query32 3.32 0.48 0.47
query33 3.26 3.21 3.23
query34 15.66 4.35 4.33
query35 4.31 4.31 4.31
query36 1.13 1.04 1.06
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.16 0.13 0.12
query41 0.07 0.01 0.02
query42 0.03 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.7 s
Total hot run time: 31.71 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920477479
<details>
<summary>TPC-DS: <b>Total hot run time: 175097 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 36229a33cf969265329ed9e24ff8bcf8c079f6fb, data reload: false
query1 921 337 326 326
query2 6554 2047 2015 2015
query3 6707 203 197 197
query4 31697 22068 22183 22068
query5 4450 368 358 358
query6 253 160 154 154
query7 4612 270 262 262
query8 254 189 183 183
query9 9012 2299 2291 2291
query10 416 206 199 199
query11 15683 15409 15383 15383
query12 120 67 67 67
query13 1616 366 368 366
query14 10359 6971 7296 6971
query15 230 177 179 177
query16 7348 272 252 252
query17 1826 507 477 477
query18 1924 263 256 256
query19 169 136 132 132
query20 72 71 68 68
query21 195 131 134 131
query22 4880 4786 4836 4786
query23 31116 30283 30292 30283
query24 11740 2773 2730 2730
query25 520 328 308 308
query26 1513 144 143 143
query27 2644 284 285 284
query28 6874 1863 1861 1861
query29 1477 627 618 618
query30 286 135 137 135
query31 942 704 722 704
query32 94 55 49 49
query33 726 215 210 210
query34 1269 467 460 460
query35 859 760 748 748
query36 1245 1148 1201 1148
query37 175 61 57 57
query38 3240 3157 3149 3149
query39 1304 1259 1245 1245
query40 331 92 83 83
query41 37 38 34 34
query42 88 77 82 77
query43 545 498 474 474
query44 1138 697 711 697
query45 191 188 178 178
query46 1098 647 653 647
query47 1567 1408 1435 1408
query48 400 307 318 307
query49 1259 293 294 293
query50 701 317 312 312
query51 5259 5169 5203 5169
query52 84 81 70 70
query53 325 271 273 271
query54 267 183 195 183
query55 77 74 72 72
query56 180 161 158 158
query57 1017 907 891 891
query58 193 161 162 161
query59 2337 2432 2315 2315
query60 200 185 181 181
query61 84 88 81 81
query62 662 352 363 352
query63 293 270 262 262
query64 6429 3269 3649 3269
query65 3273 3253 3224 3224
query66 1394 315 302 302
query67 14455 14180 14447 14180
query68 4152 508 505 505
query69 433 323 308 308
query70 1569 1414 1518 1414
query71 300 210 213 210
query72 5414 3138 2810 2810
query73 729 317 324 317
query74 6705 6168 6311 6168
query75 2957 2352 2289 2289
query76 2575 1013 964 964
query77 447 235 224 224
query78 9113 8768 8517 8517
query79 3282 498 513 498
query80 2330 321 309 309
query81 527 199 200 199
query82 1253 84 89 84
query83 381 127 117 117
query84 276 86 75 75
query85 1843 337 315 315
query86 503 385 380 380
query87 3466 3271 3344 3271
query88 4156 2188 2188 2188
query89 426 372 350 350
query90 2079 185 183 183
query91 148 119 118 118
query92 57 41 46 41
query93 4104 456 445 445
query94 1461 161 159 159
query95 513 451 451 451
query96 640 316 314 314
query97 4259 4130 4124 4124
query98 210 194 187 187
query99 1151 679 661 661
Total cold run time: 286665 ms
Total hot run time: 175097 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920469479
<details>
<summary>TPC-H: <b>Total hot run time: 37332 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 36229a33cf969265329ed9e24ff8bcf8c079f6fb, data reload: false
------ Round 1 ----------------------------------
q1 18028 4785 4649 4649
q2 2148 156 146 146
q3 12225 947 938 938
q4 5034 796 769 769
q5 7854 2819 2806 2806
q6 187 125 123 123
q7 1181 735 737 735
q8 9492 2034 2029 2029
q9 7255 6313 6306 6306
q10 8077 2496 2400 2400
q11 411 197 209 197
q12 752 294 282 282
q13 18000 3328 3302 3302
q14 283 255 258 255
q15 524 495 486 486
q16 472 403 404 403
q17 945 483 516 483
q18 6809 5966 5951 5951
q19 1575 1351 1361 1351
q20 639 330 346 330
q21 6981 3099 3110 3099
q22 815 292 313 292
Total cold run time: 109687 ms
Total hot run time: 37332 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4510 4337 4350 4337
q2 327 232 235 232
q3 3007 2904 2788 2788
q4 1868 1674 1702 1674
q5 5239 5282 5230 5230
q6 192 114 116 114
q7 2223 1783 1762 1762
q8 3135 3253 3306 3253
q9 8342 8376 8315 8315
q10 5828 3557 3528 3528
q11 544 455 473 455
q12 739 582 582 582
q13 6698 3094 3128 3094
q14 275 248 271 248
q15 533 492 491 491
q16 508 480 477 477
q17 1828 1713 1684 1684
q18 7978 7828 7512 7512
q19 8446 1539 1570 1539
q20 2141 1912 1896 1896
q21 4927 4587 4697 4587
q22 583 462 492 462
Total cold run time: 69871 ms
Total hot run time: 54260 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920434496
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916763680
<details>
<summary>TPC-DS: <b>Total hot run time: 173040 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 01952b34db77d612b8b760fd88c54ac21b9c8ee6, data reload: false
query1 932 331 329 329
query2 6560 2112 1933 1933
query3 6702 206 203 203
query4 28458 22176 22088 22088
query5 4458 354 392 354
query6 247 160 155 155
query7 4598 266 254 254
query8 240 170 183 170
query9 9135 2253 2249 2249
query10 403 219 206 206
query11 16624 15371 15341 15341
query12 123 67 60 60
query13 1670 371 357 357
query14 9207 6479 6540 6479
query15 202 173 176 173
query16 6374 252 256 252
query17 1873 474 468 468
query18 1850 252 249 249
query19 174 128 126 126
query20 75 70 67 67
query21 195 132 126 126
query22 5096 5003 4839 4839
query23 31073 30273 30281 30273
query24 12372 2789 2715 2715
query25 602 309 309 309
query26 2006 134 135 134
query27 3221 282 283 282
query28 7671 1828 1831 1828
query29 2208 596 601 596
query30 283 131 139 131
query31 895 711 715 711
query32 92 50 44 44
query33 711 208 208 208
query34 1216 455 452 452
query35 845 732 772 732
query36 1277 1241 1183 1183
query37 171 56 61 56
query38 3300 3188 3171 3171
query39 1327 1223 1234 1223
query40 325 83 80 80
query41 36 37 34 34
query42 87 82 76 76
query43 508 504 504 504
query44 1093 673 675 673
query45 190 176 175 175
query46 1045 639 644 639
query47 1605 1509 1499 1499
query48 393 297 299 297
query49 1291 279 270 270
query50 697 306 310 306
query51 5299 5157 5174 5157
query52 100 77 78 77
query53 317 258 271 258
query54 257 184 179 179
query55 77 79 73 73
query56 171 155 153 153
query57 1074 926 898 898
query58 171 154 160 154
query59 2396 2236 2202 2202
query60 196 177 172 172
query61 82 93 82 82
query62 604 345 352 345
query63 273 269 268 268
query64 5698 1790 1706 1706
query65 3285 3207 3201 3201
query66 1494 330 310 310
query67 14579 14264 14263 14263
query68 3805 496 490 490
query69 433 308 305 305
query70 1568 1510 1540 1510
query71 278 215 207 207
query72 3650 2841 2835 2835
query73 684 318 318 318
query74 6611 6273 6269 6269
query75 2811 2298 2302 2298
query76 2895 969 946 946
query77 345 234 224 224
query78 9090 8837 8589 8589
query79 2744 487 507 487
query80 2001 328 317 317
query81 530 192 192 192
query82 770 83 77 77
query83 245 124 113 113
query84 298 74 71 71
query85 2325 346 332 332
query86 510 397 369 369
query87 3503 3260 3301 3260
query88 3839 2248 2253 2248
query89 429 352 348 348
query90 1944 191 190 190
query91 147 119 119 119
query92 52 45 46 45
query93 2369 441 407 407
query94 1361 160 155 155
query95 488 440 444 440
query96 628 328 334 328
query97 4249 4141 4139 4139
query98 209 182 185 182
query99 1057 659 653 653
Total cold run time: 279677 ms
Total hot run time: 173040 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916773163
<details>
<summary>ClickBench: <b>Total hot run time: 30.53 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 01952b34db77d612b8b760fd88c54ac21b9c8ee6, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.67 0.10 0.10
query5 0.54 0.52 0.52
query6 1.18 0.65 0.63
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.56 0.50 0.50
query10 0.57 0.56 0.55
query11 0.11 0.08 0.08
query12 0.10 0.09 0.10
query13 0.60 0.61 0.61
query14 0.79 0.81 0.79
query15 0.78 0.78 0.78
query16 0.38 0.38 0.41
query17 1.02 1.02 1.03
query18 0.22 0.27 0.23
query19 1.82 1.78 1.77
query20 0.02 0.01 0.01
query21 15.41 0.58 0.56
query22 2.88 2.33 1.34
query23 17.40 0.78 0.84
query24 2.70 0.87 0.89
query25 0.35 0.16 0.14
query26 0.51 0.14 0.14
query27 0.06 0.05 0.03
query28 11.93 0.84 0.83
query29 12.48 3.08 3.10
query30 0.67 0.56 0.55
query31 2.79 0.35 0.35
query32 3.36 0.48 0.48
query33 3.20 3.27 3.22
query34 15.76 4.34 4.37
query35 4.32 4.31 4.33
query36 1.12 1.05 1.06
query37 0.06 0.04 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.14 0.13
query41 0.08 0.01 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 106.09 s
Total hot run time: 30.53 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916778772
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 01952b34db77d612b8b760fd88c54ac21b9c8ee6 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.7 seconds inserted 10000000 Rows, about 729K 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1917062205
<details>
<summary>TPC-H: <b>Total hot run time: 36994 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 0c70eddcbbe6f75efc75a953ea18e86328bc0869, data reload: false
------ Round 1 ----------------------------------
q1 17639 4473 4463 4463
q2 2057 140 131 131
q3 10615 920 895 895
q4 4678 697 728 697
q5 7672 2900 2853 2853
q6 183 122 118 118
q7 1100 714 702 702
q8 9269 2024 1974 1974
q9 7225 6335 6305 6305
q10 8124 2457 2414 2414
q11 421 208 213 208
q12 771 272 289 272
q13 18055 3505 3481 3481
q14 273 262 276 262
q15 531 512 477 477
q16 498 420 438 420
q17 947 515 594 515
q18 6838 6019 5891 5891
q19 1572 1335 1454 1335
q20 586 339 316 316
q21 7016 2963 3200 2963
q22 801 313 302 302
Total cold run time: 106871 ms
Total hot run time: 36994 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4445 4294 4365 4294
q2 339 227 230 227
q3 3023 2820 2809 2809
q4 1871 1674 1594 1594
q5 5178 5235 5250 5235
q6 193 114 115 114
q7 2149 1793 1781 1781
q8 3101 3196 3209 3196
q9 8390 8236 8256 8236
q10 5993 3597 3499 3499
q11 554 463 454 454
q12 752 587 576 576
q13 14491 3108 3093 3093
q14 272 262 254 254
q15 538 499 481 481
q16 484 452 475 452
q17 1835 1633 1681 1633
q18 8050 7654 7418 7418
q19 9450 1523 1494 1494
q20 2109 1914 1909 1909
q21 4788 4580 4640 4580
q22 593 487 498 487
Total cold run time: 78598 ms
Total hot run time: 53816 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1917106595
<details>
<summary>ClickBench: <b>Total hot run time: 31.34 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 0c70eddcbbe6f75efc75a953ea18e86328bc0869, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.02
query3 0.23 0.06 0.06
query4 1.64 0.10 0.10
query5 0.53 0.52 0.52
query6 1.18 0.65 0.64
query7 0.01 0.01 0.02
query8 0.04 0.02 0.02
query9 0.55 0.50 0.51
query10 0.56 0.55 0.57
query11 0.14 0.09 0.09
query12 0.12 0.08 0.09
query13 0.60 0.60 0.61
query14 0.80 0.79 0.78
query15 0.79 0.79 0.79
query16 0.39 0.40 0.39
query17 1.04 1.05 1.02
query18 0.24 0.25 0.25
query19 1.89 1.79 1.82
query20 0.01 0.01 0.01
query21 15.40 0.55 0.56
query22 2.48 2.79 2.59
query23 17.07 0.86 0.82
query24 2.58 1.21 0.37
query25 0.30 0.22 0.21
query26 0.48 0.14 0.14
query27 0.06 0.04 0.04
query28 11.55 0.87 0.86
query29 12.61 3.09 3.10
query30 0.60 0.54 0.53
query31 2.78 0.34 0.37
query32 3.32 0.48 0.49
query33 3.22 3.26 3.22
query34 15.85 4.25 4.31
query35 4.29 4.37 4.30
query36 1.10 1.04 1.06
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.03 0.02 0.01
query40 0.17 0.13 0.13
query41 0.07 0.02 0.01
query42 0.03 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.01 s
Total hot run time: 31.34 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920611973
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #30599:
URL: https://github.com/apache/doris/pull/30599
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1920492498
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 36229a33cf969265329ed9e24ff8bcf8c079f6fb with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.1 seconds inserted 10000000 Rows, about 709K 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1916832925
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1917084648
<details>
<summary>TPC-DS: <b>Total hot run time: 172985 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 0c70eddcbbe6f75efc75a953ea18e86328bc0869, data reload: false
query1 951 336 326 326
query2 6552 1896 1851 1851
query3 6701 216 207 207
query4 26497 22104 22109 22104
query5 4458 361 426 361
query6 249 162 160 160
query7 4608 263 267 263
query8 250 174 178 174
query9 8765 2260 2245 2245
query10 415 220 203 203
query11 16921 15397 15314 15314
query12 125 73 67 67
query13 1687 369 362 362
query14 9296 6670 6555 6555
query15 243 183 184 183
query16 6529 271 260 260
query17 1880 488 483 483
query18 1937 261 251 251
query19 213 134 133 133
query20 74 68 70 68
query21 209 134 133 133
query22 4899 4599 4635 4599
query23 31632 30582 30284 30284
query24 7283 2806 2764 2764
query25 538 308 317 308
query26 820 139 139 139
query27 2681 281 283 281
query28 4839 1862 1839 1839
query29 946 634 633 633
query30 280 137 144 137
query31 929 703 717 703
query32 93 51 48 48
query33 443 209 209 209
query34 826 464 488 464
query35 837 777 746 746
query36 1300 1249 1099 1099
query37 94 56 59 56
query38 3270 3126 3126 3126
query39 1331 1259 1262 1259
query40 197 91 80 80
query41 40 36 35 35
query42 93 81 85 81
query43 533 486 495 486
query44 1054 683 683 683
query45 195 182 178 178
query46 1031 649 643 643
query47 1592 1527 1506 1506
query48 393 302 322 302
query49 1112 281 282 281
query50 698 307 306 306
query51 5311 5166 5179 5166
query52 90 91 78 78
query53 330 259 273 259
query54 218 195 185 185
query55 85 78 88 78
query56 186 166 161 161
query57 969 920 897 897
query58 182 158 159 158
query59 2360 2237 2427 2237
query60 204 179 181 179
query61 90 83 85 83
query62 571 363 378 363
query63 272 275 271 271
query64 3991 1765 1768 1765
query65 3312 3237 3213 3213
query66 1146 321 313 313
query67 14279 14031 14120 14031
query68 4032 500 492 492
query69 441 307 320 307
query70 1502 1591 1539 1539
query71 279 219 233 219
query72 3826 2856 2876 2856
query73 704 321 313 313
query74 6703 6276 6263 6263
query75 2818 2277 2337 2277
query76 2946 975 931 931
query77 396 234 234 234
query78 9023 8749 8545 8545
query79 2233 495 502 495
query80 1368 335 334 334
query81 512 202 202 202
query82 673 84 82 82
query83 217 121 122 121
query84 231 79 72 72
query85 1669 343 342 342
query86 520 400 396 396
query87 3425 3267 3276 3267
query88 3586 2269 2257 2257
query89 437 354 365 354
query90 1919 193 185 185
query91 148 116 120 116
query92 60 45 43 43
query93 2278 442 432 432
query94 1226 159 163 159
query95 519 458 452 452
query96 639 331 325 325
query97 4243 4085 4095 4085
query98 210 190 191 190
query99 1076 718 685 685
Total cold run time: 261994 ms
Total hot run time: 172985 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)use version instead of timestamp [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30599:
URL: https://github.com/apache/doris/pull/30599#issuecomment-1917120879
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 0c70eddcbbe6f75efc75a953ea18e86328bc0869 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
Insert into select: 13.5 seconds inserted 10000000 Rows, about 740K 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org