[
https://issues.apache.org/jira/browse/HIVE-25066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17335278#comment-17335278
]
Krisztian Kasa commented on HIVE-25066:
---------------------------------------
[~jcamachorodriguez]
Show materialized views currently prints the following data: *Rewriting
Enabled* and *Mode*
{code:java}
# MV Name Rewriting Enabled Mode
shtb_full_view2 Yes Manual refresh (Valid for 5min)
shtb_test1_view1 No Manual refresh
{code}
These all are coming from the Metastore.
However to determine whether an MV can be rebuild incrementally the MV
definition plan must be inspected:
1. Parse definition query text and create CBO plan.
2. Run MaterializedViewRewritingRelVisitor.
In case the MV is enabled for rewrite CBO plan can be pulled from
HiveMaterializedViewsRegistry.
Plan inspection can be done
1. when the command *SHOW MATERIALIZED VIEWS* executed
OR
2. At MV creation and save the result into metasore
Which approach should we take?
> Show whether a materialized view supports incremental review or not
> -------------------------------------------------------------------
>
> Key: HIVE-25066
> URL: https://issues.apache.org/jira/browse/HIVE-25066
> Project: Hive
> Issue Type: Improvement
> Components: Materialized views
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Fix For: 4.0.0
>
>
> Add information about whether a materialized view supports incremental
> rebuild or not in an additional column in
> {code:java}
> SHOW MATERIALIZED VIEWS
> {code}
> statement.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
