hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damien Carol (JIRA)" <>
Subject [jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
Date Tue, 23 Sep 2014 09:28:42 GMT


Damien Carol commented on HIVE-7689:

If postgres requires lower case table and column names I'd prefer to change the postgres version
of hive-txn-schema.sql to create the tables and columns with lower case names.
We can't. All tables in current metastore scripts are uppercase in postgres. Breaking this
convention will be painful.
All these calls to getEscape make the code hard to read.
There are 3 solutions to this pb.
1. Rewrite this patch to use Datanucleus where it's possible (not in stats part). => HARD
and very intrusive
2. Use thrid party library to generate SQL (think about JOOQ ASF license)
=> easy and well designed BUT add another lib dependency
3. Keep minimum modifications, use a simple solution to add Identifier Escape => it's the
way the patch follows, adding a function to get Identifier Escape char from connector

Tell me: if you want, I rewrite the patch but, as is, postgres cannot be used.

> Enable Postgres as METASTORE back-end
> -------------------------------------
>                 Key: HIVE-7689
>                 URL:
>             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
> 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

View raw message