Support Questions

Find answers, ask questions, and share your expertise

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

avatar
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

avatar
Explorer

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

View solution in original post

2 REPLIES 2

avatar
Super Guru
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

avatar
Explorer

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