You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Mich Talebzadeh <mi...@gmail.com> on 2016/05/19 17:02:07 UTC
Hive 2 database Entity-Relationship Diagram
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
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
Thanks
These are the list of tables and views
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 19:10, Thejas Nair <th...@hortonworks.com> wrote:
> 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 <mi...@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[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 <dm...@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.talebzadeh@gmail.com]
>> *Sent:* Thursday, May 19, 2016 8:04 PM
>> *To:* user <us...@hive.apache.org>; user @spark <us...@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 <mi...@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
>>
>>
>>
>>
>>
>
>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
Thanks
These are the list of tables and views
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 19:10, Thejas Nair <th...@hortonworks.com> wrote:
> 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 <mi...@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[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 <dm...@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.talebzadeh@gmail.com]
>> *Sent:* Thursday, May 19, 2016 8:04 PM
>> *To:* user <us...@hive.apache.org>; user @spark <us...@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 <mi...@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
>>
>>
>>
>>
>>
>
>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Thejas Nair <th...@hortonworks.com>.
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 <mi...@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 <dm...@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.talebzadeh@gmail.com<ma...@gmail.com>]
Sent: Thursday, May 19, 2016 8:04 PM
To: user <us...@hive.apache.org>>; user @spark <us...@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 <mi...@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/>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <dm...@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.talebzadeh@gmail.com]
> *Sent:* Thursday, May 19, 2016 8:04 PM
> *To:* user <us...@hive.apache.org>; user @spark <us...@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 <mi...@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
>
>
>
>
>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <dm...@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.talebzadeh@gmail.com]
> *Sent:* Thursday, May 19, 2016 8:04 PM
> *To:* user <us...@hive.apache.org>; user @spark <us...@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 <mi...@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
>
>
>
>
>
RE: Hive 2 database Entity-Relationship Diagram
Posted by "Markovitz, Dudu" <dm...@paypal.com>.
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.talebzadeh@gmail.com]
Sent: Thursday, May 19, 2016 8:04 PM
To: user <us...@hive.apache.org>; user @spark <us...@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 <mi...@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/>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <mi...@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
>
>
>
Re: Hive 2 database Entity-Relationship Diagram
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <mi...@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
>
>
>