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: bejoy...@yahoo.com
Date: Thu, 22 Dec 2011 17:19:16
To: <user@hive.apache.org>
Reply-To: 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
-----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
