Support Questions
Find answers, ask questions, and share your expertise

pull metadata from Hive metastore

Solved Go to solution

pull metadata from Hive metastore

New Contributor

I would like to pull metadata from Hive metastore without wrong about what database metastore uses. It seems like I have following APIs to use:

1. Hive Server2 JDBC

2. WebHCatalog

3. Hive Metastore Client

(Or there are more options)

I'm building a tool to pull metadata and maybe want to keep my pulled metadata up to date. Which API would work best for me?

Any related information will be highly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: pull metadata from Hive metastore

@Yan Chen\

For example, I would use the API corresponding for the Hive version. Here is an example for 0.13, which I heavily relied on the following to do something somehow similar with what you are trying to do:

https://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMetaStor...

https://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/MetaStoreUti...

I used some resources from here: http://www.javased.com/index.php?api=org.apache.hadoop.hive.metastore.api.MetaException

Let me know if this helps or you need more help.

View solution in original post

2 REPLIES 2

Re: pull metadata from Hive metastore

@Yan Chen\

For example, I would use the API corresponding for the Hive version. Here is an example for 0.13, which I heavily relied on the following to do something somehow similar with what you are trying to do:

https://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMetaStor...

https://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/MetaStoreUti...

I used some resources from here: http://www.javased.com/index.php?api=org.apache.hadoop.hive.metastore.api.MetaException

Let me know if this helps or you need more help.

View solution in original post

Re: pull metadata from Hive metastore

New Contributor

thanks a lot