[ https://issues.apache.org/jira/browse/HIVE-8863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14220834#comment-14220834 ]
Hive QA commented on HIVE-8863: ------------------------------- {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/12682706/HIVE-8863.1.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 6666 tests executed *Failed tests:* {noformat} org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyCommit {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1855/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1855/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-1855/ 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: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12682706 - PreCommit-HIVE-TRUNK-Build > Cannot drop table with uppercase name after "compute statistics for columns" > ---------------------------------------------------------------------------- > > Key: HIVE-8863 > URL: https://issues.apache.org/jira/browse/HIVE-8863 > Project: Hive > Issue Type: Bug > Components: Metastore > Reporter: Juan Yu > Assignee: Chaoyu Tang > Attachments: HIVE-8863.1.patch, HIVE-8863.patch > > > Create a table with uppercase name Test, > run "analyze table Test compute statistics for columns col1" > After this, you cannot drop the table by > drop table Test; > Got error: > NestedThrowablesStackTrace: > java.sql.BatchUpdateException: Cannot delete or update a parent row: a > foreign key constraint fails ("hive2"."TAB_COL_STATS", CONSTRAINT > "TAB_COL_STATS_FK" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS" ("TBL_ID")) > workaround is to use lowercase table name > drop table test; -- This message was sent by Atlassian JIRA (v6.3.4#6332)