CODEWITHSUNDEEP
hadoophivehcatalogmetastore
prasad
prasad

Reputation: 237

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.

Upvotes: 0

Views: 5928

Answers (2)

Mike Park
Mike Park

Reputation: 10941

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);

Upvotes: 1

Remus Rusanu
Remus Rusanu

Reputation: 294307

Yes, that's what HCatalog is all about: access and manipulate the metastore. See SHOW TABLES.

Upvotes: 0

Related Questions