Re: Schemas/Databases in Hive
Thanks Bejoy. This was helpful. Thanks, Ranjith From: bejoy...@yahoo.com [mailto:bejoy...@yahoo.com] Sent: Thursday, December 22, 2011 11:23 AM To: 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...@yahoo.com Date: Thu, 22 Dec 2011 17:19:16 + To: ReplyTo: 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 From: "Raghunath, Ranjith" Date: Thu, 22 Dec 2011 17:02:09 + To: 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
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 -Original Message- From: bejoy...@yahoo.com Date: Thu, 22 Dec 2011 17:19:16 To: 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" Date: Thu, 22 Dec 2011 17:02:09 To: 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
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" Date: Thu, 22 Dec 2011 17:02:09 To: 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