Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

How can I access hive metastore tables

I am able to list the tables in hive metastore database. But unable to access it

Please find the relevant screenshots.

Using the same method, I am able to access oozie database tables but not hive metastore tables.

15423-1.jpg

15424-2.jpg

15425-3.jpg

Hive version- Hive 1.2.1.2.3.2.0-2950

Postgres version 9.1.9

2 REPLIES 2

Rising Star

@Vishal Prakash Shah See if this blog post helps - https://sharebigdata.wordpress.com/2016/06/12/hive-metastore-internal-tables/. Keep in mind that these are not HiveQL queries but rather queries to the underlying database.

Explorer

@Vishal Prakash Shah The Hive Metastore database in PgSQL uses upper case object names. In PostgreSQL to access these upper case objects you have to quote those objects.

So in the example you provided you will have to change the query to look something like below:

SELECT * FROM "TBLS";

HTH

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.