1) If your metastore use a RDBMS for the backend, you can query it by
program.
2) If you want a more "command line" approach try the hcatalog cli tool
3) If you want to stay on hive, you could use beeline (HIVE as few meta
data commands like SHOW DATABASES)
Hope it helps,
Damien
2016-05-19 11:01 GMT+02:00 Mich Talebzadeh <mich.talebza...@gmail.com>:
> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> 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
>>>
>>
>>
>
