[ https://issues.apache.org/jira/browse/HIVE-14487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438566#comment-15438566 ]
Jesus Camacho Rodriguez commented on HIVE-14487: ------------------------------------------------ [~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 > Assignee: Alan Gates > > 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.3.4#6332)