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.
Hive version- Hive 126.96.36.199.3.2.0-2950
Postgres version 9.1.9
@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.
@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";