hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-14870) OracleStore: RawStore implementation optimized for Oracle
Date Fri, 30 Sep 2016 21:41:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15537157#comment-15537157
] 

Sergey Shelukhin edited comment on HIVE-14870 at 9/30/16 9:40 PM:
------------------------------------------------------------------

Hmm.. is there significant obstacle to making it work on other RDBMS-es, or if Oracle-specific
things are critical to perf, at least isolating them into a plugin of some sort? ACID implementation
already uses DN-less SQL for all operations and works on all RDBMS-es.
I am afraid having a separate store potentially for each database, and another arbitration
layer in RawStore, will make it even more unmanageable than it already is.
If it's not DB specific, we can ditch ORM altogether.
cc [~sushanth] [~alangates]


was (Author: sershe):
Hmm.. is there significant obstacle to making it work on other RDBMS-es, or if Oracle-specific
things are critical to perf, at least isolating them into a plugin of some sort? ACID implementation
already uses DN-less SQL for all operations and works on all RDBMS-es.
I am afraid having a separate store potentially for each database, and another arbitration
layer in RawStore, will make it even more unmanageable than it already is.
If it's not DB specific, we can ditch ORM altogether.

> OracleStore: RawStore implementation optimized for Oracle
> ---------------------------------------------------------
>
>                 Key: HIVE-14870
>                 URL: https://issues.apache.org/jira/browse/HIVE-14870
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore
>            Reporter: Chris Drome
>            Assignee: Chris Drome
>         Attachments: OracleStoreDesignProposal.pdf
>
>
> The attached document is a proposal for a RawStore implementation which is optimized
for Oracle and replaces DataNucleus. The document outlines schema changes, OracleStore implementation
details, and performance tests against ObjectStore, ObjectStore+DirectSQL, and OracleStore.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message