hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
Date Wed, 20 Aug 2014 19:14:27 GMT

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

Mime
View raw message