Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of heyongqiangict@gmail.com
 designates 209.85.210.46 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CA+FBdFS0aBAGGD7RjSh5R851znrVL4eif-L==JGsvy+E=yFkXg@mail.gmail.com>
References: 
 <CAK0mCrT0x6euobXppDAJh_ftUkTW+6Ac8c=zPJvcANRUR=uMsQ@mail.gmail.com>
	<CA+FBdFS0aBAGGD7RjSh5R851znrVL4eif-L==JGsvy+E=yFkXg@mail.gmail.com>
Date: Wed, 24 Aug 2011 17:48:48 -0700
Message-ID: 
 <CAJBK50ADq2Zb6FFH5ZP_aoJMzGh-ANy=OF8_A-nMypGFNGh=ag@mail.gmail.com>
Subject: Re: Local and remote metastores
From: yongqiang he <heyongqiangict@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 <hashutosh@apache.org> wr=
ote:
> Alex,
> Difference between the two is that in case of local metastore, hive clien=
t
> communicates directly to the mysql while in case of remote metastore, hiv=
e
> client first talks to a remote metastore which in turns talks to mysql. I=
n
> terms of feature-set they are identical.
> Hope it helps,
> Ashutosh
>
> On Mon, Aug 22, 2011 at 09:03, Alex Holmes <grep.alex@gmail.com> wrote:
>>
>> Hi everyone,
>>
>> Does anyone know the differences between local and remove Hive
>> metastores? =A0Are there features that are only provided by the remote
>> datastore (like authorization)? =A0Is the use of a local metastore
>> recommended in production?
>>
>> Many thanks,
>> Alex
>
>