[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14104372#comment-14104372
]
Sergey Shelukhin commented on HIVE-7689:
----------------------------------------
The problem is that Postgres coerces unquoted identifiers everywhere to lower
(iirc) case and has no way to disable this, to put it very mildly, questionable
behavior; afair the request to add a flag similar to mysql one for ANSI was
also not viewed positively when I tried.
So either everything has to be lower case, or everything has to be quoted (and
upper case, for simplicity I guess).
> 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-7889.1.patch, HIVE-7889.2.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 metastore.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
