Re: [PR] [refine](cast json) [doris]
Mryange closed pull request #51261: [refine](cast json) URL: https://github.com/apache/doris/pull/51261 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2911415228 ClickBench: Total hot run time: 29.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit bb3485c57433ceb584cfdeff504cffbdab0c2c2f, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.260.190.20 query4 1.590.200.11 query5 0.420.430.43 query6 1.160.660.67 query7 0.020.020.02 query8 0.050.040.04 query9 0.580.540.50 query10 0.570.600.58 query11 0.160.110.10 query12 0.150.110.11 query13 0.620.610.60 query14 0.780.800.81 query15 0.870.840.86 query16 0.380.380.39 query17 1.041.061.05 query18 0.230.210.21 query19 1.921.771.77 query20 0.010.010.02 query21 15.39 0.900.54 query22 0.761.170.66 query23 14.94 1.370.64 query24 6.961.770.86 query25 0.530.320.08 query26 0.580.160.13 query27 0.060.060.05 query28 10.27 0.910.45 query29 12.57 3.913.26 query30 0.250.090.06 query31 2.830.600.38 query32 3.220.550.47 query33 3.063.073.04 query34 15.83 5.114.57 query35 4.534.604.54 query36 0.680.500.48 query37 0.090.060.06 query38 0.050.040.03 query39 0.040.020.02 query40 0.170.150.13 query41 0.080.030.03 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 103.94 s Total hot run time: 29.07 s ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2911396995 TPC-DS: Total hot run time: 186495 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit bb3485c57433ceb584cfdeff504cffbdab0c2c2f, data reload: false query1 1020509 502 502 query2 6571185618691856 query3 6745223 221 221 query4 26259 23312 23021 23021 query5 4369621 487 487 query6 328 235 202 202 query7 4641502 302 302 query8 313 260 243 243 query9 8619267726782677 query10 493 344 273 273 query11 15654 15183 14900 14900 query12 167 114 108 108 query13 1663512 401 401 query14 8782638763046304 query15 201 186 180 180 query16 7137670 497 497 query17 929 725 574 574 query18 1971393 295 295 query19 190 191 163 163 query20 120 116 119 116 query21 212 128 116 116 query22 4237415241824152 query23 34102 33117 33372 33117 query24 8400242724562427 query25 535 455 391 391 query26 1233269 159 159 query27 2753494 336 336 query28 4344217021622162 query29 776 566 476 476 query30 286 219 191 191 query31 932 835 762 762 query32 76 65 69 65 query33 560 372 329 329 query34 805 871 531 531 query35 795 804 744 744 query36 970 978 904 904 query37 114 100 76 76 query38 4058410040684068 query39 1472142914541429 query40 210 124 112 112 query41 59 55 53 53 query42 126 106 117 106 query43 508 506 467 467 query44 1342821 819 819 query45 180 179 173 173 query46 846 1025644 644 query47 1732178617011701 query48 389 429 330 330 query49 794 507 446 446 query50 671 677 422 422 query51 4167418840954095 query52 112 112 98 98 query53 230 258 187 187 query54 595 590 524 524 query55 86 87 88 87 query56 333 328 338 328 query57 1118118911121112 query58 282 278 285 278 query59 2544264225172517 query60 351 345 330 330 query61 173 158 153 153 query62 811 772 654 654 query63 236 200 200 200 query64 45311027689 689 query65 4341421942734219 query66 1145400 317 317 query67 16090 15379 15288 15288 query68 7817890 521 521 query69 476 307 274 274 query70 1241112610981098 query71 436 332 335 332 query72 5649475647224722 query73 645 607 350 350 query74 8858882387048704 query75 3463325027302730 query76 33561190800 800 query77 757 410 292 292 query78 10039 10188 93049304 query79 2088788 569 569 query80 590 523 466 466 query81 497 261 229 229 query82 470 124 99 99 query83 251 266 229 229 query84 301 104 94 94 query85 796 364 317 317 query86 385 326 297 297 query87 4423452743704370 query88 3886228722632263 query89 396 314 293 293 query90 1922214 215 214 query91 157 149 118 118 query92 84 58 55 55 query93 1747951 587 587 query94 664 409 317 317 query95 374 293 294 293 query96 498 577 282 282 query97 2735274926852685 query98 241 208 204 204 query99 1341139212811281 Total cold run time: 273417 ms Total hot run time: 186495 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2911354270 TPC-H: Total hot run time: 33920 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit bb3485c57433ceb584cfdeff504cffbdab0c2c2f, data reload: false -- Round 1 -- q1 26409 499750004997 q2 2071299 192 192 q3 10423 1258715 715 q4 10220 1003520 520 q5 7568236223662362 q6 182 164 133 133 q7 918 756 629 629 q8 9312132210861086 q9 6800513651885136 q10 6872231318911891 q11 483 287 269 269 q12 338 346 219 219 q13 17782 368330663066 q14 229 225 214 214 q15 529 487 480 480 q16 430 447 370 370 q17 625 868 368 368 q18 7955714971757149 q19 1909978 561 561 q20 338 343 226 226 q21 3956319623502350 q22 10621009987 987 Total cold run time: 116411 ms Total hot run time: 33920 ms - Round 2, with runtime_filter_mode=off - q1 5173507850665066 q2 249 333 231 231 q3 2162259222702270 q4 1330179314091409 q5 4599445644084408 q6 214 175 129 129 q7 1985191817811781 q8 2551250325122503 q9 7203720772237207 q10 3023314927762776 q11 569 512 489 489 q12 658 768 600 600 q13 3516389133253325 q14 270 287 279 279 q15 524 472 477 472 q16 452 471 437 437 q17 1148159413681368 q18 7647748674517451 q19 812 836 979 836 q20 2028206918931893 q21 4929442742434243 q22 1061990 981 981 Total cold run time: 52103 ms Total hot run time: 50154 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
Mryange commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2911122998 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2910180253 ClickBench: Total hot run time: 29.43 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 96ca424a4b231b2ab9f9ed80efcfad2e895ff027, data reload: false query1 0.040.040.03 query2 0.130.100.12 query3 0.250.200.19 query4 1.590.200.20 query5 0.460.430.46 query6 1.200.680.65 query7 0.020.020.02 query8 0.050.040.04 query9 0.590.520.52 query10 0.570.560.57 query11 0.150.110.11 query12 0.150.110.11 query13 0.620.600.60 query14 0.840.780.82 query15 0.870.850.87 query16 0.390.400.39 query17 1.041.061.03 query18 0.230.210.21 query19 1.941.811.78 query20 0.010.010.01 query21 15.39 0.890.53 query22 0.761.200.80 query23 14.72 1.360.61 query24 6.411.630.96 query25 0.520.260.09 query26 0.620.160.14 query27 0.050.060.05 query28 9.330.880.45 query29 12.54 4.073.33 query30 0.240.090.06 query31 2.820.610.38 query32 3.240.560.49 query33 3.153.093.05 query34 15.93 5.184.55 query35 4.534.544.53 query36 0.660.500.47 query37 0.090.070.07 query38 0.050.040.04 query39 0.040.030.03 query40 0.170.130.13 query41 0.070.030.02 query42 0.030.020.03 query43 0.040.040.02 Total cold run time: 102.54 s Total hot run time: 29.43 s ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2910168667 TPC-DS: Total hot run time: 192678 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 96ca424a4b231b2ab9f9ed80efcfad2e895ff027, data reload: false query1 1405108210631063 query2 6182184318591843 query3 11171 448345294483 query4 54828 25417 23410 23410 query5 5262533 457 457 query6 388 211 206 206 query7 4945500 295 295 query8 311 235 224 224 query9 5988260826432608 query10 393 325 260 260 query11 15032 14996 14803 14803 query12 162 115 107 107 query13 1079552 418 418 query14 10156 622763316227 query15 202 206 181 181 query16 7081667 518 518 query17 1105758 590 590 query18 1555423 318 318 query19 225 208 177 177 query20 140 132 121 121 query21 209 128 123 123 query22 4496453445604534 query23 34112 33260 33265 33260 query24 6779241324222413 query25 466 463 410 410 query26 722 279 147 147 query27 2396537 360 360 query28 2943218121442144 query29 576 573 427 427 query30 271 225 186 186 query31 847 847 785 785 query32 75 67 75 67 query33 475 406 316 316 query34 779 854 536 536 query35 829 846 732 732 query36 938 974 880 880 query37 118 101 87 87 query38 4263431741404140 query39 1544147516271475 query40 220 123 107 107 query41 53 56 51 51 query42 128 109 107 107 query43 500 518 483 483 query44 1353852 865 852 query45 186 173 164 164 query46 860 1017653 653 query47 1856186417881788 query48 416 450 329 329 query49 687 536 440 440 query50 730 711 407 407 query51 4165432742464246 query52 114 113 110 110 query53 239 259 198 198 query54 602 586 509 509 query55 85 85 90 85 query56 315 304 299 299 query57 1226120911711171 query58 274 258 269 258 query59 2657279427192719 query60 337 340 313 313 query61 128 126 159 126 query62 728 731 689 689 query63 235 190 188 188 query64 17841054688 688 query65 4285424442254225 query66 720 403 302 302 query67 16093 15662 15456 15456 query68 7629837 532 532 query69 546 307 264 264 query70 1197110510951095 query71 507 328 286 286 query72 6025473248464732 query73 1410656 360 360 query74 9244915789388938 query75 3800318927032703 query76 42311197774 774 query77 628 379 358 358 query78 10211 10147 91959195 query79 2359816 573 573 query80 601 513 454 454 query81 498 265 219 219 query82 437 129 98 98 query83 251 247 231 231 query84 298 115 92 92 query85 807 359 320 320 query86 400 295 310 295 query87 4313441243444344 query88 3789231223082308 query89 417 318 288 288 query90 1787205 206 205 query91 139 139 116 116 query92 82 63 56 56 query93 1856923 583 583 query94 657 408 308 308 query95 368 297 288 288 query96 498 578 278 278 query97 2737274326382638 query98 236 211 200 200 query99 1416138112531253 Total cold run time: 300798 ms Total hot run time: 192678 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go
Re: [PR] [refine](cast json) [doris]
doris-robot commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2910143576 TPC-H: Total hot run time: 33763 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 96ca424a4b231b2ab9f9ed80efcfad2e895ff027, data reload: false -- Round 1 -- q1 26066 506349834983 q2 2075279 191 191 q3 10497 1244690 690 q4 10240 981 518 518 q5 7616241123002300 q6 190 167 131 131 q7 920 721 613 613 q8 9297125411241124 q9 6762506650995066 q10 6879233218801880 q11 489 310 287 287 q12 340 351 214 214 q13 1 366830853085 q14 232 235 217 217 q15 544 489 473 473 q16 423 437 385 385 q17 608 862 366 366 q18 7953721072507210 q19 1673941 522 522 q20 334 324 219 219 q21 3816257823392339 q22 1067997 950 950 Total cold run time: 115798 ms Total hot run time: 33763 ms - Round 2, with runtime_filter_mode=off - q1 5183507950885079 q2 241 328 228 228 q3 2131268323142314 q4 1394174913541354 q5 4458437544144375 q6 220 173 126 126 q7 2015194417541754 q8 2574255825082508 q9 7257728169426942 q10 3043321227432743 q11 583 516 519 516 q12 655 760 623 623 q13 3465394332473247 q14 298 306 270 270 q15 548 508 515 508 q16 468 481 439 439 q17 1159145013931393 q18 7868772574727472 q19 815 819 963 819 q20 2027200918311831 q21 4830457944344434 q22 11121089978 978 Total cold run time: 52344 ms Total hot run time: 49953 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
Mryange commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2909825416 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
Mryange commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2909818724 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
[PR] [refine](cast json) [doris]
Mryange opened a new pull request, #51261:
URL: https://github.com/apache/doris/pull/51261
### What problem does this PR solve?
```
mysql> select cast(cast('2020-01-01' as date) as json );
+---+
| cast(cast('2020-01-01' as date) as json ) |
+---+
| NULL |
+---+
mysql> select cast(cast('2020-01-01' as date) as json );
+---+
| cast(cast('2020-01-01' as date) as json ) |
+---+
| "2020-01-01" |
+---+
```
Problem Summary:
### Release note
None
### Check List (For Author)
- Test
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason
- Behavior changed:
- [ ] No.
- [ ] Yes.
- Does this need documentation?
- [ ] No.
- [ ] Yes.
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Re: [PR] [refine](cast json) [doris]
Thearas commented on PR #51261: URL: https://github.com/apache/doris/pull/51261#issuecomment-2909818541 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). Please clearly describe your PR: 1. What problem was fixed (it's best to include specific error reporting information). How it was fixed. 2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be. 3. What features were added. Why was this function added? 4. Which code was refactored and why was this part of the code refactored? 5. Which functions were optimized and what is the difference before and after the optimization? -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
