[
https://issues.apache.org/jira/browse/HIVE-23836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Mollitor updated HIVE-23836:
----------------------------------
Description:
{quote}
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".
{quote}
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:
{code:sql|title=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;
{code}
https://github.com/apache/hive/blob/65cf6957cf9432277a096f91b40985237274579f/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql#L452
was:
{quote}
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".
{quote}
http://www.datanucleus.org/products/accessplatform/jdo/persistence.html#dependent_fields
http://www.datanucleus.org/products/datanucleus/jdo/persistence.html#_deleting_an_object
> Make "cols" dependent so that it cascade deletes
> ------------------------------------------------
>
> Key: HIVE-23836
> URL: https://issues.apache.org/jira/browse/HIVE-23836
> Project: Hive
> Issue Type: Bug
> Reporter: David Mollitor
> Assignee: David Mollitor
> Priority: Minor
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {quote}
> 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".
> {quote}
> 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:
> {code:sql|title=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;
> {code}
> https://github.com/apache/hive/blob/65cf6957cf9432277a096f91b40985237274579f/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql#L452
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
