You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Alex Holmes <gr...@gmail.com> on 2011/08/22 18:03:02 UTC

Local and remote metastores

Hi everyone,

Does anyone know the differences between local and remove Hive
metastores?  Are there features that are only provided by the remote
datastore (like authorization)?  Is the use of a local metastore
recommended in production?

Many thanks,
Alex

Re: Local and remote metastores

Posted by yongqiang he <he...@gmail.com>.
Are there features that are only provided by the remote datastore
(like authorization)?

No. All features should be provided by both. In the case of
authorization, the problem is that it did not get fully tested with a
remote metastore. So you saw some small bugs when running
authorization on a remote metastore.

Thanks
Yongqiang
On Wed, Aug 24, 2011 at 5:37 PM, Ashutosh Chauhan <ha...@apache.org> wrote:
> Alex,
> Difference between the two is that in case of local metastore, hive client
> communicates directly to the mysql while in case of remote metastore, hive
> client first talks to a remote metastore which in turns talks to mysql. In
> terms of feature-set they are identical.
> Hope it helps,
> Ashutosh
>
> On Mon, Aug 22, 2011 at 09:03, Alex Holmes <gr...@gmail.com> wrote:
>>
>> Hi everyone,
>>
>> Does anyone know the differences between local and remove Hive
>> metastores?  Are there features that are only provided by the remote
>> datastore (like authorization)?  Is the use of a local metastore
>> recommended in production?
>>
>> Many thanks,
>> Alex
>
>

Re: Local and remote metastores

Posted by Ashutosh Chauhan <ha...@apache.org>.
Alex,

Difference between the two is that in case of local metastore, hive client
communicates directly to the mysql while in case of remote metastore, hive
client first talks to a remote metastore which in turns talks to mysql. In
terms of feature-set they are identical.

Hope it helps,
Ashutosh

On Mon, Aug 22, 2011 at 09:03, Alex Holmes <gr...@gmail.com> wrote:

> Hi everyone,
>
> Does anyone know the differences between local and remove Hive
> metastores?  Are there features that are only provided by the remote
> datastore (like authorization)?  Is the use of a local metastore
> recommended in production?
>
> Many thanks,
> Alex
>