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 2020/08/04 15:16:45 UTC
[GitHub] [incubator-doris] HangyuanLiu opened a new issue #4252: Support more materialized view syntax
HangyuanLiu opened a new issue #4252:
URL: https://github.com/apache/incubator-doris/issues/4252
Consider that future materialized views may contain multiple tables (currently limited to a single table).
The syntax associated with materialized views should not inherit from the original ROLLUP syntax or be table level. It should be at the database level.
- Create
create materialized view as <select_statement>
- Drop
drop materialized view on database
- Show
show materialized view on database
- Alter
show alter materialized view on database
The problem to be solved is that the materialized views under the same database may have the same name. To solve this problem. The newly created materialized view will perform a uniqueness check, while the original materialized view will display "table_name + mv_name" in the Show Materialized View on Database as the name of the materialized view.
----------------------------------------------------------------
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.
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] [incubator-doris] EmmyMiao87 commented on issue #4252: Support more materialized view syntax
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #4252:
URL: https://github.com/apache/incubator-doris/issues/4252#issuecomment-668944703
+ Alter
Alter materialized view on database.
The second question is that how to compatible with existing materialized view and rollup logic.
For example, user create a rollup job by create materialized view stmt with only mv_name.
If user wants to drop materialized view by mv_name, the stmt will throw error.
----------------------------------------------------------------
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.
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