Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

How can I access hive metastore tables

avatar

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

avatar
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.

avatar
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

Labels