When you start the CLI you are in the default database. This is rooted at hive.warehouse.dir which is typically rooted at /user/hive/warehouse
If you create a database the default location is /user/hive/warehouse/ + databasename +".db" Although when you create the database you can set the location. The 'describe database' command is used to interrogate this information hive> describe database default; OK default hdfs://hdfs.hadoop.pvt:54310/user/hive/warehouse Time taken: 2.373 seconds hive> hive> describe database edward; OK edward hdfs://hdfs.hadoop.pvt:54310/user/hive/warehouse/edward.db Time taken: 0.08 seconds On Tue, Mar 6, 2012 at 1:28 PM, mahsa mofidpoor <mofidp...@gmail.com> wrote: > Hello, > > How different databases are distinguished within Hive? Do they correspond to > different HDFS directories? > > Thank you inn advance for your reply, > Mahsa
