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