[jira] [Comment Edited] (HIVE-14487) Add REBUILD statement for materialized views

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

    [ 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)