hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damien Carol (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7689) Fix wrong lower case table names in Postgres Metastore back end
Date Wed, 01 Oct 2014 09:21:34 GMT

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

Damien Carol commented on HIVE-7689:
------------------------------------

[~brocknoland] I don't know if the trunk can work with lowercase table name without this patch.
The fact is that, the current code create tables in lower case but every table in Metastore
rely on same uppercase policy and naming conventions. (on postgres).
When we started to work with transactions/compactions on our production cluster, we thought
it was a bug and we created few patches to use uppercase names tables. Now this patch work
well in our cluster and we want to push it upstream.

I'm well aware that it's a pis-aller because the implementation in the patch is a "simple"
patch that adds quotes identifiers. A more well designed patch could be to re-factor it to
use DataNucleus/ObjectStore or third party library.
We just made the patch this way to be less intrusive.

Anyway this JIRA need feedback from [~alangates]

> Fix wrong lower case table names in Postgres Metastore back end
> ---------------------------------------------------------------
>
>                 Key: HIVE-7689
>                 URL: https://issues.apache.org/jira/browse/HIVE-7689
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore
>    Affects Versions: 0.14.0
>            Reporter: Damien Carol
>            Assignee: Damien Carol
>            Priority: Blocker
>              Labels: metastore, postgres
>             Fix For: 0.14.0
>
>         Attachments: HIVE-7689.5.patch, HIVE-7689.6.patch, HIVE-7689.7.patch, HIVE-7689.8.patch,
HIVE-7689.9.patch, HIVE-7889.1.patch, HIVE-7889.2.patch, HIVE-7889.3.patch, HIVE-7889.4.patch
>
>
> Current 0.14 patch create table with lower case names.
> This patch fix wrong lower case tables names in Postgres Metastore back end.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message