Created on 05-16-2017 12:27 PM - edited 08-17-2019 05:27 PM
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 1.2.1.2.3.2.0-2950
Postgres version 9.1.9
Created 05-24-2017 09:45 PM
@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.
Created 05-24-2017 10:22 PM
@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