Also multiple databases have proved helpful for me in organizing tables into corresponding databases when you have quite a large number of tables to manage. Also I believe it'd be helpful in providing access restrictions.
Regards Bejoy K S -----Original Message----- From: [email protected] Date: Thu, 22 Dec 2011 17:19:16 To: <[email protected]> Reply-To: [email protected] Subject: Re: Schemas/Databases in Hive 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" <[email protected]> Date: Thu, 22 Dec 2011 17:02:09 To: [email protected]<[email protected]> Reply-To: [email protected] Subject: Schemas/Databases in Hive What is the intent of having tables in different databases or schemas in Hive? Thanks Thank you, Ranjith
