[
https://issues.apache.org/jira/browse/HIVE-14870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15785946#comment-15785946
]
Chris Drome commented on HIVE-14870:
------------------------------------
[~alangates], I have attached a patch and schema for the work that I've
completed to date.
The patch is relative to our internal version of branch-1.2.1. There are a
number of methods that are specific to our implementation of data discovery.
The schema should be self-explanatory and adds tables required by the
OracleStore implementation. I'm currently investigating some random deadlock
exceptions that Oracle throws from time to time when dropping databases/tables
on sparsely populated Oracle tables under high concurrency. I'll likely have to
remove some of the cascaded deletes on foreign keys (or implement a retry on
drop database/table) to address this issue.
> 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: HIVE-14870.patch, OracleStoreDesignProposal.pdf,
> schema-oraclestore.sql
>
>
> 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)
