[ 
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)

Reply via email to