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/04/17 09:31:31 UTC
[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #3344: Materialized
View 2.0
EmmyMiao87 opened a new issue #3344: Materialized View 2.0
URL: https://github.com/apache/incubator-doris/issues/3344
#The status of materialized view 1.0
In the present, we have supported the materialized views in Doris 0.12 version. The materialized view selector supports to select the most efficient mv and rewrite the SQL to query against the selected mv instead of the base table.
For query results contain a small number of rows where the original table has a large amount of data, the performance can reach the 5X to 100X times depends on the cardinality of the data.
The aggregate functions supported by the materialized view in 0.12 include: sum, min, max.
However, the aggregate functions supported by the current materialized view are not rich enough to fully cover the user's scene.
For example, in the `Order` scenario, user needs to analyze the number of orders in different dimensions.
Another example is the count_d istinct function is used for analyzing PV and UV data in website traffic.
#The goal of materialized view 2.0
In order to support more scenarios, the materialized view 2.0 will support the following functions:
1. Materialized view supports aggregate functions: count, count_distinct (bitmap and hll)
2. Support to create materialized views of the same column with different aggregate functions. For example: select k1, sum (v1), min (v1) from table group by k1
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #3344: [Proposal] Materialized View 2.0
Posted by GitBox <gi...@apache.org>.
morningman closed issue #3344:
URL: https://github.com/apache/incubator-doris/issues/3344
----------------------------------------------------------------
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 closed issue #3344: [Proposal] Materialized View 2.0
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 closed issue #3344:
URL: https://github.com/apache/incubator-doris/issues/3344
----------------------------------------------------------------
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] morningman commented on issue #3344: [Proposal] Materialized View 2.0
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3344:
URL: https://github.com/apache/incubator-doris/issues/3344#issuecomment-619562263
@EmmyMiao87
Looking forward your PR.
And I think AVG method could be supported in next version.
----------------------------------------------------------------
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