Database not showing up in hive

Lab Support
#1

Hi ,

i created my own database on metastore but it is not showing up in hive databases list to proceed on practice. Can you please suggest on this.

Thank you very much.

#2

Hi @rn06031982,

Can you please tell me your database name? Also are you checking it using command line or Hue?

#3

I also have the same issue. The database is not visible in Hue but through Hive command line I am able to see it and access it.
Thank you for the help in advance!!

#4

database name : vthota2

#5

Using Hue i created a database ravikumarnagalla3461 in metastore under default location, after creating when did a search on database its not showing up.

again, today i created another with name a_testdb1982 in metastore manager in hdfs under a directory i created and yes it visible.

why it is not showing up when selecting default location in hdfs.(user/hive/warehouse).

Thank you very much.

#6

Hi @chaitya412 @rn06031982,

Its a bug in Hue that they do not show all the databases. The ajax call which is being made when we search for the database in the Hue does not return all the databases.

For now, instead of selecting your database from left-hand side pane, please use below command in Hive query editor to work on your database.

USE your_database_name;

Hope this helps.

Thanks