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.