Hi I understand that when we start the CLI we are in the default database. This is rooted at
hive.warehouse.dir which is typically rooted at /user/hive/warehouse we create a database in the default location is /user/hive/warehouse/ + databasename +".db" Cant we have two databases in the same location. If I yes, how does Hive differentiate between the databases and how is the appropriate mapping done to tables. Thanks in advance. Indrani