Ranjith Hive do support multiple data bases if you are on some of the latest versions of hive try Create database testdb; Use testdb;
It should give you what you are looking for. Regards Bejoy K S -----Original Message----- From: "Raghunath, Ranjith" <ranjith.raghuna...@usaa.com> Date: Thu, 22 Dec 2011 17:02:09 To: user@hive.apache.org<user@hive.apache.org> Reply-To: user@hive.apache.org Subject: Schemas/Databases in Hive What is the intent of having tables in different databases or schemas in Hive? Thanks Thank you, Ranjith