[ https://issues.apache.org/jira/browse/HIVE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463651#comment-13463651 ]
Carl Steinbach commented on HIVE-3463: -------------------------------------- I'm opposed to only modifying the schema scripts (without updating JDO) unless we can prove that DN doesn't support cascading deletes via JDO. The relations that we need to tag with cascading deletes can be inferred by mapping the schema back to the original JDO file. > Add CASCADING to MySQL's InnoDB schema > -------------------------------------- > > Key: HIVE-3463 > URL: https://issues.apache.org/jira/browse/HIVE-3463 > Project: Hive > Issue Type: Improvement > Components: Metastore > Affects Versions: 0.9.0 > Reporter: Alexander Alten-Lorenz > Assignee: Alexander Alten-Lorenz > > Cascading could help to cleanup the tables when a FK is deleted. > http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira