You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Gabriel39 (via GitHub)" <gi...@apache.org> on 2024/10/23 03:34:03 UTC
[PR] [fix](compile) Enable compile checking for function_jsonb [doris]
Gabriel39 opened a new pull request, #42305:
URL: https://github.com/apache/doris/pull/42305
## Proposed changes
Issue Number: close #xxx
<!--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] [fix](compile) Enable compile checking for function_jsonb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430936253
<details>
<summary>TPC-DS: <b>Total hot run time: 192771 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 c900e0cfd1d86185f223dddcdb25b13c70bd4c7e, data reload: false
query1 993 421 423 421
query2 6243 2224 2078 2078
query3 8689 213 212 212
query4 34053 23761 23570 23570
query5 3564 465 490 465
query6 271 169 161 161
query7 4208 290 287 287
query8 289 229 230 229
query9 9285 2672 2672 2672
query10 476 282 288 282
query11 18137 15324 15244 15244
query12 163 103 105 103
query13 1560 445 415 415
query14 9766 7366 7524 7366
query15 228 168 177 168
query16 7235 447 489 447
query17 1638 615 601 601
query18 1925 312 319 312
query19 256 161 167 161
query20 121 122 111 111
query21 220 116 120 116
query22 4780 4632 4593 4593
query23 34915 34060 34253 34060
query24 10870 2800 2773 2773
query25 614 404 425 404
query26 982 161 163 161
query27 2274 290 292 290
query28 7325 2462 2437 2437
query29 781 436 429 429
query30 270 157 151 151
query31 1033 817 804 804
query32 96 56 59 56
query33 762 301 294 294
query34 910 523 533 523
query35 940 759 749 749
query36 1092 955 950 950
query37 157 104 85 85
query38 4076 3985 4033 3985
query39 1483 1412 1448 1412
query40 210 101 101 101
query41 49 49 47 47
query42 136 98 96 96
query43 550 496 495 495
query44 1259 803 812 803
query45 202 166 171 166
query46 1142 743 698 698
query47 1965 1855 1843 1843
query48 440 316 328 316
query49 965 464 431 431
query50 812 396 402 396
query51 7123 7007 6878 6878
query52 98 89 91 89
query53 259 180 186 180
query54 1298 437 456 437
query55 79 80 87 80
query56 326 275 261 261
query57 1308 1158 1160 1158
query58 240 234 239 234
query59 3185 3171 3028 3028
query60 308 281 279 279
query61 103 108 108 108
query62 852 685 669 669
query63 225 198 192 192
query64 4118 635 621 621
query65 3309 3431 3237 3237
query66 869 303 304 303
query67 15979 15804 15702 15702
query68 4485 567 557 557
query69 512 296 294 294
query70 1210 1151 1097 1097
query71 353 282 267 267
query72 7260 4009 4008 4008
query73 775 361 359 359
query74 10401 9071 9057 9057
query75 3508 2669 2758 2669
query76 3095 947 891 891
query77 604 314 297 297
query78 10537 9664 9573 9573
query79 1172 611 601 601
query80 2089 458 452 452
query81 581 244 238 238
query82 343 144 141 141
query83 289 134 133 133
query84 288 71 69 69
query85 1322 311 296 296
query86 355 299 295 295
query87 4476 4274 4395 4274
query88 3836 2207 2170 2170
query89 402 287 291 287
query90 2191 192 188 188
query91 148 113 101 101
query92 63 52 51 51
query93 1089 535 539 535
query94 1039 289 288 288
query95 357 249 247 247
query96 618 281 282 281
query97 3279 3140 3140 3140
query98 223 204 198 198
query99 1650 1320 1292 1292
Total cold run time: 298639 ms
Total hot run time: 192771 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](compile) Enable compile checking for function_jsonb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430791155
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] [fix](compile) Enable compile checking for function_jsonb [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430784062
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](compile) Enable compile checking for function_jsonb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430935749
TeamCity be ut coverage result:
Function Coverage: 37.47% (9709/25911)
Line Coverage: 28.74% (80545/280280)
Region Coverage: 28.16% (41642/147895)
Branch Coverage: 24.72% (21156/85574)
Coverage Report: http://coverage.selectdb-in.cc/coverage/c900e0cfd1d86185f223dddcdb25b13c70bd4c7e_c900e0cfd1d86185f223dddcdb25b13c70bd4c7e/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] [fix](compile) Enable compile checking for function_jsonb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430784002
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](compile) Enable compile checking for function_jsonb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2431010878
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](compile) Enable compile checking for function_jsonb [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 merged PR #42305:
URL: https://github.com/apache/doris/pull/42305
--
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](compile) Enable compile checking for function_jsonb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430921281
<details>
<summary>TPC-H: <b>Total hot run time: 41533 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 c900e0cfd1d86185f223dddcdb25b13c70bd4c7e, data reload: false
------ Round 1 ----------------------------------
q1 17722 7552 7324 7324
q2 2018 295 271 271
q3 11962 1086 1188 1086
q4 10567 858 910 858
q5 7733 3167 3031 3031
q6 247 151 150 150
q7 1028 629 611 611
q8 9369 2044 1988 1988
q9 6573 6466 6419 6419
q10 7044 2450 2441 2441
q11 445 239 248 239
q12 429 228 225 225
q13 17793 3038 3014 3014
q14 239 212 215 212
q15 570 517 514 514
q16 643 586 601 586
q17 989 563 477 477
q18 7524 6772 6705 6705
q19 1354 955 1056 955
q20 494 189 186 186
q21 4019 3243 3262 3243
q22 1101 1022 998 998
Total cold run time: 109863 ms
Total hot run time: 41533 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7303 7263 7349 7263
q2 328 236 236 236
q3 3031 2972 2933 2933
q4 2117 1858 1855 1855
q5 5767 5811 5817 5811
q6 245 146 150 146
q7 2292 1852 1790 1790
q8 3404 3491 3458 3458
q9 8971 8981 8894 8894
q10 3606 3594 3560 3560
q11 583 512 490 490
q12 863 648 632 632
q13 10256 3200 3192 3192
q14 302 272 277 272
q15 592 522 517 517
q16 683 661 641 641
q17 1875 1645 1634 1634
q18 8367 7744 7586 7586
q19 1767 1480 1543 1480
q20 2201 1891 1893 1891
q21 5531 5472 5431 5431
q22 1194 1060 1022 1022
Total cold run time: 71278 ms
Total hot run time: 60734 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](compile) Enable compile checking for function_jsonb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2431010834
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](compile) Enable compile checking for function_jsonb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42305:
URL: https://github.com/apache/doris/pull/42305#issuecomment-2430943490
<details>
<summary>ClickBench: <b>Total hot run time: 32.99 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 c900e0cfd1d86185f223dddcdb25b13c70bd4c7e, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.03 0.02
query3 0.22 0.07 0.07
query4 1.63 0.10 0.10
query5 0.50 0.50 0.52
query6 1.14 0.72 0.74
query7 0.02 0.02 0.01
query8 0.03 0.03 0.03
query9 0.57 0.50 0.49
query10 0.56 0.56 0.56
query11 0.15 0.11 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.61
query14 2.71 2.77 2.74
query15 0.92 0.84 0.83
query16 0.41 0.39 0.38
query17 1.07 1.06 1.06
query18 0.20 0.20 0.20
query19 2.00 1.76 2.06
query20 0.02 0.01 0.00
query21 15.36 0.58 0.60
query22 2.74 2.29 1.62
query23 17.13 0.98 0.91
query24 3.12 2.01 1.46
query25 0.22 0.06 0.10
query26 0.64 0.13 0.14
query27 0.05 0.03 0.04
query28 9.58 1.09 1.08
query29 12.58 3.19 3.20
query30 0.24 0.06 0.06
query31 2.87 0.38 0.39
query32 3.28 0.46 0.45
query33 3.05 3.04 3.00
query34 17.03 4.42 4.46
query35 4.55 4.51 4.52
query36 0.67 0.48 0.48
query37 0.08 0.07 0.06
query38 0.04 0.03 0.03
query39 0.03 0.02 0.02
query40 0.16 0.13 0.13
query41 0.08 0.02 0.03
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 106.58 s
Total hot run time: 32.99 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