Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Schemas/Databases in Hive


+
Raghunath, Ranjith 2011-12-22, 17:02
+
bejoy_ks@... 2011-12-22, 17:19
Copy link to this message
-
Re: Schemas/Databases in Hive
bejoy_ks@... 2011-12-22, 17:23
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
+
Raghunath, Ranjith 2011-12-22, 18:00