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 <datag...@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.talebza...@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> > >