You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "seawinde (via GitHub)" <gi...@apache.org> on 2024/01/03 05:44:37 UTC
[PR] [Fix](nereids) Fix get ralated partition table when nodata [doris]
seawinde opened a new pull request, #29453:
URL: https://github.com/apache/doris/pull/29453
## Proposed changes
Support to create partition materialized view using nodata table
Such as the table def as following:
> CREATE TABLE `test_no_data` (
> `user_id` LARGEINT NOT NULL COMMENT '"用户id"',
> `date` DATE NOT NULL COMMENT '"数据灌入日期时间"',
> `num` SMALLINT NOT NULL COMMENT '"数量"'
> ) ENGINE=OLAP
> DUPLICATE KEY(`user_id`, `date`, `num`)
> COMMENT 'OLAP'
> PARTITION BY RANGE(`date`)
> (PARTITION p201701_1000 VALUES [('0000-01-01'), ('2017-02-01')),
> PARTITION p201702_2000 VALUES [('2017-02-01'), ('2017-03-01')),
> PARTITION p201703_all VALUES [('2017-03-01'), ('2017-04-01')))
> DISTRIBUTED BY HASH(`user_id`) BUCKETS 2
> PROPERTIES ('replication_num' = '1') ;
when table test_no_data has no data, it also support to create partition materialized view as following:
> CREATE MATERIALIZED VIEW no_data_partition_mv
> BUILD IMMEDIATE REFRESH AUTO ON MANUAL
> partition by(`date`)
> DISTRIBUTED BY RANDOM BUCKETS 2
> PROPERTIES ('replication_num' = '1')
> AS
> SELECT * FROM test_no_data where date > '2017-05-01';
>
<!--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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876902411
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on code in PR #29453:
URL: https://github.com/apache/doris/pull/29453#discussion_r1441227871
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,6 +227,15 @@ public void analyzeQuery(ConnectContext ctx) {
}
getRelation(planner);
getColumns(plan);
+ try {
+ // we want to set session variable, so need to new connectContext avoid influence other query
+ statementContext.setConnectContext(
+ MTMVPlanUtil.createMTMVContext(this.envInfo.getCtlId(), this.envInfo.getDbId()));
Review Comment:
Creating a new ctx here may not be a good method. How about setting environment variables on the ctx of crude oil and setting them back after the method ends? Or there may be other methods instead of using the environment variable setDisableNereidsRules
##########
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVPlanUtil.java:
##########
@@ -60,6 +60,21 @@ public static ConnectContext createMTMVContext(MTMV mtmv) throws AnalysisExcepti
return ctx;
}
+ public static ConnectContext createMTMVContext(long ctlId, long dbId) throws AnalysisException {
Review Comment:
There is some overlap with the logic of createMTMVContext (MTMV mtmv), abstract it a bit
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876495936
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1878051340
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875302362
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5425 5086 5161 5086
q2 398 154 158 154
q3 1460 1188 1203 1188
q4 1093 843 815 815
q5 3125 3056 3134 3056
q6 220 146 131 131
q7 980 573 519 519
q8 2140 2263 2271 2263
q9 6712 6662 6681 6662
q10 3176 3152 3102 3102
q11 340 218 215 215
q12 384 242 234 234
q13 4399 3627 3687 3627
q14 249 221 212 212
q15 610 553 549 549
q16 450 423 389 389
q17 1035 587 522 522
q18 7117 6743 7371 6743
q19 1641 1490 1407 1407
q20 552 340 345 340
q21 2854 2436 2474 2436
q22 391 317 328 317
Total cold run time: 44751 ms
Total hot run time: 39967 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5154 5130 5064 5064
q2 342 253 254 253
q3 3366 3328 3279 3279
q4 2141 2042 2017 2017
q5 5938 5933 5898 5898
q6 227 125 125 125
q7 2408 1915 1951 1915
q8 3568 3642 3672 3642
q9 9017 9012 8971 8971
q10 3872 3915 3915 3915
q11 591 471 499 471
q12 814 648 649 648
q13 3885 3217 3178 3178
q14 306 281 278 278
q15 607 544 534 534
q16 574 536 541 536
q17 2049 1821 1826 1821
q18 8761 8396 8304 8304
q19 1724 1685 1649 1649
q20 2293 2006 1979 1979
q21 5720 5297 5320 5297
q22 607 497 457 457
Total cold run time: 63964 ms
Total hot run time: 60231 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875303560
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
------ Round 1 ----------------------------------
q1 17820 5187 5118 5118
q2 2045 160 147 147
q3 10596 1071 1155 1071
q4 10194 773 856 773
q5 7795 2918 2807 2807
q6 221 137 136 136
q7 907 501 557 501
q8 9299 2029 2026 2026
q9 7004 6427 6402 6402
q10 8271 3044 3037 3037
q11 453 228 231 228
q12 395 229 232 229
q13 18019 3662 3675 3662
q14 239 214 207 207
q15 586 549 538 538
q16 492 399 420 399
q17 979 523 513 513
q18 7425 6806 6702 6702
q19 1622 1434 1347 1347
q20 726 325 321 321
q21 2798 2361 2428 2361
q22 379 320 332 320
Total cold run time: 108265 ms
Total hot run time: 38845 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5181 5107 5055 5055
q2 335 251 260 251
q3 3319 3293 3252 3252
q4 2103 2022 2009 2009
q5 5793 5808 5928 5808
q6 224 129 132 129
q7 2378 2038 1999 1999
q8 3413 3467 3493 3467
q9 8953 8897 8785 8785
q10 3846 3837 3829 3829
q11 582 461 483 461
q12 786 633 642 633
q13 13553 3170 3204 3170
q14 293 277 269 269
q15 588 551 527 527
q16 564 490 521 490
q17 1938 1754 1798 1754
q18 8690 8342 8200 8200
q19 1621 1567 1597 1567
q20 2203 1964 1996 1964
q21 5607 5260 5225 5225
q22 550 510 453 453
Total cold run time: 72520 ms
Total hot run time: 59297 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875318289
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.48 seconds
stream load tsv: 561 seconds loaded 74807831229 Bytes, about 127 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.6 seconds inserted 10000000 Rows, about 362K ops/s
storage size: 17183722198 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880401524
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.67 seconds
stream load tsv: 584 seconds loaded 74807831229 Bytes, about 122 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.0 seconds inserted 10000000 Rows, about 357K ops/s
storage size: 17183949665 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1877419151
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874975710
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
------ Round 1 ----------------------------------
q1 18418 5204 5182 5182
q2 2026 159 146 146
q3 10605 1093 1123 1093
q4 10205 762 857 762
q5 7803 2978 2868 2868
q6 214 139 137 137
q7 939 519 561 519
q8 9305 2023 2044 2023
q9 6932 6379 6397 6379
q10 8238 3058 3068 3058
q11 419 213 221 213
q12 390 235 241 235
q13 18014 3646 3654 3646
q14 239 221 214 214
q15 586 544 536 536
q16 446 415 403 403
q17 977 598 502 502
q18 7472 6779 6808 6779
q19 1600 1399 1345 1345
q20 671 348 351 348
q21 2814 2369 2443 2369
q22 382 306 322 306
Total cold run time: 108695 ms
Total hot run time: 39063 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5103 5141 5106 5106
q2 333 234 247 234
q3 3312 3305 3248 3248
q4 2136 2040 2029 2029
q5 5832 5802 5806 5802
q6 216 129 126 126
q7 2359 1902 1870 1870
q8 3383 3468 3462 3462
q9 8878 8839 8856 8839
q10 3815 3816 3867 3816
q11 570 479 477 477
q12 827 628 642 628
q13 11946 3189 3194 3189
q14 295 261 272 261
q15 599 542 545 542
q16 532 486 493 486
q17 1934 1775 1726 1726
q18 8712 8405 8418 8405
q19 1629 1572 1603 1572
q20 2236 2019 1984 1984
q21 5533 5258 5261 5258
q22 524 461 511 461
Total cold run time: 70704 ms
Total hot run time: 59521 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875701524
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 953 348 338 338
query2 4928 2078 1924 1924
query3 6643 208 208 208
query4 27564 22353 22355 22353
query5 3897 513 560 513
query6 261 180 186 180
query7 4583 270 268 268
query8 220 235 200 200
query9 8188 2558 2549 2549
query10 434 261 230 230
query11 16197 15522 15487 15487
query12 132 78 73 73
query13 1642 326 323 323
query14 10739 7212 7122 7122
query15 236 186 188 186
query16 6148 276 268 268
query17 1844 508 492 492
query18 1810 264 272 264
query19 184 139 139 139
query20 79 76 73 73
query21 184 98 98 98
query22 4935 4774 4691 4691
query23 32115 31226 31276 31226
query24 12073 2833 2827 2827
query25 567 348 338 338
query26 1619 137 140 137
query27 2887 279 279 279
query28 6862 1889 1886 1886
query29 1411 399 400 399
query30 292 140 144 140
query31 995 771 793 771
query32 86 58 54 54
query33 743 251 269 251
query34 881 440 442 440
query35 903 750 799 750
query36 1339 1229 1207 1207
query37 181 65 68 65
query38 3424 3309 3280 3280
query39 1331 1296 1284 1284
query40 308 90 87 87
query41 36 37 41 37
query42 88 86 83 83
query43 519 478 482 478
query44 1083 704 718 704
query45 201 191 182 182
query46 1066 655 620 620
query47 1661 1532 1573 1532
query48 342 252 263 252
query49 1149 316 308 308
query50 822 330 339 330
query51 5382 5220 5299 5220
query52 93 82 88 82
query53 221 150 161 150
query54 1382 576 567 567
query55 100 84 82 82
query56 213 195 200 195
query57 1036 928 922 922
query58 219 189 203 189
query59 2896 2705 2662 2662
query60 231 229 223 223
query61 93 91 90 90
query62 640 433 465 433
query63 177 152 147 147
query64 5121 1782 1742 1742
query65 3323 3280 3275 3275
query66 1285 343 341 341
query67 15657 15592 15649 15592
query68 11235 543 538 538
query69 532 260 252 252
query70 1725 1533 1450 1450
query71 511 222 206 206
query72 5897 3647 3636 3636
query73 2279 311 324 311
query74 7136 6479 6578 6479
query75 5395 2260 2287 2260
query76 6305 1176 1107 1107
query77 664 241 272 241
query78 9114 8731 8559 8559
query79 1018 498 504 498
query80 532 347 355 347
query81 451 203 212 203
query82 206 92 85 85
query83 163 142 137 137
query84 252 56 56 56
query85 955 286 287 286
query86 379 379 370 370
query87 3580 3413 3430 3413
query88 2878 2278 2249 2249
query89 315 254 257 254
query90 1886 197 195 195
query91 126 93 97 93
query92 65 51 55 51
query93 1178 444 500 444
query94 822 183 185 183
query95 457 407 410 407
query96 627 322 321 321
query97 4269 4189 4172 4172
query98 206 190 187 187
query99 1065 788 832 788
Total cold run time: 287077 ms
Total hot run time: 179616 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880299081
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1878075110
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 913 349 335 335
query2 6412 1866 1824 1824
query3 6639 212 205 205
query4 27527 22474 22498 22474
query5 3887 510 544 510
query6 261 182 179 179
query7 4579 269 267 267
query8 226 200 200 200
query9 8233 2537 2587 2537
query10 420 245 244 244
query11 16214 15602 15411 15411
query12 136 75 75 75
query13 1624 315 308 308
query14 11443 7090 7202 7090
query15 216 195 188 188
query16 6158 273 260 260
query17 1818 501 496 496
query18 1841 273 258 258
query19 188 133 132 132
query20 76 75 79 75
query21 182 99 92 92
query22 4779 4693 4637 4637
query23 32165 31192 31167 31167
query24 12291 2843 2846 2843
query25 609 344 333 333
query26 1808 143 139 139
query27 2941 273 280 273
query28 6947 1860 1846 1846
query29 2215 384 386 384
query30 284 145 151 145
query31 969 752 787 752
query32 89 58 54 54
query33 725 275 261 261
query34 931 435 440 435
query35 895 773 772 772
query36 1277 1237 1193 1193
query37 181 69 70 69
query38 3369 3287 3267 3267
query39 1339 1321 1287 1287
query40 309 88 93 88
query41 41 35 34 34
query42 88 84 82 82
query43 526 463 487 463
query44 1060 684 688 684
query45 195 186 185 185
query46 1061 635 648 635
query47 1586 1588 1541 1541
query48 335 263 254 254
query49 1207 313 315 313
query50 752 323 320 320
query51 5331 5255 5241 5241
query52 98 90 90 90
query53 209 142 145 142
query54 1364 551 579 551
query55 92 85 80 80
query56 204 190 187 187
query57 1058 925 939 925
query58 235 199 197 197
query59 2802 2573 2641 2573
query60 234 205 224 205
query61 86 85 85 85
query62 675 461 473 461
query63 156 149 147 147
query64 5901 1787 1718 1718
query65 3330 3263 3261 3261
query66 1399 359 337 337
query67 15584 15662 15212 15212
query68 13607 509 503 503
query69 502 254 238 238
query70 2305 1465 1522 1465
query71 484 217 216 216
query72 5658 3569 3558 3558
query73 3498 324 318 318
query74 7002 6390 6556 6390
query75 5379 2284 2281 2281
query76 6303 1125 1063 1063
query77 700 268 283 268
query78 9146 8707 8456 8456
query79 1866 497 485 485
query80 578 360 346 346
query81 455 208 209 208
query82 200 95 93 93
query83 187 132 134 132
query84 247 53 51 51
query85 946 289 276 276
query86 389 397 385 385
query87 3541 3354 3344 3344
query88 3105 2255 2255 2255
query89 337 261 247 247
query90 2244 200 190 190
query91 119 94 89 89
query92 62 53 55 53
query93 1471 437 486 437
query94 905 181 181 181
query95 446 414 394 394
query96 639 319 322 319
query97 4299 4159 4151 4151
query98 212 202 189 189
query99 1107 840 871 840
Total cold run time: 296664 ms
Total hot run time: 178449 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875660148
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875318229
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 881 366 348 348
query2 3676 1883 1963 1883
query3 4972 207 200 200
query4 26603 22492 22414 22414
query5 4135 589 614 589
query6 269 193 186 186
query7 4061 283 274 274
query8 222 214 207 207
query9 6981 2587 2707 2587
query10 401 261 266 261
query11 16360 15561 15489 15489
query12 139 79 77 77
query13 1342 334 335 334
query14 10433 7325 7254 7254
query15 230 195 204 195
query16 5021 273 271 271
query17 1464 505 518 505
query18 1637 287 268 268
query19 208 144 140 140
query20 84 81 79 79
query21 179 103 98 98
query22 4863 4616 4868 4616
query23 32462 31513 31562 31513
query24 12720 2900 2838 2838
query25 638 359 363 359
query26 1722 150 154 150
query27 2856 280 296 280
query28 6804 1978 1981 1978
query29 2553 408 389 389
query30 287 151 152 151
query31 1038 775 796 775
query32 90 60 58 58
query33 718 269 279 269
query34 966 459 451 451
query35 873 803 743 743
query36 1330 1173 1232 1173
query37 174 74 74 74
query38 3388 3271 3269 3269
query39 1357 1294 1297 1294
query40 287 94 95 94
query41 39 36 35 35
query42 95 92 93 92
query43 557 511 494 494
query44 1093 704 741 704
query45 200 193 187 187
query46 1071 672 660 660
query47 1640 1522 1506 1506
query48 348 271 266 266
query49 1180 341 324 324
query50 739 386 373 373
query51 5462 5379 5277 5277
query52 104 91 91 91
query53 224 160 154 154
query54 2023 608 598 598
query55 97 88 87 87
query56 207 203 196 196
query57 985 948 901 901
query58 221 211 212 211
query59 2849 2582 2631 2582
query60 265 245 237 237
query61 85 84 82 82
query62 639 468 454 454
query63 174 151 149 149
query64 5667 1775 1758 1758
query65 3361 3281 3286 3281
query66 1332 337 322 322
query67 15675 15507 15520 15507
query68 11242 546 536 536
query69 468 256 260 256
query70 1643 1465 1544 1465
query71 419 232 222 222
query72 5434 3516 3495 3495
query73 2512 314 313 313
query74 7056 6389 6378 6378
query75 4909 2296 2280 2280
query76 5531 1069 1136 1069
query77 656 291 292 291
query78 9233 8772 8654 8654
query79 3130 534 523 523
query80 557 359 370 359
query81 473 209 213 209
query82 217 101 105 101
query83 169 140 137 137
query84 238 54 54 54
query85 888 286 267 267
query86 430 358 398 358
query87 3582 3382 3388 3382
query88 3085 2286 2283 2283
query89 342 253 258 253
query90 1853 213 212 212
query91 119 86 90 86
query92 65 54 53 53
query93 1552 504 439 439
query94 748 188 191 188
query95 464 413 419 413
query96 627 315 321 315
query97 4304 4174 4163 4163
query98 200 206 189 189
query99 1088 841 805 805
Total cold run time: 283990 ms
Total hot run time: 180409 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on code in PR #29453:
URL: https://github.com/apache/doris/pull/29453#discussion_r1441387973
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,7 +228,18 @@ public void analyzeQuery(ConnectContext ctx) {
}
getRelation(planner);
getColumns(plan);
- analyzePartition(planner);
+ SessionVariable sessionVariable = statementContext.getConnectContext().getSessionVariable();
+ Set<String> tempDisableRules = sessionVariable.getDisableNereidsRuleNames();
+ // Should not make table without data to empty relation, so add disable rules
+ sessionVariable.setDisableNereidsRules(MTMV_PLANER_DISABLE_RULES);
+ try {
+ analyzePartition(planner);
+ } finally {
+ if (!tempDisableRules.isEmpty()) {
Review Comment:
OK, I will fix it
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880514772
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.53 seconds
stream load tsv: 581 seconds loaded 74807831229 Bytes, about 122 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 27.5 seconds inserted 10000000 Rows, about 363K ops/s
storage size: 17187942904 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880894294
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874877248
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874956552
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876959615
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5509 5150 5148 5148
q2 392 181 168 168
q3 1473 1145 1169 1145
q4 1079 887 781 781
q5 3123 3087 3117 3087
q6 223 134 134 134
q7 955 548 531 531
q8 2149 2240 2299 2240
q9 6759 6694 6687 6687
q10 3228 3127 3135 3127
q11 344 224 215 215
q12 383 228 234 228
q13 4375 3626 3606 3606
q14 251 210 219 210
q15 576 525 537 525
q16 456 403 400 400
q17 1039 568 511 511
q18 7098 6795 6765 6765
q19 1648 1620 1454 1454
q20 589 323 316 316
q21 2855 2445 2453 2445
q22 396 333 320 320
Total cold run time: 44900 ms
Total hot run time: 40043 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5126 5079 5100 5079
q2 335 231 228 228
q3 3351 3327 3327 3327
q4 2159 2065 2039 2039
q5 5956 5927 5904 5904
q6 223 125 125 125
q7 2400 1897 1915 1897
q8 3564 3664 3667 3664
q9 9013 8972 8923 8923
q10 3856 3957 3932 3932
q11 609 490 471 471
q12 799 626 639 626
q13 3859 3194 3201 3194
q14 304 270 265 265
q15 606 529 525 525
q16 534 507 523 507
q17 2030 1820 1811 1811
q18 8755 8407 8331 8331
q19 1756 1708 1713 1708
q20 2284 1988 1974 1974
q21 5710 5322 5248 5248
q22 549 463 490 463
Total cold run time: 63778 ms
Total hot run time: 60241 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1877474593
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.37 seconds
stream load tsv: 568 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.2 seconds inserted 10000000 Rows, about 354K ops/s
storage size: 17184199990 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1877484804
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 928 345 326 326
query2 6415 2057 1951 1951
query3 6655 208 205 205
query4 26213 22542 22404 22404
query5 3892 516 541 516
query6 265 184 172 172
query7 4582 265 268 265
query8 238 206 193 193
query9 8299 2558 2535 2535
query10 453 231 224 224
query11 16186 15487 15534 15487
query12 136 80 74 74
query13 1625 323 319 319
query14 11313 7232 6990 6990
query15 222 185 188 185
query16 6353 265 262 262
query17 1890 500 489 489
query18 1964 268 252 252
query19 178 134 133 133
query20 81 75 75 75
query21 186 98 102 98
query22 5064 4774 4752 4752
query23 32005 31130 31256 31130
query24 12082 2776 2790 2776
query25 605 351 332 332
query26 1757 135 143 135
query27 2922 271 281 271
query28 7106 1866 1858 1858
query29 2093 395 377 377
query30 293 142 145 142
query31 993 754 765 754
query32 98 56 53 53
query33 743 247 263 247
query34 940 446 446 446
query35 867 803 799 799
query36 1289 1184 1246 1184
query37 190 71 69 69
query38 3383 3250 3248 3248
query39 1332 1290 1281 1281
query40 306 95 92 92
query41 37 36 34 34
query42 89 85 79 79
query43 533 500 482 482
query44 1140 703 702 702
query45 200 187 181 181
query46 1067 641 628 628
query47 1656 1560 1554 1554
query48 329 256 260 256
query49 1237 328 304 304
query50 779 359 329 329
query51 5440 5308 5299 5299
query52 98 88 82 82
query53 219 147 141 141
query54 1418 566 571 566
query55 100 79 89 79
query56 196 186 195 186
query57 1045 921 926 921
query58 222 194 201 194
query59 2891 2757 2622 2622
query60 235 214 227 214
query61 87 84 86 84
query62 626 471 464 464
query63 165 146 144 144
query64 5937 1635 1662 1635
query65 3324 3247 3259 3247
query66 1399 353 344 344
query67 15536 15333 15186 15186
query68 11206 513 522 513
query69 515 250 258 250
query70 1736 1458 1494 1458
query71 498 210 221 210
query72 5640 3550 3549 3549
query73 2239 313 314 313
query74 6980 6416 6460 6416
query75 4792 2286 2290 2286
query76 6229 1119 1083 1083
query77 663 251 286 251
query78 9084 8726 8507 8507
query79 1042 509 500 500
query80 535 358 345 345
query81 457 211 215 211
query82 203 98 91 91
query83 159 137 139 137
query84 243 53 54 53
query85 949 283 269 269
query86 376 387 375 375
query87 3603 3348 3386 3348
query88 2845 2258 2267 2258
query89 333 261 261 261
query90 1884 194 198 194
query91 120 93 91 91
query92 63 54 52 52
query93 1386 423 421 421
query94 888 185 185 185
query95 472 415 425 415
query96 619 320 319 319
query97 4295 4128 4223 4128
query98 195 199 192 192
query99 1100 810 840 810
Total cold run time: 289496 ms
Total hot run time: 178549 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #29453:
URL: https://github.com/apache/doris/pull/29453
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876943657
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.95 seconds
stream load tsv: 575 seconds loaded 74807831229 Bytes, about 124 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.2 seconds inserted 10000000 Rows, about 354K ops/s
storage size: 17183873705 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1878070648
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.74 seconds
stream load tsv: 563 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.1 seconds inserted 10000000 Rows, about 355K ops/s
storage size: 17188203594 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880467305
<details>
<summary>TPC-H: <b>Total hot run time: 38625 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 d8119a0983f5134a0f97bcedfce508872991f6fe, data reload: false
------ Round 1 ----------------------------------
q1 17658 4969 4957 4957
q2 2024 162 144 144
q3 10619 1152 1179 1152
q4 10454 821 793 793
q5 7842 2968 2951 2951
q6 211 123 123 123
q7 898 504 498 498
q8 9268 1989 1997 1989
q9 6452 6375 6353 6353
q10 8248 3094 3078 3078
q11 441 220 221 220
q12 388 227 230 227
q13 18003 3388 3398 3388
q14 239 215 211 211
q15 546 512 507 507
q16 449 392 402 392
q17 954 651 533 533
q18 7279 6702 6604 6604
q19 1590 1527 1524 1524
q20 719 314 297 297
q21 2756 2379 2381 2379
q22 345 305 316 305
Total cold run time: 107383 ms
Total hot run time: 38625 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4995 5040 4932 4932
q2 341 233 237 233
q3 3293 3294 3308 3294
q4 2124 2008 2032 2008
q5 5791 5804 5768 5768
q6 203 118 120 118
q7 2313 1894 1905 1894
q8 3384 3425 3481 3425
q9 8739 8750 8691 8691
q10 3767 3845 3842 3842
q11 544 436 436 436
q12 801 628 620 620
q13 7699 3182 3191 3182
q14 295 267 261 261
q15 544 505 508 505
q16 546 507 521 507
q17 1866 1882 1867 1867
q18 8653 8301 8204 8204
q19 1668 1636 1629 1629
q20 2217 1946 1958 1946
q21 5636 5278 5308 5278
q22 496 477 469 469
Total cold run time: 65915 ms
Total hot run time: 59109 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880478190
<details>
<summary>TPC-DS: <b>Total hot run time: 182979 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 d8119a0983f5134a0f97bcedfce508872991f6fe, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 937 336 336 336
query2 6559 2053 1963 1963
query3 6719 228 224 224
query4 27194 22385 22499 22385
query5 6038 586 611 586
query6 343 208 226 208
query7 4640 311 305 305
query8 261 220 225 220
query9 8713 2962 2964 2962
query10 557 335 311 311
query11 16166 15615 15856 15615
query12 162 98 107 98
query13 1710 365 349 349
query14 13433 7559 7559 7559
query15 260 249 212 212
query16 6250 346 328 328
query17 1706 512 489 489
query18 1950 307 301 301
query19 215 165 149 149
query20 110 102 101 101
query21 185 93 98 93
query22 5001 4903 4760 4760
query23 32089 31020 31511 31020
query24 12204 2913 2943 2913
query25 608 363 367 363
query26 1790 168 181 168
query27 2960 316 308 308
query28 7044 2180 2171 2171
query29 2160 422 408 408
query30 290 144 147 144
query31 1021 821 848 821
query32 130 88 80 80
query33 826 342 308 308
query34 867 466 468 466
query35 997 861 830 830
query36 1352 1263 1342 1263
query37 197 90 87 87
query38 3536 3391 3368 3368
query39 1350 1293 1295 1293
query40 301 87 88 87
query41 41 41 37 37
query42 115 104 105 104
query43 562 555 525 525
query44 1256 796 799 796
query45 209 198 208 198
query46 1052 704 703 703
query47 1785 1596 1579 1579
query48 385 291 294 291
query49 1206 306 308 306
query50 731 334 337 334
query51 5511 5259 5234 5234
query52 105 104 91 91
query53 231 167 167 167
query54 1409 658 645 645
query55 104 102 95 95
query56 303 249 240 240
query57 1072 984 1011 984
query58 314 280 273 273
query59 3124 2880 2987 2880
query60 369 308 292 292
query61 145 147 146 146
query62 591 471 485 471
query63 194 161 171 161
query64 5941 1714 1745 1714
query65 3422 3371 3346 3346
query66 1356 385 375 375
query67 15638 14966 15589 14966
query68 16188 545 569 545
query69 607 318 315 315
query70 2325 1509 1624 1509
query71 608 288 292 288
query72 5328 3448 3461 3448
query73 4077 347 330 330
query74 7181 6476 6544 6476
query75 6207 2302 2279 2279
query76 6557 1031 1279 1031
query77 1227 319 338 319
query78 9112 8522 8504 8504
query79 2712 512 528 512
query80 704 349 339 339
query81 514 230 211 211
query82 232 114 113 113
query83 358 147 142 142
query84 257 54 57 54
query85 741 278 272 272
query86 425 433 392 392
query87 3662 3477 3427 3427
query88 3205 2474 2432 2432
query89 398 284 287 284
query90 2307 252 250 250
query91 126 94 95 94
query92 89 66 67 66
query93 1515 499 431 431
query94 1078 252 221 221
query95 608 527 495 495
query96 637 341 334 334
query97 4425 4189 4257 4189
query98 233 230 215 215
query99 1159 857 863 857
Total cold run time: 310804 ms
Total hot run time: 182979 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880510755
<details>
<summary>TPC-DS: <b>Total hot run time: 183619 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 6f2ec5a87ed964d4ec35360ebe4114fae543af3a, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 958 343 330 330
query2 6559 2017 1921 1921
query3 6718 224 228 224
query4 25255 22563 22428 22428
query5 6053 607 647 607
query6 352 203 208 203
query7 4641 305 307 305
query8 247 219 227 219
query9 8753 2971 2981 2971
query10 564 303 314 303
query11 16268 15321 15563 15321
query12 160 94 100 94
query13 1695 345 351 345
query14 12463 7580 7558 7558
query15 267 227 213 213
query16 6383 334 325 325
query17 1709 529 521 521
query18 1968 300 301 300
query19 244 160 158 158
query20 107 95 105 95
query21 190 91 98 91
query22 5089 4704 4906 4704
query23 32521 31132 31040 31040
query24 10977 2949 2892 2892
query25 606 348 361 348
query26 1570 171 175 171
query27 2751 320 308 308
query28 6779 2184 2191 2184
query29 1414 418 396 396
query30 283 148 146 146
query31 1024 811 823 811
query32 137 82 89 82
query33 830 360 337 337
query34 860 458 488 458
query35 994 898 878 878
query36 1340 1263 1261 1261
query37 122 82 88 82
query38 3568 3392 3391 3391
query39 1348 1316 1302 1302
query40 188 90 89 89
query41 42 36 38 36
query42 111 102 101 101
query43 555 500 518 500
query44 1193 808 825 808
query45 213 212 203 203
query46 1055 736 732 732
query47 1767 1608 1687 1608
query48 383 302 290 290
query49 1081 312 317 312
query50 793 362 332 332
query51 5412 5336 5263 5263
query52 112 97 94 94
query53 229 170 166 166
query54 1383 671 673 671
query55 107 97 95 95
query56 329 243 256 243
query57 1070 1029 989 989
query58 298 275 286 275
query59 2996 2794 2818 2794
query60 327 296 303 296
query61 153 151 142 142
query62 567 512 483 483
query63 192 174 166 166
query64 5102 1760 1728 1728
query65 3421 3334 3316 3316
query66 1094 383 393 383
query67 15538 15183 15582 15183
query68 13119 571 572 571
query69 627 299 303 299
query70 1685 1533 1539 1533
query71 622 298 270 270
query72 5391 3476 3438 3438
query73 3208 335 344 335
query74 7084 6548 6523 6523
query75 5954 2316 2271 2271
query76 6596 1226 1230 1226
query77 1026 315 337 315
query78 9235 8815 8758 8758
query79 1098 528 553 528
query80 666 338 357 338
query81 496 213 213 213
query82 235 101 108 101
query83 231 142 143 142
query84 248 58 60 58
query85 875 290 269 269
query86 433 441 448 441
query87 3654 3507 3413 3413
query88 2986 2500 2496 2496
query89 368 287 287 287
query90 2054 237 250 237
query91 125 94 94 94
query92 97 71 80 71
query93 1278 436 500 436
query94 1062 248 246 246
query95 594 510 507 507
query96 640 332 331 331
query97 4353 4278 4207 4207
query98 237 221 212 212
query99 1179 886 832 832
Total cold run time: 296934 ms
Total hot run time: 183619 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874996546
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.59 seconds
stream load tsv: 563 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.2 seconds inserted 10000000 Rows, about 354K ops/s
storage size: 17183310394 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874992689
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5544 5229 5146 5146
q2 390 165 159 159
q3 1466 1239 1135 1135
q4 1114 941 812 812
q5 3169 3147 3158 3147
q6 232 131 131 131
q7 1026 531 500 500
q8 2178 2306 2284 2284
q9 6769 6704 6672 6672
q10 3206 3136 3114 3114
q11 350 222 211 211
q12 388 242 233 233
q13 4389 3644 3662 3644
q14 254 224 209 209
q15 605 541 538 538
q16 458 412 425 412
q17 1055 607 558 558
q18 7090 6778 6941 6778
q19 1650 1540 1473 1473
q20 580 337 322 322
q21 2920 2487 2526 2487
q22 390 314 312 312
Total cold run time: 45223 ms
Total hot run time: 40277 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5092 5070 5133 5070
q2 333 247 279 247
q3 3359 3353 3280 3280
q4 2136 2024 2002 2002
q5 5930 5895 5927 5895
q6 227 125 128 125
q7 2412 1911 1876 1876
q8 3569 3664 3667 3664
q9 9042 8974 8997 8974
q10 3890 3912 3918 3912
q11 595 469 496 469
q12 786 634 646 634
q13 3874 3200 3186 3186
q14 303 282 259 259
q15 613 546 543 543
q16 551 524 539 524
q17 2024 1799 1795 1795
q18 8720 8433 8434 8433
q19 1751 1710 1690 1690
q20 2350 1972 1987 1972
q21 5732 5311 5358 5311
q22 564 510 492 492
Total cold run time: 63853 ms
Total hot run time: 60353 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876898695
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1878068552
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
------ Round 1 ----------------------------------
q1 17661 5060 5112 5060
q2 2030 155 138 138
q3 10555 1052 1143 1052
q4 10185 742 762 742
q5 7770 2966 2924 2924
q6 215 131 131 131
q7 898 501 540 501
q8 9234 1983 2020 1983
q9 6810 6330 6382 6330
q10 8199 3049 3036 3036
q11 424 216 222 216
q12 379 229 226 226
q13 18004 3615 3644 3615
q14 237 217 201 201
q15 565 517 511 511
q16 466 415 379 379
q17 953 472 522 472
q18 7199 6686 6641 6641
q19 1561 1379 1439 1379
q20 686 332 346 332
q21 2782 2311 2324 2311
q22 382 315 325 315
Total cold run time: 107195 ms
Total hot run time: 38495 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5135 5048 5103 5048
q2 332 228 247 228
q3 3317 3286 3268 3268
q4 2123 1990 1987 1987
q5 5777 5754 5772 5754
q6 216 124 124 124
q7 2336 1951 1895 1895
q8 3341 3422 3421 3421
q9 8788 8706 8718 8706
q10 3811 3821 3867 3821
q11 577 485 469 469
q12 798 610 648 610
q13 6858 3239 3181 3181
q14 297 266 275 266
q15 575 520 524 520
q16 555 482 483 482
q17 1895 1773 1770 1770
q18 8703 8290 8211 8211
q19 1599 1550 1570 1550
q20 2193 1979 1941 1941
q21 5560 5254 5178 5178
q22 520 486 496 486
Total cold run time: 65306 ms
Total hot run time: 58916 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875703999
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.57 seconds
stream load tsv: 570 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.5 seconds inserted 10000000 Rows, about 350K ops/s
storage size: 17183908316 Bytes
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875686838
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5507 5091 5102 5091
q2 385 161 159 159
q3 1463 1154 1236 1154
q4 1078 793 785 785
q5 3140 3055 3075 3055
q6 230 140 136 136
q7 1000 554 507 507
q8 2153 2230 2275 2230
q9 6711 6647 6674 6647
q10 3202 3154 3146 3146
q11 332 226 207 207
q12 383 230 230 230
q13 4413 3649 3637 3637
q14 262 221 218 218
q15 582 528 535 528
q16 456 410 395 395
q17 1046 569 531 531
q18 7080 6731 6748 6731
q19 1643 1550 1422 1422
q20 540 317 334 317
q21 2904 2429 2486 2429
q22 396 309 338 309
Total cold run time: 44906 ms
Total hot run time: 39864 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5129 5119 5081 5081
q2 341 228 236 228
q3 3375 3352 3304 3304
q4 2150 2048 2026 2026
q5 5967 5959 5949 5949
q6 228 127 132 127
q7 2395 1930 1909 1909
q8 3561 3669 3674 3669
q9 9086 9034 9023 9023
q10 3858 3891 3895 3891
q11 580 484 480 480
q12 804 639 637 637
q13 3859 3211 3182 3182
q14 292 271 275 271
q15 588 536 528 528
q16 568 504 501 501
q17 2006 1828 1843 1828
q18 8733 8370 8609 8370
q19 1746 1701 1666 1666
q20 2259 1997 1961 1961
q21 5894 5382 5265 5265
q22 560 524 478 478
Total cold run time: 63979 ms
Total hot run time: 60374 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876274348
run buidall
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1874986490
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 876 359 339 339
query2 4753 1973 1913 1913
query3 5028 210 198 198
query4 26594 22466 22370 22370
query5 3927 540 507 507
query6 251 190 183 183
query7 4084 270 274 270
query8 242 215 200 200
query9 7652 2594 2550 2550
query10 391 242 244 242
query11 16184 15636 15509 15509
query12 130 83 83 83
query13 1542 343 340 340
query14 11005 7208 7169 7169
query15 244 187 188 187
query16 6143 280 270 270
query17 1615 491 492 491
query18 1814 272 256 256
query19 200 144 137 137
query20 84 74 80 74
query21 180 99 95 95
query22 4899 4555 4717 4555
query23 32071 31136 31160 31136
query24 11133 2831 2783 2783
query25 589 346 339 339
query26 1579 148 148 148
query27 2777 280 278 278
query28 6777 1974 1972 1972
query29 1856 387 396 387
query30 275 144 145 144
query31 991 766 769 766
query32 89 59 57 57
query33 693 271 272 271
query34 850 450 440 440
query35 891 780 775 775
query36 1364 1178 1202 1178
query37 166 72 73 72
query38 3374 3304 3282 3282
query39 1321 1281 1263 1263
query40 287 93 92 92
query41 38 36 37 36
query42 97 90 92 90
query43 530 499 481 481
query44 1048 704 718 704
query45 196 190 181 181
query46 1049 654 645 645
query47 1688 1517 1481 1481
query48 341 270 261 261
query49 1045 327 323 323
query50 742 324 323 323
query51 5336 5233 5289 5233
query52 100 88 88 88
query53 217 152 156 152
query54 1330 580 590 580
query55 101 86 87 86
query56 216 202 201 201
query57 1026 976 979 976
query58 225 199 198 198
query59 2759 2569 2564 2564
query60 258 237 251 237
query61 87 83 83 83
query62 634 488 456 456
query63 164 151 149 149
query64 5433 1688 1707 1688
query65 3359 3272 3274 3272
query66 1392 337 326 326
query67 15706 15199 15256 15199
query68 11472 532 521 521
query69 511 252 252 252
query70 1754 1527 1542 1527
query71 475 224 225 224
query72 5671 3578 3543 3543
query73 2283 314 315 314
query74 6942 6520 6433 6433
query75 4839 2299 2289 2289
query76 6152 1137 1152 1137
query77 681 268 275 268
query78 9103 8799 8619 8619
query79 1071 514 496 496
query80 544 369 362 362
query81 457 211 215 211
query82 216 105 102 102
query83 155 139 133 133
query84 235 53 62 53
query85 898 275 272 272
query86 376 368 383 368
query87 3527 3449 3365 3365
query88 3077 2256 2280 2256
query89 339 254 268 254
query90 1897 213 206 206
query91 115 86 96 86
query92 60 52 51 51
query93 1805 487 495 487
query94 795 191 186 186
query95 465 414 421 414
query96 620 318 319 318
query97 4269 4168 4170 4168
query98 200 191 190 190
query99 1094 835 807 807
Total cold run time: 282136 ms
Total hot run time: 179246 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875685859
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
------ Round 1 ----------------------------------
q1 17637 5435 5172 5172
q2 2025 161 146 146
q3 10612 1108 1175 1108
q4 10288 746 877 746
q5 7809 2947 2849 2849
q6 219 138 137 137
q7 937 519 546 519
q8 9323 2037 2062 2037
q9 6859 6425 6419 6419
q10 8287 3069 3026 3026
q11 431 216 211 211
q12 388 232 236 232
q13 18008 3670 3641 3641
q14 247 219 213 213
q15 566 528 525 525
q16 454 433 401 401
q17 965 523 479 479
q18 7479 6764 6712 6712
q19 1603 1361 1378 1361
q20 718 328 338 328
q21 2820 2403 2443 2403
q22 382 327 332 327
Total cold run time: 108057 ms
Total hot run time: 38992 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5156 5187 5131 5131
q2 347 233 239 233
q3 3314 3304 3284 3284
q4 2114 2012 2051 2012
q5 5848 5800 5809 5800
q6 217 124 129 124
q7 2338 1964 1946 1946
q8 3396 3470 3488 3470
q9 8832 8803 8796 8796
q10 3821 3870 3883 3870
q11 580 492 476 476
q12 796 657 639 639
q13 8118 3213 3191 3191
q14 294 258 280 258
q15 591 521 517 517
q16 567 503 514 503
q17 1940 1779 1784 1779
q18 8681 8441 8252 8252
q19 1632 1596 1584 1584
q20 2194 1956 1948 1948
q21 5711 5249 5269 5249
q22 537 458 525 458
Total cold run time: 67024 ms
Total hot run time: 59520 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #29453:
URL: https://github.com/apache/doris/pull/29453#discussion_r1441386808
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,7 +228,18 @@ public void analyzeQuery(ConnectContext ctx) {
}
getRelation(planner);
getColumns(plan);
- analyzePartition(planner);
+ SessionVariable sessionVariable = statementContext.getConnectContext().getSessionVariable();
+ Set<String> tempDisableRules = sessionVariable.getDisableNereidsRuleNames();
+ // Should not make table without data to empty relation, so add disable rules
+ sessionVariable.setDisableNereidsRules(MTMV_PLANER_DISABLE_RULES);
+ try {
+ analyzePartition(planner);
+ } finally {
+ if (!tempDisableRules.isEmpty()) {
Review Comment:
should not add this `if`, always set back
--
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1877453202
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5516 5084 5098 5084
q2 389 156 168 156
q3 1467 1126 1134 1126
q4 1087 813 823 813
q5 3157 3149 3189 3149
q6 219 135 133 133
q7 944 567 515 515
q8 2156 2308 2392 2308
q9 6713 6694 6682 6682
q10 3166 3120 3173 3120
q11 348 228 211 211
q12 378 233 229 229
q13 4386 3641 3658 3641
q14 254 218 214 214
q15 580 533 535 533
q16 465 408 393 393
q17 1055 536 520 520
q18 7057 6711 6977 6711
q19 1645 1503 1559 1503
q20 564 346 347 346
q21 2858 2472 2507 2472
q22 404 322 329 322
Total cold run time: 44808 ms
Total hot run time: 40181 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5093 5105 5083 5083
q2 352 230 230 230
q3 3361 3344 3324 3324
q4 2172 2062 2054 2054
q5 5946 5927 5944 5927
q6 224 127 129 127
q7 2405 1920 1945 1920
q8 3552 3672 3698 3672
q9 9074 9050 9034 9034
q10 3903 3918 3947 3918
q11 578 489 479 479
q12 807 625 647 625
q13 3846 3175 3166 3166
q14 290 269 281 269
q15 595 532 529 529
q16 569 495 492 492
q17 2020 1838 1826 1826
q18 8735 8381 8390 8381
q19 1747 1667 1705 1667
q20 2259 1983 1967 1967
q21 5813 5347 5326 5326
q22 541 472 467 467
Total cold run time: 63882 ms
Total hot run time: 60483 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1877469467
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
------ Round 1 ----------------------------------
q1 17656 5127 5047 5047
q2 2029 151 139 139
q3 10565 1018 1061 1018
q4 10176 782 782 782
q5 7793 2881 2860 2860
q6 210 131 131 131
q7 906 565 499 499
q8 9285 1974 1977 1974
q9 6800 6400 6329 6329
q10 8222 3027 3028 3027
q11 417 210 206 206
q12 384 226 226 226
q13 17993 3625 3631 3625
q14 250 209 200 200
q15 558 526 511 511
q16 444 385 393 385
q17 949 487 505 487
q18 7254 6737 6630 6630
q19 1587 1297 1352 1297
q20 704 348 312 312
q21 2804 2333 2399 2333
q22 381 324 338 324
Total cold run time: 107367 ms
Total hot run time: 38342 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5134 4955 5061 4955
q2 338 227 231 227
q3 3274 3287 3263 3263
q4 2128 1986 2011 1986
q5 5801 5768 5762 5762
q6 213 124 125 124
q7 2320 1880 1895 1880
q8 3365 3411 3455 3411
q9 8798 8742 8716 8716
q10 3766 3831 3840 3831
q11 580 468 491 468
q12 788 630 637 630
q13 7533 3239 3159 3159
q14 293 274 262 262
q15 578 521 540 521
q16 524 504 511 504
q17 1936 1754 1746 1746
q18 8568 8369 8213 8213
q19 1624 1569 1550 1550
q20 2182 1967 1919 1919
q21 5552 5265 5199 5199
q22 545 479 462 462
Total cold run time: 65840 ms
Total hot run time: 58788 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880307789
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876270951
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1875278197
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876926740
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
------ Round 1 ----------------------------------
q1 17621 5280 5145 5145
q2 2022 154 148 148
q3 10628 1087 1142 1087
q4 10554 777 830 777
q5 7827 2890 2941 2890
q6 213 130 132 130
q7 917 519 547 519
q8 9296 2011 2006 2006
q9 6861 6391 6397 6391
q10 8241 3049 2981 2981
q11 415 209 217 209
q12 380 233 227 227
q13 18010 3676 3623 3623
q14 241 217 211 211
q15 566 539 507 507
q16 461 410 410 410
q17 973 471 524 471
q18 7449 6760 6725 6725
q19 1596 1339 1317 1317
q20 722 357 340 340
q21 2796 2330 2391 2330
q22 382 315 330 315
Total cold run time: 108171 ms
Total hot run time: 38759 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5131 5095 5130 5095
q2 337 237 237 237
q3 3335 3299 3283 3283
q4 2119 2033 1995 1995
q5 5840 5804 5839 5804
q6 217 125 126 125
q7 2338 1935 1954 1935
q8 3389 3469 3451 3451
q9 8886 8800 8760 8760
q10 3825 3833 3867 3833
q11 575 487 484 484
q12 801 632 650 632
q13 8301 3210 3181 3181
q14 306 268 280 268
q15 582 510 521 510
q16 552 508 504 504
q17 1955 1776 1777 1776
q18 8655 8355 8234 8234
q19 1622 1590 1619 1590
q20 2189 1954 1927 1927
q21 5644 5224 5274 5224
q22 547 485 458 458
Total cold run time: 67146 ms
Total hot run time: 59306 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880483113
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880495956
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1880499828
<details>
<summary>TPC-H: <b>Total hot run time: 38549 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 6f2ec5a87ed964d4ec35360ebe4114fae543af3a, data reload: false
------ Round 1 ----------------------------------
q1 12747 4941 4944 4941
q2 406 151 148 148
q3 1398 1192 1161 1161
q4 1037 819 755 755
q5 2930 3054 2984 2984
q6 231 126 134 126
q7 917 508 481 481
q8 1919 2008 1995 1995
q9 6395 6399 6352 6352
q10 3079 3011 2969 2969
q11 329 213 211 211
q12 373 226 228 226
q13 4117 3383 3369 3369
q14 241 221 215 215
q15 546 512 500 500
q16 439 404 385 385
q17 917 709 611 611
q18 7140 6765 6635 6635
q19 1496 1520 1513 1513
q20 570 300 301 300
q21 2643 2425 2368 2368
q22 373 304 321 304
Total cold run time: 50243 ms
Total hot run time: 38549 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4891 4921 4908 4908
q2 342 231 233 231
q3 3286 3309 3263 3263
q4 2118 2012 1997 1997
q5 5796 5781 5767 5767
q6 206 115 116 115
q7 2333 1904 1928 1904
q8 3369 3412 3464 3412
q9 8737 8698 8700 8698
q10 3819 3860 3821 3821
q11 545 429 433 429
q12 789 635 623 623
q13 3836 3170 3196 3170
q14 291 255 248 248
q15 543 512 496 496
q16 538 500 489 489
q17 1842 1833 1841 1833
q18 8554 8225 8177 8177
q19 1598 1618 1620 1618
q20 2184 1953 1936 1936
q21 5619 5285 5260 5260
q22 544 442 451 442
Total cold run time: 61780 ms
Total hot run time: 58837 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1878063701
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5480 5135 5123 5123
q2 393 162 159 159
q3 1463 1232 1195 1195
q4 1087 752 775 752
q5 3126 3111 3107 3107
q6 221 131 132 131
q7 968 555 514 514
q8 2176 2305 2256 2256
q9 6715 6715 6654 6654
q10 3191 3175 3129 3129
q11 336 230 217 217
q12 385 234 234 234
q13 4401 3644 3617 3617
q14 243 213 207 207
q15 570 539 533 533
q16 463 387 411 387
q17 1050 514 648 514
q18 7141 6804 6749 6749
q19 1661 1490 1423 1423
q20 603 347 319 319
q21 2855 2490 2430 2430
q22 383 336 334 334
Total cold run time: 44911 ms
Total hot run time: 39984 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5089 5132 5072 5072
q2 337 229 229 229
q3 3346 3323 3315 3315
q4 2159 2060 2047 2047
q5 5934 5922 5921 5921
q6 223 125 127 125
q7 2392 1938 1930 1930
q8 3564 3660 3686 3660
q9 9046 9048 8996 8996
q10 3854 3905 3930 3905
q11 583 496 490 490
q12 795 618 628 618
q13 3882 3202 3203 3202
q14 292 266 270 266
q15 589 535 521 521
q16 561 499 492 492
q17 2034 1798 1824 1798
q18 8715 8446 8310 8310
q19 1767 1725 1699 1699
q20 2275 2012 1957 1957
q21 5834 5424 5369 5369
q22 549 458 533 458
Total cold run time: 63820 ms
Total hot run time: 60380 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-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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876844525
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29453:
URL: https://github.com/apache/doris/pull/29453#issuecomment-1876940777
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 923 353 338 338
query2 6409 2072 1871 1871
query3 6646 219 204 204
query4 26114 22531 22371 22371
query5 4441 522 505 505
query6 287 182 192 182
query7 4584 272 265 265
query8 231 214 189 189
query9 8234 2507 2488 2488
query10 385 245 250 245
query11 16227 15492 15519 15492
query12 131 73 77 73
query13 1633 318 316 316
query14 11317 7163 7152 7152
query15 224 189 196 189
query16 6378 267 253 253
query17 1870 489 486 486
query18 1944 273 260 260
query19 203 136 133 133
query20 81 75 75 75
query21 189 107 95 95
query22 5098 4866 4817 4817
query23 32018 31291 31375 31291
query24 12063 2822 2785 2785
query25 601 342 333 333
query26 1741 137 135 135
query27 2920 278 270 270
query28 6878 1863 1851 1851
query29 1992 394 391 391
query30 285 139 149 139
query31 989 763 781 763
query32 88 59 54 54
query33 721 246 261 246
query34 920 447 441 441
query35 856 782 767 767
query36 1343 1182 1259 1182
query37 186 63 64 63
query38 3422 3300 3260 3260
query39 1339 1279 1281 1279
query40 303 86 88 86
query41 37 35 35 35
query42 97 90 83 83
query43 537 506 483 483
query44 1121 680 695 680
query45 193 184 186 184
query46 1054 649 636 636
query47 1631 1547 1522 1522
query48 323 253 247 247
query49 1222 310 312 310
query50 736 309 324 309
query51 5469 5410 5262 5262
query52 101 79 88 79
query53 203 153 145 145
query54 1354 554 549 549
query55 89 85 84 84
query56 194 174 193 174
query57 1061 926 954 926
query58 216 192 199 192
query59 2772 2634 2586 2586
query60 230 204 215 204
query61 84 88 81 81
query62 633 465 460 460
query63 172 146 143 143
query64 5735 1701 1708 1701
query65 3332 3222 3275 3222
query66 1396 346 333 333
query67 15916 15488 15013 15013
query68 12290 522 532 522
query69 497 249 236 236
query70 1654 1449 1481 1449
query71 495 219 217 217
query72 5608 3523 3507 3507
query73 2826 312 306 306
query74 7055 6547 6468 6468
query75 5203 2329 2300 2300
query76 6294 1122 1079 1079
query77 674 288 262 262
query78 9114 8821 8524 8524
query79 1044 506 503 503
query80 569 336 334 334
query81 456 208 207 207
query82 214 97 86 86
query83 157 139 134 134
query84 242 53 51 51
query85 963 260 263 260
query86 398 390 417 390
query87 3553 3429 3365 3365
query88 3142 2231 2244 2231
query89 319 254 246 246
query90 1947 192 195 192
query91 116 90 91 90
query92 59 49 51 49
query93 1892 485 424 424
query94 836 178 176 176
query95 445 422 405 405
query96 633 321 315 315
query97 4264 4160 4157 4157
query98 221 192 190 190
query99 1136 816 881 816
Total cold run time: 292438 ms
Total hot run time: 178469 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-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