You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2016/09/30 21:41:20 UTC
[jira] [Comment Edited] (HIVE-14870) OracleStore: RawStore
implementation optimized for Oracle
[ 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)