[HIVE-23836] Make "cols" dependent so that it cascade deletes

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: David Mollitor
• Reporter: David Mollitor
• Created: 10/Jul/20 15:15
• Updated: 17/Nov/22 08:48
• Resolved: 20/Jul/20 13:31

Description

If you want the deletion of a persistent object to cause the deletion of related objects then you need to mark the related fields in the mapping to be "dependent".

http://www.datanucleus.org/products/accessplatform/jdo/persistence.html#dependent_fields
http://www.datanucleus.org/products/datanucleus/jdo/persistence.html#_deleting_an_object

The database won't do it:

Derby Schema

ALTER TABLE "APP"."COLUMNS_V2" ADD CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID") REFERENCES "APP"."CDS" ("CD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;

https://github.com/apache/hive/blob/65cf6957cf9432277a096f91b40985237274579f/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql#L452

Issue Links

• is related to: HIVE-23363 Upgrade DataNucleus dependency to 5.2
• links to: GitHub Pull Request #1239