[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14152135#comment-14152135 ] Vikram Dixit K commented on HIVE-7689: -- Hi Damien, Do you think this will be ready for 0.14? If so please mark this jira with a higher priority (Critical/Blocker) and set fix version to 0.14.0. Can you rebase the patch against latest trunk? Thanks Vikram. 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14146027#comment-14146027
]
Lukas Eder commented on HIVE-7689:
--
This is Lukas from Data Geekery (the company behind jOOQ) chiming in.
{quote}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.{quote}
This is correct. We're aware of the challenges our license model induces to
other Open Source projects, specifically those of the ASF. We've been talking
also to other projects about this:
*Apache GORA*:
- https://issues.apache.org/jira/browse/GORA-86
-
https://mail-archives.apache.org/mod_mbox/gora-user/201311.mbox/%3ccalugr6aiac9tteskmjhiylf7htdyeuts_z_j0hse8z0th2f...@mail.gmail.com%3E
*Apache CloudStack*:
- Unfortunately, there hadn't been too many public discussions about this
From the GORA mailing list thread, I suspect that only #2 would apply to Hive:
2. In addition to the above, Data Geekery and Apache Gora could make a
separate agreement, which grants Apache Gora a perpetual license to use the
jOOQ Enterprise Edition for integration testing Apache Gora against SQL
Server and other commercial databases, but not to distribute, sublicense or
make available the jOOQ Enterprise Edition to end users. End users may
again use Apache Gora with the jOOQ Open Source Edition along with Open
Source databases, or they may purchase a commercial license from Data
Geekery. In this case, Data Geekery would require a prominent backlink
indicating that Apache Gora is based on jOOQ. This is how IntelliJ or
YourKit Profiler handle free commercial licenses for non-commercial OSS
projects as well.
This option was well received by the GORA team, although the GORA project
itself isn't advancing very fast, so we have not settled this yet.
If you think that this could be a viable option also for Apache Hive, let me
know (or write to sa...@datageekery.com). We're very open to finding creative
solutions with other OSS vendors.
And obviously - to get back on topic - the free, ASL 2.0-licensed jOOQ support
for PostgreSQL makes PostgreSQL even more awesome! :)
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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14146240#comment-14146240 ] Damien Carol commented on HIVE-7689: [~alangates] I understand more clearly now why you have some concerns regarding that JIRA. bq. 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. First time I launched the script for posgres, I saw the new tables was lower case but all other tables was in upper case. I believed it was a bug. If this not an issue, I think we can close this JIRA. It's just confusing. Every tables in Metastore rely on same upper case policy and naming conventions. The only problem is when we will extend Jdbc stats provider or provide access to this lower cased tables though DataNucleus. Plus if we want to support a new Database for back-end that don't rely on default lower case behavior. 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14144600#comment-14144600
]
Damien Carol commented on HIVE-7689:
{quote}
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.
{quote}
We can't. All tables in current metastore scripts are uppercase in postgres.
Breaking this convention will be painful.
{quote}
All these calls to getEscape make the code hard to read.
{quote}
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
http://www.jooq.org/ 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: 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14144602#comment-14144602 ] Damien Carol commented on HIVE-7689: [~alangates] poke ! 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14140707#comment-14140707 ] Alan Gates commented on HIVE-7689: -- All these calls to getEscape make the code hard to read. 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. Wouldn't that be easier? 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14130182#comment-14130182 ] Damien Carol commented on HIVE-7689: [~alangates] It's ok now. I verified failed tests and there are not related. I also updated review board. 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14128192#comment-14128192 ] Damien Carol commented on HIVE-7689: Tests errors are not related to this patch. 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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14128404#comment-14128404 ] Alan Gates commented on HIVE-7689: -- Are you 100% certain? The TestCompactor uses the transaction tables in the metastore. 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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14128427#comment-14128427
]
Damien Carol commented on HIVE-7689:
Using this command with last trunk and this patch applied :
{code}
mvn -B -o test -Phadoop-2 -Dtest=TestCompactor
{code}
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14128565#comment-14128565
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667660/HIVE-7689.8.patch
{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 6193 tests executed
*Failed tests:*
{noformat}
org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/725/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/725/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-725/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 1 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12667660
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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14126766#comment-14126766
]
Damien Carol commented on HIVE-7689:
My bad.
It's a new method {{findColumnsWithStats}} added in {{CompactionTxnHandler}}.
I written :
{code:java}
if (ci.partName == null)
s += AND + TxnDbUtil.getEscape(PARTITION_NAME,
identifierQuoteString) + =' + ci.partName + ';
{code}
Instead of
{code:java}
if (ci.partName != null)
s += AND + TxnDbUtil.getEscape(PARTITION_NAME,
identifierQuoteString) + =' + ci.partName + ';
{code}
These produce :
{noformat}
2014-09-09 10:34:12,818 ERROR [nc-h04-22]: compactor.Worker
(Worker.java:run(165)) - Caught an exception in the main loop of compactor
worker nc-h04-22, exiting MetaException(message:Unable to connect to
transaction database org.postgresql.util.PSQLException: ERROR: column
PARTITION_NAME does not exist
Position: 104
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464)
at
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findColumnsWithStats(CompactionTxnHandler.java:628)
at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:140)
)
at
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findColumnsWithStats(CompactionTxnHandler.java:645)
at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:140)
{noformat}
This error breack all compactions. Version 4 of the patch was ok but version 5
introduce a new bug.
Fixed with new patch now.
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14126772#comment-14126772
]
Damien Carol commented on HIVE-7689:
Verified with our streaming benchmark on real hardware and with :
{noformat}
mvn -B -o test -Phadoop-2 -Dtest=TestWorker
{noformat}
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14127079#comment-14127079
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667375/HIVE-7689.6.patch
{color:red}ERROR:{color} -1 due to 13 failed/errored test(s), 6185 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testDDLExclusive
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testDDLShared
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testDelete
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testJoin
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testReadWrite
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testRollback
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testSingleReadMultiPartition
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testSingleReadPartition
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testSingleReadTable
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testSingleWritePartition
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testSingleWriteTable
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.testUpdate
org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/708/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/708/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-708/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 13 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12667375
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14127442#comment-14127442
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667443/HIVE-7689.7.patch
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6192 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_schemeAuthority
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.testStatsAfterCompactionPartTbl
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/711/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/711/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-711/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12667443
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14125829#comment-14125829
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667153/HIVE-7689.5.patch
{color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 6185 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.majorTableLegacy
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.majorTableNoBase
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.majorTableWithBase
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.minorTableLegacy
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.minorTableNoBase
org.apache.hadoop.hive.ql.txn.compactor.TestWorker.minorTableWithBase
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/694/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/694/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-694/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 6 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12667153
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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14126182#comment-14126182 ] Alan Gates commented on HIVE-7689: -- I haven't looked into it, but I'm guessing the failed TestWorker tests are real failures, as the compactor uses the transaction tables. 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-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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14120012#comment-14120012
]
Hive QA commented on HIVE-7689:
---
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12666180/HIVE-7889.4.patch
{color:green}SUCCESS:{color} +1 6142 tests passed
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/620/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/620/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-620/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12666180
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, 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 metastore.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14107527#comment-14107527
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12663675/HIVE-7889.3.patch
{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 6116 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_opt_vectorization
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/466/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/466/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-466/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 1 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12663675
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, HIVE-7889.3.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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14105511#comment-14105511 ] Alan Gates commented on HIVE-7689: -- I will review this but I'll need to test it against other backends (MySQL, Oracle). It will be a week or so until I get to it. 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14103688#comment-14103688
]
Hive QA commented on HIVE-7689:
---
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12663067/HIVE-7889.2.patch
{color:green}SUCCESS:{color} +1 6008 tests passed
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/418/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/418/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-418/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12663067
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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14104338#comment-14104338 ] Alan Gates commented on HIVE-7689: -- 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? Have you tested it against any other RDBMSs? 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14104375#comment-14104375 ] Sergey Shelukhin commented on HIVE-7689: -quoted identifiers should be ansi standard... MySQL would require a flag (see MetaStoreDirectSql.java) 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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (HIVE-7689) Enable Postgres as METASTORE back-end
[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14094421#comment-14094421
]
Hive QA commented on HIVE-7689:
---
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12661211/HIVE-7889.1.patch
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 5889 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_opt_vectorization
org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/276/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/276/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-276/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12661211
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
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 first patch enable LOCKS on metastore.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
