Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-24 Thread via GitHub
morrySnow merged PR #33647: URL: https://github.com/apache/doris/pull/33647 -- 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:

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-23 Thread via GitHub
feiniaofeiafei commented on code in PR #33647: URL: https://github.com/apache/doris/pull/33647#discussion_r1577168844 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/SimplifyWindowExpression.java: ## @@ -0,0 +1,129 @@ +// Licensed to the Apache Software

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-23 Thread via GitHub
feiniaofeiafei commented on code in PR #33647: URL: https://github.com/apache/doris/pull/33647#discussion_r1577166392 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/SimplifyWindowExpression.java: ## @@ -0,0 +1,129 @@ +// Licensed to the Apache Software

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-18 Thread via GitHub
github-actions[bot] commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2065655893 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-18 Thread via GitHub
github-actions[bot] commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2065655866 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-18 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2063441193 run p0 -- 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-18 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2063430807 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-18 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2063105055 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-17 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2062945123 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-17 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2061089971 TPC-H: Total hot run time: 38169 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-17 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2061011970 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-17 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2060919177 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-17 Thread via GitHub
feiniaofeiafei commented on code in PR #33647: URL: https://github.com/apache/doris/pull/33647#discussion_r1568432106 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/SimplifyWindowExpression.java: ## @@ -0,0 +1,129 @@ +// Licensed to the Apache Software

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-16 Thread via GitHub
morrySnow commented on code in PR #33647: URL: https://github.com/apache/doris/pull/33647#discussion_r1568188532 ## fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/SimplifyWindowExpression.java: ## @@ -0,0 +1,129 @@ +// Licensed to the Apache Software Foundation

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-16 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058410453 run p0 -- 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-16 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058295618 run p0 -- 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058218378 TPC-H: Total hot run time: 38581 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058205959 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058147163 run external regression -- 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058147100 run external -- 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058104288 run external regression -- 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

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2058102478 run external -- 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056562608 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit f4360aad888b485f062fbc2345a238233fa4fedf with default session variables Stream

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056557164 ClickBench: Total hot run time: 30.57 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056547807 TPC-DS: Total hot run time: 182733 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056524293 TPC-H: Total hot run time: 38228 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056438933 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056222483 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 549420dde3854b83e974ad71cc0c6d24b5d18105 with default session variables Stream

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056207815 ClickBench: Total hot run time: 30.08 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056182093 TPC-DS: Total hot run time: 183515 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2056128330 TPC-H: Total hot run time: 38584 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-15 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2055898918 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2055242673 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit e2832b9840d9e9a2a8af3babdd30e6acc26d04c3 with default session variables Stream

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2055226536 ClickBench: Total hot run time: 30.26 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2055197949 TPC-DS: Total hot run time: 184160 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2055137450 TPC-H: Total hot run time: 38228 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
feiniaofeiafei commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2054949386 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.

Re: [PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
doris-robot commented on PR #33647: URL: https://github.com/apache/doris/pull/33647#issuecomment-2054948637 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your

[PR] [Feat](nereids) add transform rule SimplifyWindowExpression [doris]

2024-04-14 Thread via GitHub
feiniaofeiafei opened a new pull request, #33647: URL: https://github.com/apache/doris/pull/33647 rewrite func(para) over (partition by unique_keys) 1. func() is count(non-null) or rank/dense_rank/row_number -> 1 2. func(para) is min/max/sum/avg/first_value/last_value -> para e.g