I did a sqoop import all tables to a db called pig_demo.db in the warehouse directory
And it got completed successfully.
When I give:
hadoop fs -ls /user/hive/warehouse
I’m able to see the db created.
But when I go in the hive prompt and give show databases, the imported db in the warehouse directory is not showing.
show databases is not show pig_demo.db
What should I do to show in the hive, which is there in the warehouse directory ? !! Thanks!
Practice hive on state of the art Big Data cluster - https://labs.itversity.com