Failure to delete containers (with delete references) using CLI command 'delete'

[Stefs-2142]

Error rise when attempting delete metadata using CLI command 'delete'
Same with all flags --soft, --hard, --force

Failed to execute operation
java.lang.UnsupportedOperationException: Only upsert operation is supported

To Reproduce
Steps to reproduce the behavior:

1. Setup Datahub CLI
2. Set env via datahub init
3. run datahub delete --urn "urn:li:container:5f38c5bcfb279844c5471dd926da13e7"
4. See error

Expected behavior
Metadata deleted

Desktop:

• OS: [e.g. Linux Mint 20.2 Uma 64-bit]

Server:

• Datahub [0.8.43]

Type of entity:

• Container

Additional context
datahub-gms.log
In attach gms log with error trace

[etadelta222]

I've run into same error.

Datahub v0.8.38

[YuriyGavrilov]

also have the same problem with delete

[YuriyGavrilov]

@shirshanka any updates?

[lambertpan]

If I run datahub delete --env PROD --entity_type=dataset --hard, I get the following warning and it is unable to delete the entities. I tried this on latest v.0.10.0.
WARNING {datahub.cli.cli_utils:440} - Discrepancy in entities yielded 0 and num entities 589. This means all entities may not have been deleted.

[hsheth2]

This should be fixed by some previous changes and #8709

[hsheth2]

So #8709 is merged, so I'm gonna call this one done!