github-actions[bot] closed pull request #38882: [improvement](mtmv) Support to
use view when create mtmv
URL: https://github.com/apache/doris/pull/38882
--
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
github-actions[bot] commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2787915039
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of
keeping the PR queue manageable
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2316946345
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
seawinde commented on code in PR #38882:
URL: https://github.com/apache/doris/pull/38882#discussion_r1735725415
##
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVPlanUtil.java:
##
@@ -83,21 +81,30 @@ public static MTMVRelation generateMTMVRelation(MTMV mtmv,
ConnectContext
seawinde commented on code in PR #38882:
URL: https://github.com/apache/doris/pull/38882#discussion_r1735725415
##
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVPlanUtil.java:
##
@@ -83,21 +81,30 @@ public static MTMVRelation generateMTMVRelation(MTMV mtmv,
ConnectContext
zddr commented on code in PR #38882:
URL: https://github.com/apache/doris/pull/38882#discussion_r1735669916
##
fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/InitMaterializationContextHook.java:
##
@@ -78,7 +78,8 @@ public void initMaterializationContext(
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314797429
ClickBench: Total hot run time: 32.29 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314785817
TPC-DS: Total hot run time: 188480 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314760597
TPC-H: Total hot run time: 38732 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314710979
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314579529
ClickBench: Total hot run time: 31.83 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314567683
TPC-DS: Total hot run time: 193380 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314543083
TPC-H: Total hot run time: 38072 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2314479885
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
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2291298571
if view in mtmv, we always expand the view in analyze. So when query rewrite
by materialized view or refresh the materialized view, the view doesn't exist.
if we want to support rewrit
zddr commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2290436383
`org.apache.doris.mtmv.MTMVPlanUtil#getBaseViews` now will return empty set.
We need to implement it or remove the baseViews variable from MTMVRelation
if not needed
--
This is an autom
github-actions[bot] commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2283634018
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
github-actions[bot] commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2283633951
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2277028678
ClickBench: Total hot run time: 30.7 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
C
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2277024357
TPC-DS: Total hot run time: 204186 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2277015091
TPC-H: Total hot run time: 39419 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2275154696
TPC-H: Total hot run time: 39571 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2275119214
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2271530389
ClickBench: Total hot run time: 29.87 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2271517517
TPC-DS: Total hot run time: 168155 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2271493906
TPC-H: Total hot run time: 41677 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2271455078
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270623028
ClickBench: Total hot run time: 30.45 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270613039
TPC-DS: Total hot run time: 168830 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270593972
TPC-H: Total hot run time: 41413 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270532738
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
seawinde closed pull request #38882: [improvement](mtmv) Support to use view
when create mtmv
URL: https://github.com/apache/doris/pull/38882
--
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 spec
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2270532378
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2268698703
ClickBench: Total hot run time: 30.15 s
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2268687312
TPC-DS: Total hot run time: 168523 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2268663653
TPC-H: Total hot run time: 41386 ms
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100
seawinde commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2268580600
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
doris-robot commented on PR #38882:
URL: https://github.com/apache/doris/pull/38882#issuecomment-2268574182
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+y
seawinde opened a new pull request, #38882:
URL: https://github.com/apache/doris/pull/38882
## Proposed changes
Support to use mv when create async materialized view
Such as view def is as following:
```sql
create view mv as
select o_shippriority, o_
39 matches
Mail list logo
