Alan Gates created HIVE-15413: --------------------------------- Summary: Primary key constraints forced to be unique across database and table names Key: HIVE-15413 URL: https://issues.apache.org/jira/browse/HIVE-15413 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 2.2.0 Reporter: Alan Gates Priority: Critical
In the RDBMS underlying the metastore the table that stores primary and foreign keys has it's own primary key (at the RDBMS level) of (constraint_name, position). This means that a constraint name must be unique across all tables and databases in a system. This is not reasonable. Database and table name should be included in the RDBMS primary key. -- This message was sent by Atlassian JIRA (v6.3.4#6332)