hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raghunath, Ranjith" <Ranjith.Raghuna...@usaa.com>
Subject Re: Schemas/Databases in Hive
Date Thu, 22 Dec 2011 18:00:04 GMT
Thanks Bejoy. This was helpful.

Thanks,
Ranjith

From: bejoy_ks@yahoo.com [mailto:bejoy_ks@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_ks@yahoo.com
Date: Thu, 22 Dec 2011 17:19:16 +0000
To: <user@hive.apache.org>
ReplyTo: 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
________________________________
From: "Raghunath, Ranjith" <Ranjith.Raghunath1@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
Mime
View raw message