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 DF3AD200AC9 for ; Sun, 22 May 2016 16:59:14 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id DDCBF160A06; Sun, 22 May 2016 14:59:14 +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 09A851609AF for ; Sun, 22 May 2016 16:59:13 +0200 (CEST) Received: (qmail 37927 invoked by uid 500); 22 May 2016 14:59:12 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 37911 invoked by uid 99); 22 May 2016 14:59:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 May 2016 14:59:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 4BEB21A03A6 for ; Sun, 22 May 2016 14:59:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id pmqqCSmQzbPz for ; Sun, 22 May 2016 14:59:10 +0000 (UTC) Received: from mail-qg0-f54.google.com (mail-qg0-f54.google.com [209.85.192.54]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 1C1435FAC8 for ; Sun, 22 May 2016 14:59:10 +0000 (UTC) Received: by mail-qg0-f54.google.com with SMTP id e93so2654444qgf.2 for ; Sun, 22 May 2016 07:59:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=nDQ2v2AYLiojoAiUgM7HxNmC4/NNTuK2ePkVixiTo00=; b=bTclu1Dzt56UEKyDWgFpi/ywNYYRH8NDd93tlvvv1+iBk30u7WJzEKaRUYAtHRPgNi sDsqlxbWDb2iW7f7xu/Zlw73Os6g+9OaFhx9+BdXPjr5ni5p1eboB6zyhC6A78I8jRhW aLGFTqKGQig1FSyKBo2HIw8p1UdT82bFpGllJTTFSNcxtHLWZH+FAUg2rJSqeRvV5eHp AlBMWYnIQrJOIl3frB1dBi73vuOThDNUS2h772LfcxU1tLe5GUS4jaKwNdAKquzDhaLI iAaiH+G+X34v900Uro3J3V+di28BSfVG9bZJFLj0WgXLjtVHySQYp6p8gpbesVpQ2Hdw cjwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=nDQ2v2AYLiojoAiUgM7HxNmC4/NNTuK2ePkVixiTo00=; b=M+O7r1LdHtb3BfU0fFavx99yu2Ao+4N2+zG5P1CIFCkNPbg+jUrQUtfbbnTkKfaVj9 Fcxfk/h0pysZDq1ym+wk+0w/Hq5dqjkOUTs8Gc8ks1fFjnmPzyFWVBFIVnouOA7Nabiw kkKEUHsw5UJqYmcpxHsra1gDOH6fO0rbPry/zCxajcY5EKMpp/fEzOjB7iCUwhOIrnOZ 1/eyT7EjbUUrtRi7o/EKqYupQyVB4SzX85QAsninVwq0B+TcZ7p5i/3581h1w4qphj7Q a4zJOYlOG/Gq6d6CHomdtcsQEg9Z1FQPg0+QRf37gRxndsQ4Gks/rMNikNzVXROqShHQ PSdA== X-Gm-Message-State: AOPr4FXt8YTeNCL3SQAB9XuQCqvU2xbRsDFiQoDK0PkbfAwAqrtUIQf92n9xaaEMicYBZXUbHvvcnRYe0bZSDg== MIME-Version: 1.0 X-Received: by 10.140.215.76 with SMTP id l73mr12213016qhb.1.1463929143033; Sun, 22 May 2016 07:59:03 -0700 (PDT) Received: by 10.55.126.131 with HTTP; Sun, 22 May 2016 07:59:02 -0700 (PDT) In-Reply-To: <8F49EC7B-E952-4B60-99FC-4310E5F72C9D@aol.com> References: <8F49EC7B-E952-4B60-99FC-4310E5F72C9D@aol.com> Date: Sun, 22 May 2016 15:59:02 +0100 Message-ID: Subject: Re: Hive 2 Metastore Entity-Relationship Diagram, Base tables From: Mich Talebzadeh To: user Cc: "user @spark" , Lefty Leverenz Content-Type: multipart/alternative; boundary=001a114f4da88c09eb05336f903c archived-at: Sun, 22 May 2016 14:59:15 -0000 --001a114f4da88c09eb05336f903c Content-Type: text/plain; charset=UTF-8 for now to be used as a quick reference for hive metadata tables, columns, pk and constraint. It only covers the base tables excluding transactional add ons in hive-txn-schema-2.0.0.oracle.sql HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 22 May 2016 at 15:55, Denise Rogers wrote: > What capability is this construct designed to support? Reporting, ad hoc > query? I need a context. > > Regards, > Denise > Cell - (860)989-3431 > > Sent from mi iPhone > > On May 22, 2016, at 3:36 AM, Mich Talebzadeh > wrote: > > > Hi, > > This is Hive 2 Entity-Relationship Diagrams created by running the > following script against Oracle Hive schema > > ${HIVE_HOME}/scripts/metastore/upgrade/oracle/hive-schema-2.0.0.oracle.sql > > It creates 55 tables, primary key, foreign key and other constraints. > > It does not have any views. > > I trust that the diagram in PDF format can be useful. > > Any overlapping entities etc please comment and I will try to sort it out > in the next draft. > > HTH > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > * > > > > http://talebzadehmich.wordpress.com > > > > > > --001a114f4da88c09eb05336f903c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
for now to be used as a quick reference for hive meta= data tables, columns, pk and constraint. It only covers the base tables exc= luding transactional=C2=A0 add ons in

hive-txn-sch= ema-2.0.0.oracle.sql

HTH


On 22 May 2016 at 15:55, Denise Rogers <data= gwal@aol.com> wrote:
What capability is this construct designed to support? Rep= orting, ad hoc query? I need a context.=C2=A0

Regards,
Denise

Sent from m= i iPhone

On May 22, 2016, at 3:36 AM, = Mich Talebzadeh <mich.talebzadeh@gmail.com> wrote:


Hi,

This is Hive 2 Entity-Relationship Diagrams created by running the= following script against Oracle Hive schema

${HIVE_HOME}/scripts/metast= ore/upgrade/oracle/hive-schema-2.0.0.oracle.sql

=
It creates 55 tables, primary key, foreign key and other constraints.<= /div>

It does not have any views.

I trust that the diagram in PDF format can be useful.

Any overlapping entities etc please comment and I will try to sort i= t out in the next draft.

HTH

<Hive2_bas= e_tables.pdf>

--001a114f4da88c09eb05336f903c--