Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 45B42200BBA for ; Fri, 30 Sep 2016 23:40:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 44691160AEB; Fri, 30 Sep 2016 21:40:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B9F64160AE7 for ; Fri, 30 Sep 2016 23:40:21 +0200 (CEST) Received: (qmail 75903 invoked by uid 500); 30 Sep 2016 21:40:20 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 75720 invoked by uid 99); 30 Sep 2016 21:40:20 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2016 21:40:20 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id AF2C82C2A6D for ; Fri, 30 Sep 2016 21:40:20 +0000 (UTC) Date: Fri, 30 Sep 2016 21:40:20 +0000 (UTC) From: "Sergey Shelukhin (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-14870) OracleStore: RawStore implementation optimized for Oracle MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 30 Sep 2016 21:40:22 -0000 [ https://issues.apache.org/jira/browse/HIVE-14870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15537157#comment-15537157 ] Sergey Shelukhin commented on HIVE-14870: ----------------------------------------- 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)