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 hiveu...@mydb.mich.LOCAL> select name from DBS; NAME -------------------------------------------------------------------------------------------------------------------------------- oraclehadoop test mytable_db accounts asehadoop default iqhadoop 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. 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 5 April 2016 at 04:57, brajmohan saxena <braj.saxena...@gmail.com> 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 > > >
