When I create a database without specifying location:
e.g. create database test;
it will get created in /apps/hive/warehouse/ as /apps/hive/warehouse/test.db
But when I create database by specifying location:
e.g. create database test_loc location '/addh0010/hive/addh0011/warehouse';
Database will be created but /addh0010/hive/addh0011/warehouse/test_loc.db does not get created.
So if user tries to create 2 tables with same name in two different databases at same location. We are not sure if table is created.
So when database is created with location, .db directory should be created with that database name at that location.