hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Hive 2 Metastore Entity-Relationship Diagram, Base tables
Date Sun, 22 May 2016 14:59:02 GMT
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
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 22 May 2016 at 15:55, Denise Rogers <datagwal@aol.com> 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 <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/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
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> <Hive2_base_tables.pdf>
>
>

Mime
View raw message