Reply
Explorer
Posts: 8
Registered: ‎02-27-2014
Accepted Solution

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

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?

Cloudera Employee
Posts: 721
Registered: ‎07-30-2013

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

Highlighted
Explorer
Posts: 8
Registered: ‎02-27-2014

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

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