The pdf is not upside for me, in chrome browser.
However, there seems to be many tables that are not related to (or rather used by) hive, specifically DMRV_* and DMRS_* ones. Thanks, Thejas ________________________________ From: Mich Talebzadeh <mich.talebza...@gmail.com> Sent: Thursday, May 19, 2016 10:53 AM To: user Cc: user @spark Subject: Re: Hive 2 database Entity-Relationship Diagram 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[Inline images 1] Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/> On 19 May 2016 at 18:44, Markovitz, Dudu <dmarkov...@paypal.com<mailto: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<mailto:mich.talebza...@gmail.com>] Sent: Thursday, May 19, 2016 8:04 PM To: user <user@hive.apache.org<mailto:user@hive.apache.org>>; user @spark <u...@spark.apache.org<mailto: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 http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/> On 19 May 2016 at 18:02, Mich Talebzadeh <mich.talebza...@gmail.com<mailto: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 http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
