You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Daniel Dai (JIRA)" <ji...@apache.org> on 2017/01/25 08:22:26 UTC

[jira] [Created] (HIVE-15724) getPrimaryKeys and getForeignKeys in metastore does not normalize db and table name

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)