hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Drome (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14870) OracleStore: RawStore implementation optimized for Oracle
Date Thu, 29 Dec 2016 19:29:58 GMT

    [ 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)

Mime
View raw message