hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markovitz, Dudu" <>
Subject RE: Hive 2 database Entity-Relationship Diagram
Date Thu, 19 May 2016 17:44:37 GMT
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


From: Mich Talebzadeh []
Sent: Thursday, May 19, 2016 8:04 PM
To: user <>; user @spark <>
Subject: Re: Hive 2 database Entity-Relationship Diagram


Dr Mich Talebzadeh


On 19 May 2016 at 18:02, Mich Talebzadeh <<>>
Hi All,

I use Hive 2 with metastore created for Oracle Database with

It already includes concurrency stuff added into metastore

The RDBMS is Oracle Database 12c Enterprise Edition Release

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

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.


Dr Mich Talebzadeh


View raw message