[ https://issues.apache.org/jira/browse/HIVE-21133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16746891#comment-16746891 ]
Hive QA commented on HIVE-21133: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12955460/HIVE-21133.01.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 12 failed/errored test(s), 15662 tests executed *Failed tests:* {noformat} TestHiveKVResultCache - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestHiveSparkClient - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestLocalHiveSparkClient - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestReplicationScenariosIncrementalLoadAcidTables - did not produce a TEST-*.xml file (likely timed out) (batchId=251) TestSmallTableCache - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkInvalidFileFormat - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkJobMonitor - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkPlan - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkSessionManagerImpl - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkTask - did not produce a TEST-*.xml file (likely timed out) (batchId=319) TestSparkUtilities - did not produce a TEST-*.xml file (likely timed out) (batchId=319) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[simulated_materialized_view_rewrite] (batchId=160) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15695/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15695/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15695/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 12 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12955460 - PreCommit-HIVE-Build > Add simulated materialized views useful for rewriting debugging > --------------------------------------------------------------- > > Key: HIVE-21133 > URL: https://issues.apache.org/jira/browse/HIVE-21133 > Project: Hive > Issue Type: Improvement > Components: Materialized views > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-21133.01.patch, HIVE-21133.patch > > > Implement simulated materialized views, useful to check whether a certain > rewriting will be triggered. Simulated materialized views definitions will be > stored in the user session, and they will only be used when simulation mode > is enabled and user runs {{explain cbo}} / {{explain cbo extended}}. > {code} > set hive.simulation.enable=true; > create simulated materialized view mv1_n2 as > select * from emps_n3 where empid < 150; > explain cbo > select * > from (select * from emps_n3 where empid < 120) t > join depts_n2 using (deptno); > drop simulated materialized view mv1_n2; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)