[ https://issues.apache.org/jira/browse/HIVE-11846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14803305#comment-14803305 ]
Hive QA commented on HIVE-11846: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12756342/HIVE-11846.01.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 9447 tests executed *Failed tests:* {noformat} org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler org.apache.hive.hcatalog.streaming.TestStreaming.testEndpointConnection {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5312/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5312/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5312/ Messages: {noformat} 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12756342 - PreCommit-HIVE-TRUNK-Build > CliDriver shutdown tries to drop index table again which was already dropped > when dropping the original table > -------------------------------------------------------------------------------------------------------------- > > Key: HIVE-11846 > URL: https://issues.apache.org/jira/browse/HIVE-11846 > Project: Hive > Issue Type: Bug > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Priority: Critical > Attachments: HIVE-11846.01.patch > > > Steps to repro: > {code} > set hive.stats.dbclass=fs; > set hive.stats.autogather=true; > set hive.cbo.enable=true; > DROP TABLE IF EXISTS aa; > CREATE TABLE aa (L_ORDERKEY INT, > L_PARTKEY INT, > L_SUPPKEY INT, > L_LINENUMBER INT, > L_QUANTITY DOUBLE, > L_EXTENDEDPRICE DOUBLE, > L_DISCOUNT DOUBLE, > L_TAX DOUBLE, > L_RETURNFLAG STRING, > L_LINESTATUS STRING, > l_shipdate STRING, > L_COMMITDATE STRING, > L_RECEIPTDATE STRING, > L_SHIPINSTRUCT STRING, > L_SHIPMODE STRING, > L_COMMENT STRING) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY '|'; > LOAD DATA LOCAL INPATH '../../data/files/lineitem.txt' OVERWRITE INTO TABLE > aa; > CREATE INDEX aa_lshipdate_idx ON TABLE aa(l_shipdate) AS > 'org.apache.hadoop.hive.ql.index.AggregateIndexHandler' WITH DEFERRED REBUILD > IDXPROPERTIES("AGGREGATES"="count(l_shipdate)"); > ALTER INDEX aa_lshipdate_idx ON aa REBUILD; > show tables; > explain select l_shipdate, count(l_shipdate) > from aa > group by l_shipdate; > {code} > The problem is that, we create an index table default_aa_lshipdate_idx, > (default is the database name) and it comes after the table aa. Then, it > first drop aa, which will drop default_aa_lshipdate_idx as well as it is > related to aa. It will not find the table default_aa_lshipdate_idx when it > tries to drop it again, which will throw an exception. -- This message was sent by Atlassian JIRA (v6.3.4#6332)