You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by nagarjuna kanamarlapudi <na...@gmail.com> on 2013/05/08 11:26:58 UTC

warehouse directory of HIVE

Just wondering what information does Hive  store in metastore and warehouse
directory .

I configured my metastore to mysql. I also in the warehouse directory of
hive (on HDFS) directories with names <database_name>.db

What informations are stored in metastore and what informations are stored
in Warehouse directory of hive.



Regards,
Nagarjuna K

Re: warehouse directory of HIVE

Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
https://issues.apache.org/jira/secure/attachment/12471108/HiveMetaStore.pdf

From: Stephen Sprague <sp...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Wednesday, May 8, 2013 12:51 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Subject: Re: warehouse directory of HIVE

@nagarjuna - also, there's nothing preventing you from logging into your mysql server and poking around in there yourself. That trumps all comments and documentation. :)


On Wed, May 8, 2013 at 2:28 AM, Nitin Pawar <ni...@gmail.com>> wrote:
meta store contains all the information related to your table definitions, partitions, serdes etc

warehouse directory is just a location where the raw data from your table is stored


On Wed, May 8, 2013 at 2:56 PM, nagarjuna kanamarlapudi <na...@gmail.com>> wrote:
Just wondering what information does Hive  store in metastore and warehouse directory .

I configured my metastore to mysql. I also in the warehouse directory of hive (on HDFS) directories with names <database_name>.db

What informations are stored in metastore and what informations are stored in Warehouse directory of hive.



Regards,
Nagarjuna K



--
Nitin Pawar


CONFIDENTIALITY NOTICE
======================
This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.

Re: warehouse directory of HIVE

Posted by Stephen Sprague <sp...@gmail.com>.
@nagarjuna - also, there's nothing preventing you from logging into your
mysql server and poking around in there yourself. That trumps all comments
and documentation. :)


On Wed, May 8, 2013 at 2:28 AM, Nitin Pawar <ni...@gmail.com> wrote:

> meta store contains all the information related to your table definitions,
> partitions, serdes etc
>
> warehouse directory is just a location where the raw data from your table
> is stored
>
>
> On Wed, May 8, 2013 at 2:56 PM, nagarjuna kanamarlapudi <
> nagarjuna.kanamarlapudi@gmail.com> wrote:
>
>> Just wondering what information does Hive  store in metastore and
>> warehouse directory .
>>
>> I configured my metastore to mysql. I also in the warehouse directory of
>> hive (on HDFS) directories with names <database_name>.db
>>
>> What informations are stored in metastore and what informations are
>> stored in Warehouse directory of hive.
>>
>>
>>
>> Regards,
>> Nagarjuna K
>>
>
>
>
> --
> Nitin Pawar
>

Re: warehouse directory of HIVE

Posted by Nitin Pawar <ni...@gmail.com>.
meta store contains all the information related to your table definitions,
partitions, serdes etc

warehouse directory is just a location where the raw data from your table
is stored


On Wed, May 8, 2013 at 2:56 PM, nagarjuna kanamarlapudi <
nagarjuna.kanamarlapudi@gmail.com> wrote:

> Just wondering what information does Hive  store in metastore and
> warehouse directory .
>
> I configured my metastore to mysql. I also in the warehouse directory of
> hive (on HDFS) directories with names <database_name>.db
>
> What informations are stored in metastore and what informations are stored
> in Warehouse directory of hive.
>
>
>
> Regards,
> Nagarjuna K
>



-- 
Nitin Pawar