[jira] [Commented] (HIVE-15018) ALTER rewriting flag in materialized view
[ https://issues.apache.org/jira/browse/HIVE-15018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16258776#comment-16258776 ] Lefty Leverenz commented on HIVE-15018: --- Doc note: This needs to be documented in the wiki. * [DDL | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] Added a TODOC3.0 label. > ALTER rewriting flag in materialized view > -- > > Key: HIVE-15018 > URL: https://issues.apache.org/jira/browse/HIVE-15018 > Project: Hive > Issue Type: Sub-task > Components: Materialized views >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Labels: TODOC3.0 > Fix For: 3.0.0 > > Attachments: HIVE-15018.01.patch, HIVE-15018.patch > > > We should extend the ALTER statement in case we want to change the rewriting > behavior of the materialized view after we have created it. > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name DISABLE REWRITE; > {code} > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name ENABLE REWRITE; > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-15018) ALTER rewriting flag in materialized view
[ https://issues.apache.org/jira/browse/HIVE-15018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16255910#comment-16255910 ] Ashutosh Chauhan commented on HIVE-15018: - +1 > ALTER rewriting flag in materialized view > -- > > Key: HIVE-15018 > URL: https://issues.apache.org/jira/browse/HIVE-15018 > Project: Hive > Issue Type: Sub-task > Components: Materialized views >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-15018.01.patch, HIVE-15018.patch > > > We should extend the ALTER statement in case we want to change the rewriting > behavior of the materialized view after we have created it. > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name DISABLE REWRITE; > {code} > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name ENABLE REWRITE; > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-15018) ALTER rewriting flag in materialized view
[ https://issues.apache.org/jira/browse/HIVE-15018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16252973#comment-16252973 ] Hive QA commented on HIVE-15018: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12897617/HIVE-15018.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 13 failed/errored test(s), 11384 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[materialized_view_create_rewrite] (batchId=243) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_sortmerge_join_2] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_showlocks] (batchId=77) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[unionDistinct_1] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata] (batchId=162) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ppd_union_view] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] (batchId=156) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_dynamic_partition_pruning] (batchId=173) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_use_op_stats] (batchId=173) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_multi] (batchId=111) org.apache.hadoop.hive.cli.control.TestDanglingQOuts.checkDanglingQOut (batchId=206) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints (batchId=223) org.apache.hadoop.hive.ql.security.authorization.plugin.TestHiveOperationType.checkHiveOperationTypeMatch (batchId=286) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/7817/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/7817/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-7817/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 13 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12897617 - PreCommit-HIVE-Build > ALTER rewriting flag in materialized view > -- > > Key: HIVE-15018 > URL: https://issues.apache.org/jira/browse/HIVE-15018 > Project: Hive > Issue Type: Sub-task > Components: Materialized views >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-15018.patch > > > We should extend the ALTER statement in case we want to change the rewriting > behavior of the materialized view after we have created it. > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name DISABLE REWRITE; > {code} > {code:sql} > ALTER MATERIALIZED VIEW [db_name.]materialized_view_name ENABLE REWRITE; > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)