Yes, security is one of the motivation. As hive is weak on security, keeping separate warehouses makes the data secure.
Thanks, Vinod http://blog.vinodsingh.com/ On Sun, May 13, 2012 at 10:44 PM, Ranjith <ranjith.raghuna...@gmail.com>wrote: > Given that hive has the concept of multiple databases to categorize > objects. What is the motivation behind having multiple hive instances? I am > curious here.......is it for security? > > Thanks, > Ranjith > > On May 13, 2012, at 9:53 AM, Vinod Singh <vi...@vinodsingh.com> wrote: > > > That if perfectly fine. Even each user can have their own warehouse > directory. > > Thanks, > Vinod > > On Sun, May 13, 2012 at 5:37 PM, Xiaobo Gu <guxiaobo1...@gmail.com> wrote: > >> Hi, >> >> If we set different hive.metastore.warehouse.dir for the different >> Hive instances, it this ok, does them conflict with other resouces, >> such as directory paths under /tmp? >> >> Regards, >> >> Xiaobo Gu >> > >