[
https://issues.apache.org/jira/browse/CALCITE-4770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17413685#comment-17413685
]
Xurenhe commented on CALCITE-4770:
----------------------------------
Hi [~asolimando]
Thanks for your valuable suggestion.
The issue aims to reduce num of mvs, which enter in `SubstitutionVisitor#go`.
Now, there are two ways to rewriting query by mv-matching, as follows
* Method1: *`SubstitutionVisitor#go`*, which is executed by pattern of RelNode
bottom-up.
* Method2: *`MaterializedViewRule#perform`*, which is based on analyzing
semantics of RelNode.(Based on [Optimizing queries using materialized views: a
practical, scalable solution|https://dl.acm.org/doi/10.1145/375663.375706])
----
As far as I know, `SubstitutionVisitor#go` don't support to generate a RelNode
of Union to fill the rest of the data, after rewriting query.
So, the effect is not very good for `SubstitutionVisitor#go`, if using
[paper|https://dl.acm.org/doi/10.1145/375663.375706] to reduce mvs.
----
This is my view after reading the document.
I'm looking forward to your reply.
> Design of SearchMvService
> -------------------------
>
> Key: CALCITE-4770
> URL: https://issues.apache.org/jira/browse/CALCITE-4770
> Project: Calcite
> Issue Type: New Feature
> Reporter: xzh_dz
> Priority: Major
>
> In the data system, materialized view can speed up SQL query. Materialized
> view represents the pre-calculated SQL logic of the target table and contains
> real data. In the project, we use materialized views to speed up SQL queries,
> use the materialized view recognition technology to identify materialized
> views, and enhance the ability of materialized recognition. However, with
> more and more materialized views , materialized view recognition takes a lot
> of time, which seriously affects the performance of SQL queries. With this
> problem, we propose a design of accurate search materialized view based on
> operator features.
> DOC：[Design of
> SearchMvService|[https://docs.google.com/document/d/1mmAsK_uW-fBs893JERP1gspMurX2lNXcVGeesP4XUqQ/edit]]
> Welcome to discuss and expect more feedback,thank you.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
