[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14144812#comment-14144812
]
Alan Gates commented on HIVE-7689:
----------------------------------
bq. We can't. All tables in current metastore scripts are uppercase in
postgres. Breaking this convention will be painful.
I'm not proposing that we change the case in DataNucleus generated scripts.
That would be painful. But I don't see any need to do that to resolve this
issue. Are you concerned that having upper case names for DataNucleus
generated tables but lower case names for transaction tables is confusing? I
don't see that as an issue since these tables are not a public interface. Is
there something else painful I'm missing here?
bq. Use thrid party library to generate SQL (think about JOOQ
http://www.jooq.org/ ASF license) => easy and well designed BUT add another lib
dependency
Long term this may be the right answer. I have not looked into the options.
JOOQ looks like the open source edition only supports open source databases,
and since Hive already supports Oracle and MSSQL Server this would not be an
option.
> Enable Postgres as 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: Minor
> 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-7889.1.patch, HIVE-7889.2.patch, HIVE-7889.3.patch,
> HIVE-7889.4.patch
>
>
> I maintain few patches to make Metastore works with Postgres back end in our
> production environment.
> The main goal of this JIRA is to push upstream these patches.
> This patch enable LOCKS, COMPACTION and fix error in STATS on postgres
> metastore.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
