hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejoy...@yahoo.com
Subject Re: Schemas/Databases in Hive
Date Thu, 22 Dec 2011 17:23:58 GMT
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_ks@yahoo.com
Date: Thu, 22 Dec 2011 17:19:16 
To: <user@hive.apache.org>
Reply-To: bejoy_ks@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.Raghunath1@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


Mime
View raw message