Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How can I access hive metastore tables

How can I access hive metastore tables

New Contributor

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

Re: How can I access hive metastore tables

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.

Highlighted

Re: How can I access hive metastore tables

New Contributor

@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

Don't have an account?
Coming from Hortonworks? Activate your account here