hive-issues mailing list archives

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


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:
>             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

View raw message