Re: [PR] [fix](nereids) fix can not prune dereference expression [doris]
hello-stephen commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3606085136 # FE Regression Coverage Report Increment line coverage ` 100.00% (3/3)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58657_31421a8699316a7afde5865295e15c6f9fc17c34_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58657_31421a8699316a7afde5865295e15c6f9fc17c34_merge_fe/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: [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] [fix](nereids) fix can not prune dereference expression [doris]
924060929 merged PR #58657: URL: https://github.com/apache/doris/pull/58657 -- 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] [fix](nereids) fix can not prune dereference expression [doris]
github-actions[bot] commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3606018461 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: [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] [fix](nereids) fix can not prune dereference expression [doris]
doris-robot commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605491060 ClickBench: Total hot run time: 27.55 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 31421a8699316a7afde5865295e15c6f9fc17c34, data reload: false query1 0.050.050.05 query2 0.100.050.05 query3 0.250.090.08 query4 1.610.110.11 query5 0.280.260.25 query6 1.180.650.65 query7 0.040.030.02 query8 0.060.040.05 query9 0.570.520.50 query10 0.560.550.56 query11 0.160.100.11 query12 0.150.110.12 query13 0.620.610.61 query14 0.991.000.99 query15 0.810.800.80 query16 0.420.420.40 query17 1.001.031.08 query18 0.230.220.21 query19 1.871.941.78 query20 0.010.010.01 query21 15.44 0.300.14 query22 4.850.050.05 query23 16.02 0.280.10 query24 0.950.460.40 query25 0.090.080.04 query26 0.140.130.13 query27 0.060.040.06 query28 4.091.231.04 query29 12.66 4.093.25 query30 0.280.140.12 query31 2.820.620.41 query32 3.230.580.46 query33 3.103.053.05 query34 16.85 5.234.57 query35 4.534.554.56 query36 0.680.500.49 query37 0.100.070.07 query38 0.080.040.04 query39 0.050.030.04 query40 0.190.160.14 query41 0.080.030.04 query42 0.050.030.03 query43 0.050.040.03 Total cold run time: 97.35 s Total hot run time: 27.55 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] [fix](nereids) fix can not prune dereference expression [doris]
doris-robot commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605476980 TPC-DS: Total hot run time: 182710 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 31421a8699316a7afde5865295e15c6f9fc17c34, data reload: false query1 1050411 402 402 query2 6611118611911186 query3 6741237 226 226 query4 25575 23401 22773 22773 query5 4463678 522 522 query6 346 255 237 237 query7 4647546 320 320 query8 323 253 237 237 query9 8695267426702670 query10 557 353 313 313 query11 15143 15109 14963 14963 query12 188 126 119 119 query13 1711586 443 443 query14 9775610060676067 query15 210 198 191 191 query16 7691710 547 547 query17 1257791 660 660 query18 2048442 354 354 query19 224 218 193 193 query20 128 126 125 125 query21 222 140 112 112 query22 3982391737663766 query23 33161 32180 32138 32138 query24 8498248625032486 query25 648 562 505 505 query26 1251289 179 179 query27 2702526 353 353 query28 4355222321992199 query29 835 661 552 552 query30 326 246 217 217 query31 874 723 632 632 query32 94 78 77 77 query33 626 407 394 394 query34 832 897 567 567 query35 808 836 739 739 query36 886 941 838 838 query37 126 114 91 91 query38 3890392737763776 query39 1464142214051405 query40 238 140 121 121 query41 76 63 62 62 query42 126 120 121 120 query43 447 461 422 422 query44 1352780 771 771 query45 202 200 183 183 query46 906 1019656 656 query47 1667171516181618 query48 412 437 337 337 query49 782 495 422 422 query50 687 695 427 427 query51 3878394839283928 query52 114 119 107 107 query53 264 271 199 199 query54 320 305 302 302 query55 98 95 95 95 query56 333 318 340 318 query57 1128115010961096 query58 292 281 267 267 query59 2292242222822282 query60 351 388 329 329 query61 160 154 159 154 query62 778 731 667 667 query63 240 199 204 199 query64 44601281937 937 query65 4086394739553947 query66 1107456 349 349 query67 15126 15154 14797 14797 query68 8589995 648 648 query69 524 371 314 314 query70 1109976 981 976 query71 505 349 322 322 query72 5813509148734873 query73 737 584 349 349 query74 8967889086548654 query75 3666307325482548 query76 37831148767 767 query77 818 415 318 318 query78 9581960989488948 query79 2224836 588 588 query80 668 621 488 488 query81 513 273 245 245 query82 467 148 113 113 query83 274 264 267 264 query84 258 116 96 96 query85 953 497 445 445 query86 401 331 277 277 query87 4102415639713971 query88 4049226922532253 query89 390 338 295 295 query90 1952220 215 215 query91 175 171 141 141 query92 85 70 68 68 query93 18101040677 677 query94 730 459 354 354 query95 506 406 413 406 query96 546 564 285 285 query97 2638268426272627 query98 249 214 220 214 query99 1432141512851285 Total cold run time: 273399 ms Total hot run time: 182710 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] [fix](nereids) fix can not prune dereference expression [doris]
doris-robot commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605447045 TPC-H: Total hot run time: 34462 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 31421a8699316a7afde5865295e15c6f9fc17c34, data reload: false -- Round 1 -- q1 17647 514348604860 q2 2065313 212 212 q3 10249 1346754 754 q4 10224 870 319 319 q5 7545252222002200 q6 191 177 139 139 q7 972 805 645 645 q8 9361145411021102 q9 7196537053305330 q10 6859224218171817 q11 535 309 300 300 q12 355 382 242 242 q13 17769 370530593059 q14 230 236 218 218 q15 586 519 511 511 q16 902 858 822 822 q17 675 764 543 543 q18 8136712570057005 q19 1098956 608 608 q20 363 357 237 237 q21 3990350225842584 q22 10481033955 955 Total cold run time: 107996 ms Total hot run time: 34462 ms - Round 2, with runtime_filter_mode=off - q1 5028499449714971 q2 338 401 320 320 q3 2184267422832283 q4 1362180513421342 q5 4269472145964596 q6 217 180 130 130 q7 2100202918931893 q8 2713260325572557 q9 7591749274967492 q10 3097327228992899 q11 590 536 506 506 q12 853 743 614 614 q13 3541392733573357 q14 300 323 279 279 q15 563 514 502 502 q16 934 947 905 905 q17 1204138414571384 q18 7928769775817581 q19 908 858 896 858 q20 2079207119571957 q21 5000440142384238 q22 10901028978 978 Total cold run time: 53889 ms Total hot run time: 51642 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] [fix](nereids) fix can not prune dereference expression [doris]
924060929 commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605330870 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] [fix](nereids) fix can not prune dereference expression [doris]
924060929 commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605270382 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] [fix](nereids) fix can not prune dereference expression [doris]
doris-robot commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605040517 ClickBench: Total hot run time: 27.54 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 986f8cf76bda729871a12d51c3b95fdcaf8c2d0c, data reload: false query1 0.050.050.05 query2 0.100.060.05 query3 0.260.090.09 query4 1.620.110.11 query5 0.260.240.25 query6 1.170.650.63 query7 0.030.030.02 query8 0.050.040.04 query9 0.590.500.50 query10 0.560.560.55 query11 0.170.110.11 query12 0.150.110.13 query13 0.620.590.60 query14 0.990.980.99 query15 0.830.790.79 query16 0.400.410.39 query17 1.041.041.08 query18 0.230.210.21 query19 1.911.841.78 query20 0.010.020.01 query21 15.45 0.280.14 query22 4.980.050.05 query23 16.08 0.270.10 query24 1.270.660.71 query25 0.090.100.04 query26 0.140.150.12 query27 0.060.060.05 query28 5.061.191.01 query29 12.56 4.023.20 query30 0.290.140.12 query31 2.810.620.38 query32 3.240.550.46 query33 3.043.043.01 query34 16.90 5.224.56 query35 4.594.504.52 query36 0.670.500.48 query37 0.110.070.07 query38 0.070.050.04 query39 0.040.030.03 query40 0.170.140.15 query41 0.090.040.03 query42 0.050.030.03 query43 0.040.040.03 Total cold run time: 98.84 s Total hot run time: 27.54 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] [fix](nereids) fix can not prune dereference expression [doris]
doris-robot commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3605010833 TPC-H: Total hot run time: 34099 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 986f8cf76bda729871a12d51c3b95fdcaf8c2d0c, data reload: false -- Round 1 -- q1 17626 498448894889 q2 2084321 204 204 q3 10195 1311741 741 q4 10242 871 312 312 q5 7514240721162116 q6 183 168 136 136 q7 958 785 625 625 q8 9358144110851085 q9 6951534553245324 q10 6780217917831783 q11 528 312 284 284 q12 341 369 218 218 q13 17756 365929982998 q14 243 236 208 208 q15 574 515 510 510 q16 887 865 809 809 q17 666 791 545 545 q18 7425708770277027 q19 1091965 602 602 q20 366 364 226 226 q21 3932338225042504 q22 10571014953 953 Total cold run time: 106757 ms Total hot run time: 34099 ms - Round 2, with runtime_filter_mode=off - q1 4962491849034903 q2 338 400 328 328 q3 2142263822762276 q4 1300175112771277 q5 4178436646484366 q6 219 184 129 129 q7 2043197918631863 q8 2665258025412541 q9 7452751174637463 q10 3044327628112811 q11 595 520 505 505 q12 706 773 633 633 q13 3447388233493349 q14 310 322 302 302 q15 555 491 535 491 q16 925 910 869 869 q17 1207147214341434 q18 8160770874947494 q19 882 885 903 885 q20 2041208619191919 q21 4891435641254125 q22 10951076975 975 Total cold run time: 53157 ms Total hot run time: 50938 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] [fix](nereids) fix can not prune dereference expression [doris]
github-actions[bot] commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3604975248 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: [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] [fix](nereids) fix can not prune dereference expression [doris]
github-actions[bot] commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3604974865 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: [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] [fix](nereids) fix can not prune dereference expression [doris]
Thearas commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3604966926 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]
Re: [PR] [fix](nereids) fix can not prune dereference expression [doris]
924060929 commented on PR #58657: URL: https://github.com/apache/doris/pull/58657#issuecomment-3604967030 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] [fix](nereids) fix can not prune dereference expression [doris]
924060929 opened a new pull request, #58657: URL: https://github.com/apache/doris/pull/58657 ### What problem does this PR solve? fix can not prune dereference expression, introduced by #57532 ### Check List (For Author) - Test - [ ] Regression test - [x] 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: - [x] No. - [ ] Yes. - Does this need documentation? - [x] 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]
