[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14104879#comment-14104879
]
Damien Carol commented on HIVE-7689:
------------------------------------
[~alangates]
{quote}
It looks like these changes are all to change the SQL to be uppercase and quote
all identifiers. What issues are you seeing to drives the need for this?
{quote}
Yes, these changes are all to change the identifiers (tables names and columns
names) to be uppercase and quote all identifiers using
{{getIdentifierQuoteString()}} from JDBC API.
These modifications are needed to make it works with Postgres 8.4 as [~sershe]
has explained very well. (See also the comment in code in file
[MetaStoreDirectSql.java#L88|https://github.com/apache/hive/blob/e91227e9f454462dad4343dec5f0724553dcdf04/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java#L88]
that describes the problem)
{quote}
Have you tested it against any other RDBMSs?
{quote}
Only with Derby and Postgres 8.4
> 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)
