You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2023/01/16 02:18:53 UTC
[GitHub] [doris] chenlinzhong opened a new pull request, #15948: [mtmv](opt) mtmv task use original query stmt so that user can set var more flexible
chenlinzhong opened a new pull request, #15948:
URL: https://github.com/apache/doris/pull/15948
# Proposed changes
mtmv task use original query stmt so that user can set var more flexible, for example set query_timeout, exec_mem_limit etc
though ``CREATE MATERIALIZED VIEW`` statement
```
CREATE MATERIALIZED VIEW multi_mv
BUILD IMMEDIATE
REFRESH COMPLETE
start with "2022-10-27 19:35:00"
next 60 second
KEY(username)
DISTRIBUTED BY HASH (username) buckets 1
PROPERTIES ('replication_num' = '1')
AS
select /*+set_var(query_timeout=1000)*/ t_user.username, t_user_pv.pv from t_user, t_user_pv where t_user.id=t_user_pv.id;
```
mtmv task will use the original stmt when insert data to table
```
select /*+set_var(query_timeout=1000)*/ t_user.username, t_user_pv.pv from t_user, t_user_pv where t_user.id=t_user_pv.id;
```
instead of
```
select t_user.username, t_user_pv.pv from t_user, t_user_pv where t_user.id=t_user_pv.id;
```
## Problem summary
Describe your changes.
## Checklist(Required)
1. Does it affect the original behavior:
- [ ] Yes
- [ ] No
- [ ] I don't know
2. Has unit tests been added:
- [ ] Yes
- [ ] No
- [ ] No Need
3. Has document been added or modified:
- [ ] Yes
- [ ] No
- [ ] No Need
4. Does it need to update dependencies:
- [ ] Yes
- [ ] No
5. Are there any changes that cannot be rolled back:
- [ ] Yes (If Yes, please explain WHY)
- [ ] No
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] chenlinzhong closed pull request #15948: [MTMV](opt) mtmv task use original query stmt so that user can set var more flexible
Posted by GitBox <gi...@apache.org>.
chenlinzhong closed pull request #15948: [MTMV](opt) mtmv task use original query stmt so that user can set var more flexible
URL: https://github.com/apache/doris/pull/15948
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org