You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2017/03/29 17:40:41 UTC
[jira] [Commented] (HIVE-15724) getPrimaryKeys and getForeignKeys
in metastore does not normalize db and table name
[ https://issues.apache.org/jira/browse/HIVE-15724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15947576#comment-15947576 ]
Pengcheng Xiong commented on HIVE-15724:
----------------------------------------
LGTM +1, could u rerun the ptest? Thanks!
> 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
> Attachments: HIVE-15724.1.patch, HIVE-15724.2.patch
>
>
> 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.15#6346)