[ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)