Re: hive standalone machine mapreduce can only run one query on the same partition

[Edward Capriolo <ed...@gmail.com>]

You can use the same table space and meta store if you use an external
database.

http://wiki.apache.org/hadoop/HiveDerbyServerMode

We probably should highlight this more as the setup is single user
without an external meta store.

On Sat, Apr 18, 2009 at 5:41 AM, javateck javateck <ja...@gmail.com> wrote:
> I have two standalone machines running on the same box, each of course
> running on a different port. And these two instances each has its own table
> space (by starting hive from different directories), but they have the same
> table structure, both of them have the same partitions also, and they are
> pointing to the same hadoop directory, for example, pointing to the same
> /user/hive/warehouse/mytable/dt=2009-04-15 for one partition.
> When I run two hive queries on the same partition, only one query can
> proceed, the other is hanging there and can proceed only after the first one
> is done.
> Question on this:
> 1. is this the expected behavior? and if so, how go around this?
> 2. if I have two machines, each running on different machine, but sharing
> the same hadoop directory (sharing single table store), can I query the same
> table for the same partition from the two machines simultaneously?
>
> thanks