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/07/09 07:37:55 UTC
[PR] [fix](ctas) keep varchar length not work when enable be constant folding [doris]
morrySnow opened a new pull request, #37532:
URL: https://github.com/apache/doris/pull/37532
(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] [fix](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37532:
URL: https://github.com/apache/doris/pull/37532#issuecomment-2216900059
<details>
<summary>ClickBench: <b>Total hot run time: 31.34 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 76d36ebbeead3d31c8ce05f3024f5ea8b04b0a63, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.04 0.04
query3 0.23 0.06 0.06
query4 1.66 0.10 0.09
query5 0.50 0.49 0.48
query6 1.14 0.73 0.73
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.50 0.48
query10 0.57 0.54 0.54
query11 0.15 0.12 0.12
query12 0.15 0.13 0.13
query13 0.60 0.59 0.58
query14 0.78 0.79 0.77
query15 0.87 0.83 0.83
query16 0.37 0.37 0.38
query17 1.05 1.02 1.06
query18 0.23 0.22 0.23
query19 1.93 1.77 1.84
query20 0.02 0.01 0.01
query21 15.40 0.78 0.66
query22 4.04 6.87 2.25
query23 18.37 1.40 1.37
query24 2.13 0.23 0.23
query25 0.16 0.09 0.08
query26 0.29 0.22 0.21
query27 0.45 0.24 0.24
query28 13.25 1.03 1.01
query29 12.58 3.42 3.35
query30 0.25 0.06 0.07
query31 2.85 0.40 0.39
query32 3.27 0.47 0.47
query33 2.98 2.95 2.96
query34 16.98 4.32 4.38
query35 4.44 4.52 4.38
query36 0.65 0.46 0.46
query37 0.19 0.16 0.15
query38 0.16 0.15 0.15
query39 0.04 0.04 0.04
query40 0.14 0.12 0.13
query41 0.10 0.05 0.05
query42 0.05 0.04 0.04
query43 0.04 0.04 0.04
Total cold run time: 109.8 s
Total hot run time: 31.34 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed pull request #37532: [fix](ctas) keep varchar length not work when enable be constant folding
URL: https://github.com/apache/doris/pull/37532
--
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](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37532:
URL: https://github.com/apache/doris/pull/37532#issuecomment-2216832828
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] [fix](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #37532:
URL: https://github.com/apache/doris/pull/37532#issuecomment-2216833093
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](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37532:
URL: https://github.com/apache/doris/pull/37532#issuecomment-2216866010
<details>
<summary>TPC-H: <b>Total hot run time: 40907 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 76d36ebbeead3d31c8ce05f3024f5ea8b04b0a63, data reload: false
------ Round 1 ----------------------------------
q1 17791 4469 4378 4378
q2 3270 198 192 192
q3 11633 1176 1212 1176
q4 10524 764 769 764
q5 7725 2730 2652 2652
q6 224 140 138 138
q7 971 597 600 597
q8 9224 2063 2098 2063
q9 8986 6545 6533 6533
q10 9070 3750 3718 3718
q11 459 241 243 241
q12 454 226 228 226
q13 17777 3012 3020 3012
q14 262 224 235 224
q15 522 481 495 481
q16 510 379 375 375
q17 965 709 742 709
q18 8022 7431 7482 7431
q19 8586 1459 1454 1454
q20 708 336 345 336
q21 4982 3873 3960 3873
q22 403 338 334 334
Total cold run time: 123068 ms
Total hot run time: 40907 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4444 4250 4273 4250
q2 365 260 272 260
q3 2963 2755 2723 2723
q4 1860 1610 1566 1566
q5 5319 5328 5292 5292
q6 218 128 131 128
q7 2145 1761 1777 1761
q8 3195 3321 3336 3321
q9 8341 8351 8328 8328
q10 3868 3704 3675 3675
q11 591 504 502 502
q12 773 654 594 594
q13 17277 2975 3011 2975
q14 289 253 254 253
q15 517 494 480 480
q16 463 414 411 411
q17 1781 1469 1438 1438
q18 7679 7615 7359 7359
q19 1738 1569 1504 1504
q20 2041 1792 1773 1773
q21 10517 4728 4614 4614
q22 650 508 520 508
Total cold run time: 77034 ms
Total hot run time: 53715 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](ctas) keep varchar length not work when enable be constant folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37532:
URL: https://github.com/apache/doris/pull/37532#issuecomment-2216888874
<details>
<summary>TPC-DS: <b>Total hot run time: 172863 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 76d36ebbeead3d31c8ce05f3024f5ea8b04b0a63, data reload: false
query1 904 380 364 364
query2 6477 2305 2284 2284
query3 6676 211 221 211
query4 28443 17410 17302 17302
query5 4209 481 470 470
query6 263 165 160 160
query7 4577 300 277 277
query8 303 285 281 281
query9 8635 2449 2432 2432
query10 439 301 282 282
query11 10899 10101 10188 10101
query12 145 85 82 82
query13 1644 378 374 374
query14 9410 8183 7473 7473
query15 249 201 187 187
query16 7400 326 322 322
query17 1811 580 543 543
query18 1303 288 291 288
query19 198 154 197 154
query20 87 83 82 82
query21 204 126 128 126
query22 4314 4031 4045 4031
query23 33852 32993 33122 32993
query24 11139 2834 2830 2830
query25 613 357 369 357
query26 1159 145 143 143
query27 2595 262 271 262
query28 7393 2093 2061 2061
query29 881 630 596 596
query30 283 148 151 148
query31 965 766 738 738
query32 99 51 55 51
query33 764 290 302 290
query34 925 479 488 479
query35 661 601 609 601
query36 1117 938 966 938
query37 149 79 82 79
query38 2944 2767 2746 2746
query39 858 783 826 783
query40 201 119 120 119
query41 54 52 55 52
query42 115 98 99 98
query43 582 556 524 524
query44 1182 726 706 706
query45 193 166 159 159
query46 1063 726 724 724
query47 1850 1772 1761 1761
query48 365 301 296 296
query49 1084 411 407 407
query50 777 398 393 393
query51 6993 6795 6734 6734
query52 115 92 95 92
query53 359 294 298 294
query54 957 450 472 450
query55 74 73 70 70
query56 289 272 276 272
query57 1114 1036 1029 1029
query58 260 260 245 245
query59 3241 3198 3170 3170
query60 310 275 265 265
query61 98 95 98 95
query62 834 665 657 657
query63 326 290 298 290
query64 9720 2176 1626 1626
query65 3204 3145 3091 3091
query66 870 332 326 326
query67 15515 15241 14858 14858
query68 4581 540 543 540
query69 477 327 316 316
query70 1156 1096 1134 1096
query71 416 277 278 277
query72 7425 4924 5365 4924
query73 728 332 328 328
query74 6013 5480 5557 5480
query75 3504 2706 2673 2673
query76 2851 937 944 937
query77 479 313 310 310
query78 9525 8927 8951 8927
query79 2227 522 521 521
query80 2003 478 486 478
query81 593 214 218 214
query82 1004 147 138 138
query83 295 170 182 170
query84 267 91 91 91
query85 1273 314 307 307
query86 463 335 296 296
query87 3284 3137 3121 3121
query88 3865 2469 2461 2461
query89 488 395 385 385
query90 1780 195 256 195
query91 134 101 107 101
query92 73 48 49 48
query93 1971 507 496 496
query94 1202 216 214 214
query95 419 324 322 322
query96 602 274 269 269
query97 3196 3032 3103 3032
query98 238 201 199 199
query99 1619 1289 1273 1273
Total cold run time: 280883 ms
Total hot run time: 172863 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