Hey everyone,
Currently, we run an EMR cluster w/ hive 2.3.6 to use as a metastore service.
We’ve recently spun up a hive standalone metastore w/ version 3.1.2 in k8s. The
hive metastore service is being used by trino.
The issue I am running into is, if I CREATE a table w/ data pointing to the EMR
metastore service, and then try to DROP it pointing to the standalone service,
I get this error:
```
Cannot delete or update a parent row: a foreign key constraint fails
("hive"."TAB_COL_STATS", CONSTRAINT "TAB_COL_STATS_FK" FOREIGN KEY ("TBL_ID")
REFERENCES "TBLS" ("TBL_ID"))
```
I’ve tried upgrading the EMR cluster first, to use hive 3.1.2, however, I still
run into the same issue. Any suggestions?
Thanks,
Akram
