What is the intent of having tables in different databases or schemas in Hive? Thanks

Thank you,
Ranjith

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

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

Thanks Bejoy. This was helpful.

Thanks,
Ranjith

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 22, 2011 11:23 AM
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
Date: Thu, 22 Dec 2011 17:19:16 +0000
To: <[EMAIL PROTECTED]>
ReplyTo: [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
________________________________
From: "Raghunath, Ranjith" <[EMAIL PROTECTED]>
Date: Thu, 22 Dec 2011 17:02:09 +0000
To: [EMAIL PROTECTED]<[EMAIL PROTECTED]>
ReplyTo: [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