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/>




Reply via email to