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.

hive metastore location

Highlighted

hive metastore location

Explorer

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?

 

Thanks

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