You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2024/09/03 12:08:02 UTC
[PR] [feature](cast) add enable_strict_cast_mode [doris]
Mryange opened a new pull request, #40334:
URL: https://github.com/apache/doris/pull/40334
## Proposed changes
```
mysql [(none)]>set enable_strict_cast_mode = false;
Query OK, 0 rows affected (0.01 sec)
mysql [(none)]>select cast('1.a' as int);
+--------------------+
| cast('1.a' as INT) |
+--------------------+
| NULL |
+--------------------+
1 row in set (0.12 sec)
mysql [(none)]>set enable_strict_cast_mode = true;
Query OK, 0 rows affected (0.01 sec)
mysql [(none)]>select cast('1.a' as int);
ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[INVALID_ARGUMENT]Bad cast from String to Int32 with value : 1.a
```
<!--Describe your changes.-->
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2360057374
<details>
<summary>ClickBench: <b>Total hot run time: 33.41 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 18dd3bbaf04b1678b7745f4cdb1fd3fb4cd5863c, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.04 0.05
query3 0.22 0.05 0.05
query4 1.67 0.07 0.08
query5 0.51 0.50 0.50
query6 1.13 0.76 0.73
query7 0.02 0.01 0.01
query8 0.06 0.04 0.05
query9 0.55 0.50 0.49
query10 0.57 0.57 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.61 0.59 0.59
query14 2.97 2.95 3.00
query15 0.93 0.86 0.82
query16 0.36 0.38 0.37
query17 1.08 1.06 1.09
query18 0.18 0.17 0.17
query19 1.95 1.91 1.92
query20 0.02 0.00 0.01
query21 15.36 0.67 0.65
query22 4.78 6.67 1.92
query23 18.24 1.45 1.23
query24 2.14 0.22 0.21
query25 0.15 0.08 0.08
query26 0.28 0.17 0.18
query27 0.08 0.08 0.08
query28 13.23 1.17 1.13
query29 12.65 3.50 3.46
query30 0.25 0.05 0.05
query31 2.87 0.42 0.39
query32 3.24 0.49 0.47
query33 2.99 3.00 3.03
query34 17.06 4.37 4.43
query35 4.52 4.51 4.51
query36 0.67 0.49 0.49
query37 0.19 0.16 0.15
query38 0.16 0.16 0.14
query39 0.05 0.04 0.04
query40 0.17 0.13 0.13
query41 0.09 0.04 0.04
query42 0.06 0.04 0.05
query43 0.04 0.04 0.03
Total cold run time: 112.54 s
Total hot run time: 33.41 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326505982
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326522136
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2334018692
<details>
<summary>ClickBench: <b>Total hot run time: 31.61 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 56d69fe308c9f701a55885d400fcfa2fbd35ab9b, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.67 0.07 0.08
query5 0.52 0.50 0.50
query6 1.13 0.73 0.72
query7 0.02 0.01 0.01
query8 0.05 0.05 0.05
query9 0.56 0.49 0.49
query10 0.55 0.56 0.55
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.60 0.58 0.59
query14 1.42 1.41 1.44
query15 0.83 0.84 0.81
query16 0.37 0.38 0.38
query17 1.03 1.07 1.07
query18 0.21 0.20 0.20
query19 1.89 1.82 1.82
query20 0.01 0.01 0.01
query21 15.39 0.67 0.66
query22 4.23 6.85 2.00
query23 18.26 1.48 1.27
query24 2.18 0.22 0.22
query25 0.14 0.07 0.08
query26 0.26 0.18 0.17
query27 0.08 0.08 0.08
query28 13.26 1.01 0.99
query29 12.64 3.36 3.30
query30 0.24 0.05 0.06
query31 2.87 0.40 0.40
query32 3.25 0.48 0.47
query33 2.94 3.04 3.02
query34 17.08 4.38 4.39
query35 4.45 4.46 4.44
query36 0.66 0.47 0.47
query37 0.18 0.15 0.15
query38 0.17 0.16 0.15
query39 0.05 0.03 0.03
query40 0.16 0.12 0.12
query41 0.09 0.05 0.05
query42 0.05 0.05 0.05
query43 0.05 0.04 0.05
Total cold run time: 110.2 s
Total hot run time: 31.61 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2333986583
<details>
<summary>TPC-H: <b>Total hot run time: 38351 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 56d69fe308c9f701a55885d400fcfa2fbd35ab9b, data reload: false
------ Round 1 ----------------------------------
q1 18286 4965 4357 4357
q2 2034 190 189 189
q3 11422 975 1083 975
q4 10176 779 735 735
q5 7755 2921 2851 2851
q6 230 139 142 139
q7 974 607 600 600
q8 9334 2138 2102 2102
q9 7140 6542 6572 6542
q10 7003 2172 2182 2172
q11 445 251 246 246
q12 421 230 229 229
q13 18981 3094 3132 3094
q14 286 232 246 232
q15 546 495 469 469
q16 530 438 420 420
q17 1019 689 745 689
q18 7538 6804 6810 6804
q19 1379 1042 1050 1042
q20 678 339 331 331
q21 4187 3188 3149 3149
q22 1136 1016 984 984
Total cold run time: 111500 ms
Total hot run time: 38351 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4395 4297 4324 4297
q2 374 277 277 277
q3 2941 2714 2684 2684
q4 1932 1664 1693 1664
q5 5691 5679 5825 5679
q6 225 133 136 133
q7 2244 1829 1850 1829
q8 3277 3482 3559 3482
q9 8864 8880 8911 8880
q10 3650 3411 3368 3368
q11 623 528 510 510
q12 825 723 682 682
q13 15057 3242 3307 3242
q14 314 295 278 278
q15 519 514 491 491
q16 522 518 505 505
q17 1864 1574 1559 1559
q18 8234 7982 8106 7982
q19 1750 1503 1610 1503
q20 2118 1917 1910 1910
q21 5781 5527 5282 5282
q22 1105 1076 1030 1030
Total cold run time: 72305 ms
Total hot run time: 57267 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326849460
<details>
<summary>ClickBench: <b>Total hot run time: 32.1 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 414ee40d0ca3bf561f8faf0218ddf6854b1b6796, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.67 0.08 0.07
query5 0.49 0.49 0.49
query6 1.14 0.73 0.72
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.48 0.49
query10 0.54 0.55 0.52
query11 0.16 0.11 0.11
query12 0.16 0.12 0.12
query13 0.62 0.59 0.59
query14 2.04 2.08 2.08
query15 0.84 0.82 0.82
query16 0.37 0.36 0.38
query17 0.98 0.98 0.96
query18 0.20 0.20 0.21
query19 1.84 1.73 1.71
query20 0.01 0.01 0.01
query21 15.40 0.65 0.66
query22 4.78 6.68 2.04
query23 18.22 1.37 1.25
query24 2.15 0.23 0.22
query25 0.15 0.08 0.08
query26 0.27 0.18 0.18
query27 0.07 0.07 0.08
query28 13.19 1.02 0.99
query29 12.57 3.31 3.30
query30 0.25 0.06 0.06
query31 2.89 0.40 0.38
query32 3.24 0.48 0.47
query33 2.97 3.00 2.99
query34 16.91 4.46 4.44
query35 4.49 4.53 4.52
query36 0.67 0.47 0.46
query37 0.18 0.15 0.16
query38 0.15 0.15 0.14
query39 0.05 0.03 0.04
query40 0.16 0.12 0.13
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.99 s
Total hot run time: 32.1 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #40334: [feature](cast) add enable_strict_cast_mode
URL: https://github.com/apache/doris/pull/40334
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326837078
<details>
<summary>TPC-DS: <b>Total hot run time: 192679 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 414ee40d0ca3bf561f8faf0218ddf6854b1b6796, data reload: false
query1 1241 883 878 878
query2 6347 1884 1877 1877
query3 10745 3955 3917 3917
query4 59995 24017 23349 23349
query5 5362 510 502 502
query6 402 154 159 154
query7 5751 304 297 297
query8 296 209 213 209
query9 8971 2478 2449 2449
query10 494 288 273 273
query11 16658 15289 15289 15289
query12 169 106 108 106
query13 1633 397 390 390
query14 11205 7428 7314 7314
query15 240 177 189 177
query16 7327 446 492 446
query17 1163 586 574 574
query18 1858 299 300 299
query19 293 147 147 147
query20 118 117 110 110
query21 207 105 103 103
query22 4955 4423 4495 4423
query23 34408 33634 33210 33210
query24 5938 2833 2855 2833
query25 528 388 385 385
query26 685 155 149 149
query27 1799 271 276 271
query28 3706 2034 2015 2015
query29 657 399 403 399
query30 241 152 144 144
query31 954 732 744 732
query32 86 52 52 52
query33 417 297 272 272
query34 859 468 483 468
query35 826 709 723 709
query36 1044 973 938 938
query37 147 84 88 84
query38 3983 3841 3932 3841
query39 1457 1440 1376 1376
query40 199 115 113 113
query41 46 46 45 45
query42 119 97 98 97
query43 498 465 469 465
query44 1110 730 734 730
query45 192 162 165 162
query46 1083 769 722 722
query47 1915 1825 1809 1809
query48 372 296 284 284
query49 756 443 436 436
query50 841 410 425 410
query51 6902 6876 6952 6876
query52 98 85 89 85
query53 254 179 184 179
query54 579 461 472 461
query55 75 74 79 74
query56 332 255 257 255
query57 1197 1044 1058 1044
query58 242 250 231 231
query59 3005 2755 2714 2714
query60 283 279 271 271
query61 108 99 102 99
query62 746 641 632 632
query63 207 183 181 181
query64 2848 737 662 662
query65 3228 3159 3154 3154
query66 683 337 351 337
query67 15454 15146 15285 15146
query68 2949 568 578 568
query69 416 284 285 284
query70 1173 1124 1119 1119
query71 341 275 284 275
query72 5283 4021 2523 2523
query73 761 328 330 328
query74 9199 8960 8970 8960
query75 3366 2622 2698 2622
query76 1412 995 934 934
query77 543 329 309 309
query78 9694 10702 11152 10702
query79 1031 535 514 514
query80 755 530 505 505
query81 523 235 234 234
query82 241 143 138 138
query83 167 145 146 145
query84 257 80 75 75
query85 682 283 274 274
query86 308 278 299 278
query87 4469 4376 4269 4269
query88 3180 2311 2316 2311
query89 371 287 284 284
query90 1932 192 192 192
query91 122 98 101 98
query92 60 49 50 49
query93 1031 527 527 527
query94 696 278 300 278
query95 330 255 260 255
query96 585 269 269 269
query97 3234 3079 3055 3055
query98 219 199 205 199
query99 1519 1278 1271 1271
Total cold run time: 303386 ms
Total hot run time: 192679 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2333790764
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2734994544
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326359751
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326372082
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326767471
TeamCity be ut coverage result:
Function Coverage: 36.82% (9387/25493)
Line Coverage: 28.25% (77394/273943)
Region Coverage: 27.66% (39949/144448)
Branch Coverage: 24.31% (20330/83642)
Coverage Report: http://coverage.selectdb-in.cc/coverage/414ee40d0ca3bf561f8faf0218ddf6854b1b6796_414ee40d0ca3bf561f8faf0218ddf6854b1b6796/report/index.html
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2359924947
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2360034233
<details>
<summary>TPC-H: <b>Total hot run time: 41682 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 18dd3bbaf04b1678b7745f4cdb1fd3fb4cd5863c, data reload: false
------ Round 1 ----------------------------------
q1 17965 7393 7236 7236
q2 2065 164 166 164
q3 11075 1083 1251 1083
q4 10326 786 762 762
q5 7738 3134 3071 3071
q6 232 148 150 148
q7 1017 627 599 599
q8 9460 2037 2044 2037
q9 6835 6422 6460 6422
q10 7019 2291 2311 2291
q11 436 246 255 246
q12 409 219 223 219
q13 17781 2981 3018 2981
q14 244 213 212 212
q15 570 515 545 515
q16 670 605 613 605
q17 984 816 814 814
q18 7370 6725 6802 6725
q19 1417 1040 1122 1040
q20 581 298 286 286
q21 4001 3220 3255 3220
q22 1098 1006 1027 1006
Total cold run time: 109293 ms
Total hot run time: 41682 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7243 7860 7218 7218
q2 340 242 233 233
q3 3098 2997 2903 2903
q4 2128 1816 1789 1789
q5 5567 5626 5725 5626
q6 240 155 151 151
q7 2178 1790 1792 1790
q8 3314 3428 3411 3411
q9 8803 8967 8725 8725
q10 3506 3450 3462 3450
q11 578 482 475 475
q12 809 611 639 611
q13 9919 3180 3209 3180
q14 323 272 283 272
q15 581 528 519 519
q16 715 686 665 665
q17 1815 1595 1590 1590
q18 8360 7726 7749 7726
q19 1774 1509 1641 1509
q20 2146 1880 1860 1860
q21 5553 5290 5530 5290
q22 1140 1083 1033 1033
Total cold run time: 70130 ms
Total hot run time: 60026 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326359281
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2333946300
TeamCity be ut coverage result:
Function Coverage: 36.84% (9381/25464)
Line Coverage: 28.22% (77331/274072)
Region Coverage: 27.63% (39956/144604)
Branch Coverage: 24.25% (20325/83806)
Coverage Report: http://coverage.selectdb-in.cc/coverage/56d69fe308c9f701a55885d400fcfa2fbd35ab9b_56d69fe308c9f701a55885d400fcfa2fbd35ab9b/report/index.html
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2360048272
<details>
<summary>TPC-DS: <b>Total hot run time: 198812 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 18dd3bbaf04b1678b7745f4cdb1fd3fb4cd5863c, data reload: false
query1 1275 886 899 886
query2 6238 1989 2023 1989
query3 10816 3979 3862 3862
query4 63120 28523 23403 23403
query5 4930 461 454 454
query6 404 168 166 166
query7 5462 298 287 287
query8 311 225 222 222
query9 8563 2697 2693 2693
query10 444 299 304 299
query11 17083 15129 15766 15129
query12 159 108 97 97
query13 1466 426 429 426
query14 10610 7424 7585 7424
query15 208 179 180 179
query16 6706 491 507 491
query17 1147 596 581 581
query18 1452 304 299 299
query19 213 152 146 146
query20 124 109 107 107
query21 216 105 107 105
query22 4682 4368 4802 4368
query23 34976 34262 33941 33941
query24 6036 2881 2872 2872
query25 509 398 399 398
query26 667 163 160 160
query27 1699 291 284 284
query28 4299 2466 2448 2448
query29 662 425 427 425
query30 232 153 155 153
query31 971 800 797 797
query32 71 54 55 54
query33 391 282 294 282
query34 900 492 483 483
query35 848 716 725 716
query36 1055 945 956 945
query37 149 95 90 90
query38 3965 3874 3960 3874
query39 1489 1393 1434 1393
query40 207 95 95 95
query41 48 48 45 45
query42 120 96 97 96
query43 522 490 477 477
query44 1125 814 793 793
query45 196 165 162 162
query46 1125 747 747 747
query47 1936 1798 1819 1798
query48 462 354 379 354
query49 695 407 387 387
query50 834 433 402 402
query51 7123 6928 6778 6778
query52 99 88 86 86
query53 246 177 175 175
query54 555 452 439 439
query55 74 75 74 74
query56 270 248 261 248
query57 1207 1099 1078 1078
query58 209 235 250 235
query59 3119 3004 2840 2840
query60 288 265 258 258
query61 102 103 103 103
query62 747 682 652 652
query63 223 185 180 180
query64 1398 653 659 653
query65 3267 3160 3157 3157
query66 640 300 299 299
query67 15940 15359 15500 15359
query68 1284 872 844 844
query69 438 339 343 339
query70 1191 1248 1155 1155
query71 337 326 326 326
query72 6082 3466 3323 3323
query73 585 574 571 571
query74 9224 8992 9130 8992
query75 2948 2876 2958 2876
query76 1016 878 857 857
query77 372 366 347 347
query78 9418 9238 9280 9238
query79 926 897 870 870
query80 581 554 563 554
query81 468 252 251 251
query82 234 230 233 230
query83 160 159 158 158
query84 263 101 101 101
query85 673 380 352 352
query86 316 318 337 318
query87 4472 4493 4438 4438
query88 4284 4070 4076 4070
query89 375 356 359 356
query90 1525 307 307 307
query91 161 163 180 163
query92 73 72 73 72
query93 916 902 904 902
query94 533 389 360 360
query95 423 408 417 408
query96 491 485 487 485
query97 3142 3160 3136 3136
query98 236 224 241 224
query99 1423 1305 1291 1291
Total cold run time: 301895 ms
Total hot run time: 198812 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2360030456
TeamCity be ut coverage result:
Function Coverage: 37.32% (9584/25681)
Line Coverage: 28.72% (79240/275928)
Region Coverage: 28.19% (41028/145539)
Branch Coverage: 24.82% (20907/84236)
Coverage Report: http://coverage.selectdb-in.cc/coverage/18dd3bbaf04b1678b7745f4cdb1fd3fb4cd5863c_18dd3bbaf04b1678b7745f4cdb1fd3fb4cd5863c/report/index.html
--
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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2334007819
<details>
<summary>TPC-DS: <b>Total hot run time: 192122 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 56d69fe308c9f701a55885d400fcfa2fbd35ab9b, data reload: false
query1 1254 903 877 877
query2 6343 1879 1909 1879
query3 10597 3973 3971 3971
query4 59670 26372 23055 23055
query5 5337 534 508 508
query6 414 168 165 165
query7 5771 292 290 290
query8 319 230 225 225
query9 8996 2497 2509 2497
query10 507 286 267 267
query11 18012 15021 15364 15021
query12 157 108 108 108
query13 1579 389 394 389
query14 10948 7499 7236 7236
query15 241 169 172 169
query16 7327 481 472 472
query17 1121 624 564 564
query18 1900 291 315 291
query19 301 146 151 146
query20 126 111 108 108
query21 203 109 113 109
query22 4664 4619 4652 4619
query23 34085 33366 33338 33338
query24 6016 2947 2841 2841
query25 549 404 398 398
query26 690 159 160 159
query27 1797 278 279 278
query28 4049 2052 2024 2024
query29 682 438 419 419
query30 241 156 156 156
query31 932 761 805 761
query32 80 56 49 49
query33 405 282 287 282
query34 878 473 475 473
query35 842 735 713 713
query36 1047 927 930 927
query37 148 83 86 83
query38 3922 3815 3967 3815
query39 1438 1380 1401 1380
query40 195 120 112 112
query41 46 44 40 40
query42 117 95 93 93
query43 511 479 458 458
query44 1124 741 732 732
query45 194 166 168 166
query46 1089 751 706 706
query47 1880 1792 1809 1792
query48 365 286 297 286
query49 768 430 436 430
query50 833 408 412 408
query51 7050 6788 6817 6788
query52 100 88 86 86
query53 255 176 179 176
query54 555 476 448 448
query55 74 72 77 72
query56 278 255 257 255
query57 1178 1062 1089 1062
query58 228 221 225 221
query59 2906 2859 2853 2853
query60 305 267 266 266
query61 99 98 99 98
query62 739 646 660 646
query63 214 196 181 181
query64 2810 691 676 676
query65 3243 3130 3177 3130
query66 687 355 394 355
query67 15352 15123 15119 15119
query68 2955 577 599 577
query69 412 281 275 275
query70 1202 1141 1084 1084
query71 362 279 264 264
query72 6168 4044 3986 3986
query73 755 326 331 326
query74 9103 8800 8839 8800
query75 3370 2647 2724 2647
query76 1473 981 1031 981
query77 547 341 346 341
query78 9666 9430 8954 8954
query79 1041 547 517 517
query80 688 518 500 500
query81 539 233 230 230
query82 248 136 135 135
query83 180 145 145 145
query84 259 79 74 74
query85 690 285 275 275
query86 297 296 310 296
query87 4522 4187 4389 4187
query88 3039 2353 2377 2353
query89 371 283 280 280
query90 1949 194 186 186
query91 122 98 99 98
query92 57 51 49 49
query93 1041 539 543 539
query94 717 293 309 293
query95 326 253 257 253
query96 591 271 264 264
query97 3218 3059 3039 3039
query98 216 214 202 202
query99 1479 1255 1277 1255
Total cold run time: 304386 ms
Total hot run time: 192122 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] [feature](cast) add enable_strict_cast_mode [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40334:
URL: https://github.com/apache/doris/pull/40334#issuecomment-2326807939
<details>
<summary>TPC-H: <b>Total hot run time: 38126 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 414ee40d0ca3bf561f8faf0218ddf6854b1b6796, data reload: false
------ Round 1 ----------------------------------
q1 18506 4870 4330 4330
q2 2033 183 179 179
q3 11799 961 1205 961
q4 10502 728 760 728
q5 7774 2842 2784 2784
q6 232 140 142 140
q7 971 616 601 601
q8 9319 2090 2089 2089
q9 7143 6605 6596 6596
q10 6999 2232 2141 2141
q11 445 237 240 237
q12 400 229 231 229
q13 17781 3062 3079 3062
q14 276 226 224 224
q15 505 501 502 501
q16 601 529 504 504
q17 995 723 696 696
q18 7428 6695 6960 6695
q19 1383 1110 1018 1018
q20 677 337 337 337
q21 3924 3148 3060 3060
q22 1129 1068 1014 1014
Total cold run time: 110822 ms
Total hot run time: 38126 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4412 4328 4346 4328
q2 385 272 273 272
q3 2871 2653 2714 2653
q4 1893 1755 1660 1660
q5 5689 5708 5776 5708
q6 236 140 133 133
q7 2211 1869 1854 1854
q8 3316 3479 3569 3479
q9 8803 8828 8801 8801
q10 3644 3448 3354 3354
q11 613 496 503 496
q12 854 686 659 659
q13 13041 3228 3264 3228
q14 331 297 291 291
q15 538 489 477 477
q16 631 608 574 574
q17 1860 1577 1563 1563
q18 8150 7871 7828 7828
q19 1730 1446 1588 1446
q20 2197 1897 1923 1897
q21 5854 5459 5507 5459
q22 1173 1073 1045 1045
Total cold run time: 70432 ms
Total hot run time: 57205 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