Question: In my application, I am using hive metastore(mysql) from JDBC. Now the requirement got changed and I won't be able to get metastore credentials. Hence I can't use JDBC to access metastore.

I wanted to know, Is there a way to access hivemetastore tables like TBLS and INDXS from HCATALOG? Thanks in advance.

Answer: 
You can probably get most of the information you need through HCatalog, without direct access to the metastore tables. 

```
HiveConf conf = new HiveConf(); // should pull hive-site.xml automatically
HiveMetaStoreClient hiveClient = new HiveMetaStoreClient(conf);
Table hiveTable = HCatUtil.getTable(hiveClient, "default", "sometable");

... = hiveTable.getAllIndexes(max);

```
Yes, that's what HCatalog is all about: access and manipulate the metastore. See [SHOW TABLES](https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI#HCatalogCLI-SHOWTABLES).