Thanks Bejoy. This was helpful. Thanks, Ranjith
From: bejoy...@yahoo.com [mailto:bejoy...@yahoo.com] Sent: Thursday, December 22, 2011 11:23 AM To: user@hive.apache.org <user@hive.apache.org> Subject: Re: Schemas/Databases in Hive 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 ________________________________ From: bejoy...@yahoo.com Date: Thu, 22 Dec 2011 17:19:16 +0000 To: <user@hive.apache.org> ReplyTo: bejoy...@yahoo.com 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 ________________________________ From: "Raghunath, Ranjith" <ranjith.raghuna...@usaa.com> Date: Thu, 22 Dec 2011 17:02:09 +0000 To: user@hive.apache.org<user@hive.apache.org> ReplyTo: 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
