[
https://issues.apache.org/jira/browse/HIVE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463554#comment-13463554
]
Alexander Alten-Lorenz commented on HIVE-3463:
----------------------------------------------
Yes, we have to patch the upgrade scripts as well the jdo package (since the db
will created if not present). But we've to know which relations we need to
implement cascading. Any thoughts?
> 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
