thanks Dudu for your comments I will check.
I will realign the overlapping tables Only partial tables have relationship not all I am afraid. Most DMRS_% tables are standalone. I can see the PDF as it is can you kindly check the top left hand corner. The one below Do you see this upside down Thanks[image: Inline images 1] 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 19 May 2016 at 18:44, Markovitz, Dudu <dmarkov...@paypal.com> wrote: > Thanks Mich > > > > I’m afraid the current format is not completely user friendly. > > I would suggest to divide the tables to multiple sets by subjects / graph > connectivity (BTW, it seems odd that most of the tables are disconnected) > > > > Also – > > · HIVEUSER.PARTITION_KEY_VALS is partially covering another table > > · The PDF is upside-down > > > > Dudu > > > > *From:* Mich Talebzadeh [mailto:mich.talebza...@gmail.com] > *Sent:* Thursday, May 19, 2016 8:04 PM > *To:* user <user@hive.apache.org>; user @spark <u...@spark.apache.org> > *Subject:* Re: Hive 2 database Entity-Relationship Diagram > > > > Attachement > > > 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 19 May 2016 at 18:02, Mich Talebzadeh <mich.talebza...@gmail.com> > wrote: > > Hi All, > > > > I use Hive 2 with metastore created for Oracle Database with > hive-txn-schema-2.0.0.oracle.sql. > > > > It already includes concurrency stuff added into metastore > > > > The RDBMS is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0. > > > > I created an Entity-Relationship (ER) diagram from the physical model. > There are 194 tables, 127 views and 38 relationships. The relationship > notation is Bachman > <https://www.google.co.uk/search?q=bachman+notation&biw=1920&bih=883&tbm=isch&tbo=u&source=univ&sa=X&sqi=2&ved=0ahUKEwjUx4e2zebMAhVMBsAKHTvOAcwQsAQILQ&dpr=1> > > > > Fairly big diagram in PDF format. However, you can zoom into it. > > > > > > Please have a kook and appreciate comments to me and if it is useful we > can load it into wiki. > > > > > > 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 > > > > >