hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15724) getPrimaryKeys and getForeignKeys in metastore does not normalize db and table name
Date Wed, 29 Mar 2017 17:47:42 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15947595#comment-15947595
] 

Daniel Dai commented on HIVE-15724:
-----------------------------------

will do, 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)

Mime
View raw message