Re: [PR] [feature](Nereids) covert predicate to SARGABLE [doris]

2023-10-11 Thread via GitHub
jackwener merged PR #25180: URL: https://github.com/apache/doris/pull/25180 -- 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-unsubscr...@doris.ap

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-11 Thread via GitHub
github-actions[bot] commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1757313305 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 UR

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-11 Thread via GitHub
github-actions[bot] commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1757313244 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 GitHu

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-11 Thread via GitHub
englefly commented on code in PR #25180: URL: https://github.com/apache/doris/pull/25180#discussion_r1354594753 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/SimplifyArithmeticComparisonRule.java: ## @@ -40,68 +58,90 @@ public class SimplifyArithme

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-11 Thread via GitHub
englefly commented on code in PR #25180: URL: https://github.com/apache/doris/pull/25180#discussion_r1354594753 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/expression/rules/SimplifyArithmeticComparisonRule.java: ## @@ -40,68 +58,90 @@ public class SimplifyArithme

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1756856860 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 44.93 seconds stream load tsv: 557 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1756826454 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 uns

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1754786544 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 45.78 seconds stream load tsv: 578 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1754720513 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 45.85 seconds stream load tsv: 573 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1754697005 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 uns

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-10 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1754640685 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 uns

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1753037286 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 45.84 seconds stream load tsv: 562 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1752964904 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 uns

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1752929362 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 45.49 seconds stream load tsv: 557 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1752879511 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 uns

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
doris-robot commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1752707553 (From new machine)TeamCity pipeline, clickbench performance test result: the sum of best hot time: 45.65 seconds stream load tsv: 558 seconds loaded 74807831229 Bytes,

Re: [PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
XieJiann commented on PR #25180: URL: https://github.com/apache/doris/pull/25180#issuecomment-1752612711 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 uns

[PR] [feature](Nereids) covert predicate to sargable [doris]

2023-10-09 Thread via GitHub
XieJiann opened a new pull request, #25180: URL: https://github.com/apache/doris/pull/25180 ## Proposed changes covert predicate to sargable such as ``` (col1 + 1 - 2) / 3 = 4 ==> col1 = (((4 * 3) + 2) - 1) ``` ## Further comments If this is a rela