[
https://issues.apache.org/jira/browse/HIVE-14487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438566#comment-15438566
]
Jesus Camacho Rodriguez edited comment on HIVE-14487 at 7/10/17 12:33 PM:
--------------------------------------------------------------------------
[~ekoifman], thanks for the feedback.
That is fair point and something I had not considered yet; we do not do
anything special in HIVE-14249, which would lead to inconsistent/incorrect
results if a user uses the materialized view while it is being rebuilt. I guess
raising an error should be enough. Then we would need to keep the state for the
materialized view in the metastore? Or do you have any other idea?
I can 1) create a follow-up for this, as HIVE-14249 has passed QA and is ready
to go in, 2) I can add the new logic to HIVE-14249, or 3) I can remove the
logic for REBUILD completely from HIVE-14249 and put it all together in a new
patch. I am inclined to go with 3. What is your take?
was (Author: jcamachorodriguez):
[~ekoifman], thanks for the feedback.
That is fair point and something I had not considered yet; we do not do
anything special in HIVE-14487, which would lead to inconsistent/incorrect
results if a user uses the materialized view while it is being rebuilt. I guess
raising an error should be enough. Then we would need to keep the state for the
materialized view in the metastore? Or do you have any other idea?
I can 1) create a follow-up for this, as HIVE-14487 has passed QA and is ready
to go in, 2) I can add the new logic to HIVE-14487, or 3) I can remove the
logic for REBUILD completely from HIVE-14487 and put it all together in a new
patch. I am inclined to go with 3. What is your take?
> Add REBUILD statement for materialized views
> --------------------------------------------
>
> Key: HIVE-14487
> URL: https://issues.apache.org/jira/browse/HIVE-14487
> Project: Hive
> Issue Type: Sub-task
> Components: Materialized views
> Affects Versions: 2.2.0
> Reporter: Jesus Camacho Rodriguez
>
> Support for rebuilding existing materialized views. The statement is the
> following:
> {code:sql}
> ALTER MATERIALIZED VIEW [db_name.]materialized_view_name REBUILD;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
