You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/09/02 15:03:58 UTC
[PR] [opt](Nereids) add show statement syntax [doris]
morrySnow opened a new pull request, #40288:
URL: https://github.com/apache/doris/pull/40288
(no comment)
--
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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2324948115
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-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] [opt](Nereids) add show statement syntax [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2326162378
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] [opt](Nereids) add show statement syntax [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325700773
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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325591776
<details>
<summary>TPC-DS: <b>Total hot run time: 192434 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 6f930fc6e167b26c05937d6ca096248d9f456e4c, data reload: false
query1 1253 895 863 863
query2 6325 2012 1948 1948
query3 10609 4011 4026 4011
query4 59428 24604 23328 23328
query5 5650 513 506 506
query6 420 158 162 158
query7 5861 286 288 286
query8 306 201 216 201
query9 8985 2459 2438 2438
query10 482 275 257 257
query11 17939 15117 15394 15117
query12 156 101 105 101
query13 1538 387 385 385
query14 10588 7379 7152 7152
query15 239 175 183 175
query16 7185 479 474 474
query17 1150 596 577 577
query18 1928 328 295 295
query19 290 162 147 147
query20 118 105 104 104
query21 208 104 102 102
query22 4586 4395 4548 4395
query23 34492 33389 33310 33310
query24 5925 2911 2831 2831
query25 529 373 390 373
query26 685 154 153 153
query27 1799 279 269 269
query28 3830 2025 2023 2023
query29 641 403 404 403
query30 245 158 160 158
query31 939 768 779 768
query32 81 49 51 49
query33 415 279 276 276
query34 849 466 479 466
query35 847 716 731 716
query36 1067 907 911 907
query37 150 94 88 88
query38 3983 3936 3953 3936
query39 1443 1383 1393 1383
query40 197 117 112 112
query41 47 49 44 44
query42 118 92 92 92
query43 520 461 466 461
query44 1064 720 727 720
query45 188 160 165 160
query46 1091 777 721 721
query47 1925 1835 1822 1822
query48 358 296 296 296
query49 757 430 420 420
query50 812 413 409 409
query51 7021 6897 6932 6897
query52 96 84 88 84
query53 245 181 176 176
query54 559 453 453 453
query55 76 70 74 70
query56 269 253 250 250
query57 1210 1100 1062 1062
query58 222 222 243 222
query59 3122 2935 2792 2792
query60 311 266 297 266
query61 104 102 106 102
query62 754 647 645 645
query63 211 176 181 176
query64 2780 691 668 668
query65 3212 3149 3172 3149
query66 704 338 355 338
query67 15517 15296 15117 15117
query68 2947 573 574 573
query69 404 289 306 289
query70 1109 1008 1029 1008
query71 348 274 276 274
query72 4978 4100 4132 4100
query73 747 330 321 321
query74 9035 8910 8912 8910
query75 3360 2629 2687 2629
query76 1403 951 1009 951
query77 528 308 318 308
query78 11436 9432 8933 8933
query79 1052 521 524 521
query80 690 510 506 506
query81 467 233 237 233
query82 249 146 147 146
query83 176 156 150 150
query84 260 74 78 74
query85 679 291 343 291
query86 311 291 304 291
query87 4463 4260 4363 4260
query88 2946 2327 2328 2327
query89 376 285 278 278
query90 1917 190 183 183
query91 124 99 99 99
query92 57 49 49 49
query93 1043 522 524 522
query94 689 298 290 290
query95 315 254 246 246
query96 590 267 267 267
query97 3201 3088 3091 3088
query98 210 201 201 201
query99 1521 1306 1263 1263
Total cold run time: 304285 ms
Total hot run time: 192434 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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325042126
<details>
<summary>TPC-DS: <b>Total hot run time: 193671 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 50a6b174cd981ee4696cf684e392d93251870018, data reload: false
query1 1251 898 862 862
query2 6313 2077 2000 2000
query3 10628 3999 4171 3999
query4 59489 24653 23339 23339
query5 5483 492 488 488
query6 418 168 161 161
query7 5911 300 294 294
query8 286 213 236 213
query9 9169 2470 2486 2470
query10 493 274 263 263
query11 18129 15055 15413 15055
query12 160 103 108 103
query13 1580 412 373 373
query14 11317 7647 7585 7585
query15 235 175 177 175
query16 7497 473 492 473
query17 1136 584 586 584
query18 2104 299 302 299
query19 294 157 158 157
query20 121 115 113 113
query21 206 110 103 103
query22 4599 4400 4442 4400
query23 34007 33553 33841 33553
query24 5934 2894 2813 2813
query25 521 377 377 377
query26 691 152 153 152
query27 1800 289 275 275
query28 3645 2038 2026 2026
query29 709 437 441 437
query30 238 153 153 153
query31 893 798 792 792
query32 90 55 52 52
query33 435 285 288 285
query34 862 475 481 475
query35 849 738 702 702
query36 1118 949 932 932
query37 148 95 90 90
query38 4001 3917 3862 3862
query39 1442 1417 1402 1402
query40 199 119 116 116
query41 47 48 47 47
query42 110 94 93 93
query43 523 482 483 482
query44 1118 734 744 734
query45 198 165 166 165
query46 1090 761 756 756
query47 1876 1786 1818 1786
query48 368 286 291 286
query49 761 429 447 429
query50 839 409 414 409
query51 6981 6946 6838 6838
query52 105 94 91 91
query53 261 183 182 182
query54 580 480 458 458
query55 79 77 75 75
query56 286 272 278 272
query57 1192 1107 1082 1082
query58 260 243 247 243
query59 3117 2859 3031 2859
query60 293 266 288 266
query61 105 102 99 99
query62 763 615 649 615
query63 215 180 189 180
query64 2847 692 713 692
query65 3269 3189 3142 3142
query66 690 342 335 335
query67 15269 15243 15356 15243
query68 3002 588 591 588
query69 397 287 278 278
query70 1212 1106 1078 1078
query71 353 275 269 269
query72 5341 4154 3964 3964
query73 773 330 331 330
query74 9086 8819 8854 8819
query75 3334 2733 2719 2719
query76 1422 1062 999 999
query77 560 325 320 320
query78 9551 9093 9623 9093
query79 1058 560 526 526
query80 711 522 532 522
query81 469 242 243 242
query82 247 146 149 146
query83 174 152 154 152
query84 251 79 83 79
query85 742 313 294 294
query86 297 310 282 282
query87 4328 4365 4320 4320
query88 3468 2332 2302 2302
query89 375 287 283 283
query90 1669 196 195 195
query91 125 100 100 100
query92 58 50 50 50
query93 1107 539 549 539
query94 531 293 291 291
query95 342 256 251 251
query96 583 259 262 259
query97 3180 3133 3059 3059
query98 229 195 197 195
query99 1494 1265 1277 1265
Total cold run time: 304112 ms
Total hot run time: 193671 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] [opt](Nereids) add show statement syntax [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2324948273
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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325595817
<details>
<summary>ClickBench: <b>Total hot run time: 32.01 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 6f930fc6e167b26c05937d6ca096248d9f456e4c, data reload: false
query1 0.05 0.05 0.04
query2 0.07 0.04 0.04
query3 0.22 0.05 0.06
query4 1.68 0.08 0.09
query5 0.51 0.48 0.50
query6 1.12 0.74 0.73
query7 0.02 0.02 0.01
query8 0.05 0.05 0.04
query9 0.55 0.48 0.49
query10 0.55 0.55 0.54
query11 0.15 0.11 0.12
query12 0.14 0.11 0.12
query13 0.60 0.60 0.58
query14 2.10 2.05 2.12
query15 0.90 0.84 0.82
query16 0.37 0.38 0.37
query17 1.03 0.98 1.07
query18 0.21 0.21 0.21
query19 1.95 1.70 1.78
query20 0.01 0.01 0.02
query21 15.41 0.66 0.66
query22 4.57 7.43 2.02
query23 18.28 1.32 1.26
query24 2.09 0.25 0.23
query25 0.14 0.08 0.08
query26 0.27 0.19 0.18
query27 0.07 0.08 0.07
query28 13.17 1.05 1.01
query29 12.57 3.30 3.24
query30 0.24 0.06 0.06
query31 2.87 0.40 0.39
query32 3.26 0.48 0.48
query33 2.97 3.00 3.04
query34 17.03 4.41 4.40
query35 4.41 4.46 4.46
query36 0.66 0.49 0.47
query37 0.19 0.15 0.16
query38 0.16 0.14 0.15
query39 0.05 0.04 0.04
query40 0.16 0.12 0.14
query41 0.09 0.05 0.04
query42 0.06 0.04 0.04
query43 0.04 0.04 0.04
Total cold run time: 111.04 s
Total hot run time: 32.01 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] [opt](Nereids) add show statement syntax [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325705887
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] [opt](Nereids) add show statement syntax [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325549651
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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325582669
<details>
<summary>TPC-H: <b>Total hot run time: 37823 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 6f930fc6e167b26c05937d6ca096248d9f456e4c, data reload: false
------ Round 1 ----------------------------------
q1 17610 4389 4334 4334
q2 2016 182 174 174
q3 11620 962 1115 962
q4 10501 710 723 710
q5 7766 2813 2703 2703
q6 230 137 137 137
q7 944 621 591 591
q8 9318 2083 2056 2056
q9 7389 6505 6512 6505
q10 7043 2203 2188 2188
q11 460 246 239 239
q12 389 223 224 223
q13 18668 3080 3046 3046
q14 278 236 240 236
q15 531 481 494 481
q16 625 518 509 509
q17 976 801 675 675
q18 7294 6922 6878 6878
q19 1388 1028 950 950
q20 670 346 329 329
q21 3998 3038 2911 2911
q22 1094 1024 986 986
Total cold run time: 110808 ms
Total hot run time: 37823 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4356 4342 4313 4313
q2 380 268 276 268
q3 2901 2675 2630 2630
q4 1885 1647 1630 1630
q5 5641 5697 5715 5697
q6 228 137 135 135
q7 2261 1842 1851 1842
q8 3318 3458 3492 3458
q9 8879 8713 8775 8713
q10 3549 3381 3387 3381
q11 621 509 519 509
q12 801 673 651 651
q13 13462 3162 3321 3162
q14 323 288 290 288
q15 532 500 495 495
q16 614 579 552 552
q17 1829 1552 1547 1547
q18 8199 7855 7965 7855
q19 1732 1492 1562 1492
q20 2159 1940 1907 1907
q21 5892 5465 5451 5451
q22 1109 1060 1026 1026
Total cold run time: 70671 ms
Total hot run time: 57002 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] [opt](Nereids) add show statement syntax [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #40288:
URL: https://github.com/apache/doris/pull/40288
--
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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325844448
<details>
<summary>TPC-DS: <b>Total hot run time: 192317 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 042a585879058c5414220ef94c18fd0b161c3587, data reload: false
query1 1250 869 869 869
query2 6389 2066 2019 2019
query3 10630 3979 3722 3722
query4 59474 26412 23171 23171
query5 5431 495 498 495
query6 404 157 153 153
query7 5770 303 293 293
query8 292 214 207 207
query9 8845 2448 2443 2443
query10 487 268 263 263
query11 17665 15005 15388 15005
query12 171 103 103 103
query13 1528 401 396 396
query14 11194 7261 7384 7261
query15 250 187 190 187
query16 7506 465 412 412
query17 1100 589 620 589
query18 1910 295 307 295
query19 300 156 151 151
query20 130 112 120 112
query21 213 104 105 104
query22 4648 4713 4417 4417
query23 34092 33549 33412 33412
query24 5946 2837 2820 2820
query25 546 405 400 400
query26 677 156 154 154
query27 1778 283 281 281
query28 3603 2053 2016 2016
query29 678 429 432 429
query30 235 151 150 150
query31 916 762 793 762
query32 78 63 52 52
query33 479 295 301 295
query34 866 492 469 469
query35 854 710 738 710
query36 1039 970 949 949
query37 150 93 97 93
query38 3964 3906 3861 3861
query39 1437 1411 1383 1383
query40 205 121 115 115
query41 48 48 47 47
query42 113 94 93 93
query43 519 482 483 482
query44 1103 732 742 732
query45 198 169 165 165
query46 1090 733 749 733
query47 1904 1801 1864 1801
query48 377 293 299 293
query49 779 435 431 431
query50 817 415 422 415
query51 7028 6936 6744 6744
query52 100 89 90 89
query53 260 180 181 180
query54 573 472 458 458
query55 81 78 79 78
query56 290 269 272 269
query57 1215 1075 1069 1069
query58 226 245 225 225
query59 3066 2988 2913 2913
query60 297 266 289 266
query61 104 104 96 96
query62 782 647 642 642
query63 218 184 192 184
query64 2740 668 665 665
query65 3214 3141 3190 3141
query66 684 348 335 335
query67 15331 15386 15087 15087
query68 4415 564 547 547
query69 429 284 285 284
query70 1186 1129 1144 1129
query71 369 272 275 272
query72 6584 4007 4021 4007
query73 761 329 324 324
query74 9228 8879 8946 8879
query75 3354 2652 2765 2652
query76 1935 1054 1028 1028
query77 561 318 312 312
query78 10098 9073 9017 9017
query79 1071 545 530 530
query80 834 498 509 498
query81 565 232 233 232
query82 330 140 142 140
query83 255 148 148 148
query84 260 75 79 75
query85 910 284 278 278
query86 343 300 296 296
query87 4411 4202 4359 4202
query88 3069 2323 2335 2323
query89 385 286 281 281
query90 2046 195 190 190
query91 125 101 102 101
query92 60 51 51 51
query93 1240 517 522 517
query94 766 309 294 294
query95 341 252 259 252
query96 588 267 262 262
query97 3242 3063 3082 3063
query98 223 209 200 200
query99 1556 1282 1289 1282
Total cold run time: 307827 ms
Total hot run time: 192317 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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325025281
<details>
<summary>TPC-H: <b>Total hot run time: 37550 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 50a6b174cd981ee4696cf684e392d93251870018, data reload: false
------ Round 1 ----------------------------------
q1 17613 5173 4311 4311
q2 2020 184 181 181
q3 11654 966 1065 966
q4 10516 729 681 681
q5 7773 2811 2840 2811
q6 227 137 135 135
q7 955 609 604 604
q8 9318 2037 2052 2037
q9 7311 6539 6495 6495
q10 6995 2287 2132 2132
q11 464 236 237 236
q12 393 221 221 221
q13 17766 3047 3025 3025
q14 273 235 234 234
q15 538 508 496 496
q16 596 505 496 496
q17 977 701 763 701
q18 7278 6898 6790 6790
q19 1393 1040 972 972
q20 692 328 327 327
q21 4125 2765 2708 2708
q22 1058 1007 991 991
Total cold run time: 109935 ms
Total hot run time: 37550 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4334 4298 4272 4272
q2 387 281 273 273
q3 2806 2666 2644 2644
q4 1925 1608 1631 1608
q5 5573 5628 5675 5628
q6 230 137 145 137
q7 2254 1839 1839 1839
q8 3279 3403 3473 3403
q9 8880 8867 8802 8802
q10 3545 3378 3352 3352
q11 628 499 512 499
q12 827 661 653 653
q13 14839 3242 3252 3242
q14 321 300 280 280
q15 532 505 489 489
q16 648 590 584 584
q17 1834 1524 1529 1524
q18 8029 7699 7729 7699
q19 1733 1604 1513 1513
q20 2141 1910 1907 1907
q21 5767 5393 5481 5393
q22 1116 1011 1002 1002
Total cold run time: 71628 ms
Total hot run time: 56743 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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325855500
<details>
<summary>ClickBench: <b>Total hot run time: 32.08 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 042a585879058c5414220ef94c18fd0b161c3587, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.08 0.07
query5 0.49 0.50 0.49
query6 1.12 0.74 0.73
query7 0.02 0.01 0.01
query8 0.04 0.04 0.04
query9 0.54 0.49 0.49
query10 0.54 0.54 0.53
query11 0.15 0.12 0.12
query12 0.15 0.12 0.12
query13 0.61 0.58 0.58
query14 2.03 2.06 2.06
query15 0.84 0.82 0.81
query16 0.39 0.38 0.37
query17 1.06 1.05 0.96
query18 0.21 0.20 0.20
query19 1.96 1.71 1.79
query20 0.01 0.01 0.01
query21 15.41 0.65 0.66
query22 4.46 6.73 2.22
query23 18.20 1.36 1.25
query24 2.11 0.21 0.22
query25 0.16 0.08 0.08
query26 0.28 0.18 0.19
query27 0.08 0.08 0.08
query28 13.44 1.02 1.01
query29 12.91 3.28 3.28
query30 0.24 0.05 0.05
query31 2.89 0.41 0.38
query32 3.24 0.48 0.48
query33 2.93 2.98 3.06
query34 17.09 4.37 4.35
query35 4.42 4.40 4.41
query36 0.66 0.47 0.46
query37 0.18 0.16 0.16
query38 0.15 0.15 0.14
query39 0.05 0.04 0.05
query40 0.15 0.12 0.12
query41 0.09 0.06 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 111.44 s
Total hot run time: 32.08 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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325049254
<details>
<summary>ClickBench: <b>Total hot run time: 32.19 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 50a6b174cd981ee4696cf684e392d93251870018, data reload: false
query1 0.04 0.04 0.04
query2 0.07 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.07 0.07
query5 0.51 0.49 0.50
query6 1.12 0.73 0.74
query7 0.02 0.01 0.01
query8 0.06 0.04 0.05
query9 0.54 0.49 0.49
query10 0.54 0.55 0.54
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.60 0.58 0.59
query14 2.08 2.03 2.10
query15 0.90 0.85 0.82
query16 0.35 0.37 0.38
query17 0.98 1.06 1.02
query18 0.22 0.21 0.20
query19 1.95 1.85 1.83
query20 0.01 0.01 0.02
query21 15.39 0.66 0.67
query22 4.15 7.39 2.03
query23 18.28 1.34 1.42
query24 2.09 0.24 0.22
query25 0.17 0.08 0.08
query26 0.27 0.18 0.17
query27 0.07 0.08 0.08
query28 13.20 1.02 1.00
query29 12.68 3.31 3.25
query30 0.23 0.06 0.05
query31 2.89 0.40 0.38
query32 3.26 0.48 0.47
query33 3.09 3.00 2.99
query34 17.25 4.42 4.40
query35 4.43 4.45 4.41
query36 0.66 0.49 0.50
query37 0.18 0.15 0.17
query38 0.15 0.14 0.15
query39 0.04 0.03 0.04
query40 0.16 0.13 0.12
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 111.04 s
Total hot run time: 32.19 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] [opt](Nereids) add show statement syntax [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2325821890
<details>
<summary>TPC-H: <b>Total hot run time: 38125 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 042a585879058c5414220ef94c18fd0b161c3587, data reload: false
------ Round 1 ----------------------------------
q1 17603 5107 4315 4315
q2 2024 181 177 177
q3 11763 964 1072 964
q4 10520 682 680 680
q5 7744 2834 2880 2834
q6 230 140 143 140
q7 967 618 611 611
q8 9334 2120 2122 2120
q9 7317 6529 6527 6527
q10 6991 2193 2173 2173
q11 455 246 245 245
q12 404 225 225 225
q13 17849 3095 3070 3070
q14 278 238 233 233
q15 539 504 487 487
q16 592 515 523 515
q17 1004 714 700 700
q18 7280 6810 6862 6810
q19 1392 1029 1025 1025
q20 688 329 345 329
q21 4317 3074 2929 2929
q22 1129 1025 1016 1016
Total cold run time: 110420 ms
Total hot run time: 38125 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4368 4279 4293 4279
q2 371 273 278 273
q3 2842 2643 2645 2643
q4 1901 1673 1668 1668
q5 5674 5700 5801 5700
q6 228 134 139 134
q7 2277 1861 1825 1825
q8 3310 3479 3480 3479
q9 8944 8786 8779 8779
q10 3604 3380 3352 3352
q11 596 510 498 498
q12 823 665 661 661
q13 15745 3268 3241 3241
q14 322 284 288 284
q15 540 490 510 490
q16 626 574 608 574
q17 1849 1558 1577 1558
q18 8109 7900 7929 7900
q19 1737 1707 1634 1634
q20 2204 1894 1965 1894
q21 5904 5525 5287 5287
q22 1137 1031 1109 1031
Total cold run time: 73111 ms
Total hot run time: 57184 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] [opt](Nereids) add show statement syntax [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40288:
URL: https://github.com/apache/doris/pull/40288#issuecomment-2326162302
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