Is there a way to access hive metastore tables from HCATALOG?
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.
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.