[ https://issues.apache.org/jira/browse/HIVE-2568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13151815#comment-13151815 ]
Hudson commented on HIVE-2568: ------------------------------ Integrated in Hive-0.8.0-SNAPSHOT-h0.21 #98 (See [https://builds.apache.org/job/Hive-0.8.0-SNAPSHOT-h0.21/98/]) backporting HIVE-2568 (rev. 1201091) nzhang : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1202945 Files : * /hive/branches/branch-0.8 * /hive/branches/branch-0.8/README.txt * /hive/branches/branch-0.8/contrib/src/java/org/apache/hadoop/hive/contrib/udaf/example/UDAFExampleMax.java * /hive/branches/branch-0.8/contrib/src/java/org/apache/hadoop/hive/contrib/udaf/example/UDAFExampleMin.java * /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/io/NonSyncDataInputBuffer.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/io/NonSyncDataOutputBuffer.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/DefaultGraphWalker.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/DefaultRuleDispatcher.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/Dispatcher.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/GraphWalker.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/NodeProcessor.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/NodeProcessorCtx.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/Rule.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/lib/RuleRegExp.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/parse/JoinCond.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/parse/JoinType.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/AggregationDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CollectDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CopyWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateFunctionDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableLikeDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateViewDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/DDLDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/DescFunctionDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/DescTableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/DropFunctionDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/DropTableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/Explain.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExplainWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExplosionDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeColumnDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeConstantDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeFieldDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeGenericFuncDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeNullDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ExtractDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/FetchWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/FileSinkDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/FilterDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ForwardDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/GroupByDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/JoinCondDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/LateralViewJoinDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/LimitDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadFileDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadTableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/MapredLocalWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/MoveWork.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/PartitionDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ReduceSinkDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/SchemaDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ScriptDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/SelectDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowFunctionsDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowPartitionsDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowTableStatusDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowTablesDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/TableDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/TableScanDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/UDTFDesc.java * /hive/branches/branch-0.8/ql/src/java/org/apache/hadoop/hive/ql/plan/UnionDesc.java * /hive/branches/branch-0.8/serde/README.txt * /hive/branches/branch-0.8/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyFactory.java * /hive/branches/branch-0.8/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo > HIVE-2246 upgrade script needs to drop foreign key in COLUMNS_OLD > ----------------------------------------------------------------- > > Key: HIVE-2568 > URL: https://issues.apache.org/jira/browse/HIVE-2568 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.8.0 > Reporter: Ning Zhang > Assignee: Ning Zhang > Priority: Blocker > Fix For: 0.8.0, 0.9.0 > > Attachments: D369.1.patch > > > One more bug in the MySQL metastore upgrade script: the foreign key in > COLUMNS needs to be dropped, otherwise drop_partition will fail because the > SDS row cannot be deleted due to the foreign key constraint. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira