Better use HCatalog for this. David Le 5 avr. 2016 10:14, "Mich Talebzadeh" <mich.talebza...@gmail.com> a écrit :
> 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 >> >> >> >
