Hive DDL Vocabulary Primary Key Constraint fails

[don-torok]

ALTER TABLE dev_omop.omop_custom_concepts.vocabulary ADD CONSTRAINT xpk_vocabulary PRIMARY KEY (vocabulary_id); fails because the ddl vocabulary_id not declared NOT NULL in DDL.

[HBD007]

In All DB, DDL Vocabulary below Foreign Key Constraint fails.
Cohort table doesn't have cohort_definition_id

ALTER TABLE @cdmDatabaseSchema.COHORT_DEFINITION ADD CONSTRAINT fpk_COHORT_DEFINITION_cohort_definition_id FOREIGN KEY (cohort_definition_id) REFERENCES @cdmDatabaseSchema.COHORT (COHORT_DEFINITION_ID);