Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB