The Hive 2 metastore with concurrency capability has 194 tables, 127 views and 38 relationships for a metastore created on Oracle 12c
I have created an Entity-Relationship diagram but need to decide in what format to post it 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 04:51, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hi Braj, > > Any tool GUI or OS level can log in and see the schema created for Hive. > > For example my metadata for Hive is on Oracle and I can use SQL Developer > Data Model to create a logical model from the physical model > > 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 > > > > On 19 May 2016 at 03:34, brajmohan saxena <braj.saxena...@gmail.com> > wrote: > >> Hi, >> >> Could any body please help me to know how to get the Hive system catalog >> tables. >> Also I am looking for a catalog table which can show me all the built in >> functions list of Hive. >> >> Thanks in advance. >> >> Regards >> Braj >> > >