Hive database not showing in Hue

Lab Support
#1

Hello,

I logged into Hive from command line using putty. Then I created a database in hive from there. Now, when I open Hue and go to Query Editors -> Hive, in the DATABASE dropdown, I expect to see the database that I have created, but it is not available there.

I have waited for one day, with the expectation that maybe my database will show up in Hue in sometime. But 2 days have passed, I still can not see my database in Hue.

Any suggestion regarding this ?

Thanks!

#2

Hi Subhasis,

The Hue’s dropdown doesn’t show all databases. As of now, there are too many databases in that list.

So, I would suggest that you use the following before your query: use mydatabase;