Daniel Dai created HIVE-15724: --------------------------------- Summary: getPrimaryKeys and getForeignKeys in metastore does not normalize db and table name Key: HIVE-15724 URL: https://issues.apache.org/jira/browse/HIVE-15724 Project: Hive Issue Type: Bug Components: Metastore Reporter: Daniel Dai Assignee: Daniel Dai
In db, everything is lower case. When we retrieve constraints back, we need to normalize dbname/tablename. Otherwise, the following sample script fail: alter table Table9 add constraint pk1 primary key (a) disable novalidate; ALTER TABLE Table9 drop constraint pk1; Error message: InvalidObjectException(message:The constraint: pk1 does not exist for the associated table: default.Table9 -- This message was sent by Atlassian JIRA (v6.3.4#6332)