Hi, Where can I find the hive metastore database? Originally I had it setup as a postgresql but when I log into psql and run \L I am unable to find the hive metastore.
I am currently having issues with upgrading the metastore schema. Looking online I saw some posts about manually running the upgrade scripts in /hive/scripts/metastore/upgrade/postgres but these are of no use to me if I am unable to find the actual metastore database within postgres. I'm starting to wonder if the metastore had become corrupt after upgrading from CDH 5.1 to CDH 5.2. If so what steps would I need to do in order to rebuild the metastore as a last resort?