Re: Local and remote metastores

2011-08-24 Thread yongqiang he
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 rem

Re: Local and remote metastores

2011-08-24 Thread Ashutosh Chauhan
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

Local and remote metastores

2011-08-22 Thread Alex Holmes
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