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.

DB/tables in metastore manager, but not in Hive query editor

Solved Go to solution

DB/tables in metastore manager, but not in Hive query editor

Explorer

Upgraded to CDH5.2 yesterday and althought there was a hic-up getting the hive metastore schema upgraded, that was resolved eventually. Now in Hue, I can view/create databases & tables in the Metastore Manager, but in the query editors (Hive and/or Impala) there are no databases listed.

 

Any suggestions on where to start troubleshooting?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: DB/tables in metastore manager, but not in Hive query editor

Explorer

Was a bad metastore server - ended up stopping the metastore server and using a different one.

2 REPLIES 2

Re: DB/tables in metastore manager, but not in Hive query editor

Weird, could you click on the refresh tables or in your browser incognito
mode to see if the empty data was cached? (Metastore and Hive/Impala both
use the same API to poke Hive)

Romain

Re: DB/tables in metastore manager, but not in Hive query editor

Explorer

Was a bad metastore server - ended up stopping the metastore server and using a different one.