hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <>
Subject Re: Hive Metadata tables of a schema
Date Tue, 05 Apr 2016 08:14:39 GMT
So you want to interrogate Hive metastore and get information about objects
for a given schema/database in Hive.

These info are kept in Hive metastore database running on an RDBVMS say
Oracle. There are dozens of tables in Hive specific schema.

For example table DBS contains Hive databases etc

hiveuser@MYDB.MICH.LOCAL> select name from DBS;
7 rows selected.

However, to get tables etc you need to understand the Hive schema tables
and relationships among the tables. There is no package or proc to provide
the info you need. You need to write your own queries.


Dr Mich Talebzadeh

LinkedIn *

On 5 April 2016 at 04:57, brajmohan saxena <> wrote:

> Hi,
> How can I access Hive metadata tables of a particular Server and Schema in
> a C program or through JDBC client.
> I have one application running on Client and my Hiveserver2 running on
> Remote machine.
> So if i provide Server name and Schema name in my client C program ,I
> should be able to get all the tables belongs that Schema.
> So Is there any Hive API where i can provide the Server and Schema name
> and get the tables of that schema.
> Thanks in advance,
> Regards
> Braj

View raw message