Just so that this helps someone else... I found that the issue is with
metastore running on a MariaDB 10.0 with TokuDB engine 7.1
TokuDB does not support foreign keys, it allows the execution of the ALTER
TABLE statements, rebuilds the table for some reason but the foreign key
constraint is not ap
Some of the commands that are running (I am ignoring the REFERENCES part of
it)
ALTER TABLE `PARTITIONS` ADD CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY
(`SD_ID`)
ALTER TABLE `COLUMNS_V2` ADD CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY
(`CD_ID`)
ALTER TABLE `SDS` ADD CONSTRAINT `SDS_FK1` FOREIGN KEY (`CD_
