[ 
https://issues.apache.org/jira/browse/HIVE-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13459921#comment-13459921
 ] 

Carl Steinbach commented on HIVE-3463:
--------------------------------------

I strongly second Ashutosh's second point. It looks like DN does support this 
feature. Check out the 'delete-action' attribute for the 'field' element 
described here:

http://www.datanucleus.org/products/datanucleus/jdo/metadata_xml.html#field
                
> 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

Reply via email to