hadoop - Hive is not showing tables

Question

I am new to Hadoop and Hive world.

I have a strange problem. When I was working on hive prompt. I have created few tables and hive was showing those tables.

After exiting Hive session when I am again starting Hive terminal "show tables;" is not showing any table!. I can see tables in '/user/hive/warehouse' in HDFS.

What is wrong am I doing. Can you please help me on this?

Answer 1

BalduZ is right . set this in $HIVE_HOME/conf/hive-site.xml

property name = javax.jdo.option.ConnectionURL

property value = jdbc:derby:;databaseName=/home/youruser/hive_metadata/metastore_db;create=true

Next time onwards you can run hive from any dir location. This will solve your problem.