You could fix https://issues.apache.org/jira/browse/HIVE-493 and enable it through an option. But keep in mind that using this will raise issues that I mentioned in that JIRA. I personally would not use this option because it will create headaches down the road but if you don't care then it should be fine. We used to do this some time before but taken out due to the issues mentioned there. You could bring that code back (disable it by default).
________________________________ From: Min Zhou <[email protected]> Reply-To: <[email protected]> Date: Mon, 13 Jul 2009 22:01:44 -0700 To: <[email protected]> Subject: Re: It there any way sharing directories between different users in hive The fact is that only a few tables need to share, users usually create their own tables for their jobs. On Tue, Jul 14, 2009 at 12:58 PM, Prasad Chakka <[email protected]> wrote: Then the question is why not everyone share the metadata and let hadoop enforce the file system permissions? ________________________________ From: Min Zhou <[email protected] <http://[email protected]> > Reply-To: <[email protected] <http://[email protected]> > Date: Mon, 13 Jul 2009 21:55:59 -0700 To: <[email protected] <http://[email protected]> > Subject: Re: It there any way sharing directories between different users in hive It's also my way. but actually, our table wanna sharing is one partitioned by date , it's metadata changed everyday. it's boring loading. On Tue, Jul 14, 2009 at 12:51 PM, Prasad Chakka <[email protected] <http://[email protected]> > wrote: One way is to create external table pointing to the original table location. ________________________________ From: Min Zhou <[email protected] <http://[email protected]> <http://[email protected]> > Reply-To: <[email protected] <http://[email protected]> <http://[email protected]> > Date: Mon, 13 Jul 2009 21:44:38 -0700 To: hive-user <[email protected] <http://[email protected]> <http://[email protected]> > Subject: It there any way sharing directories between different users in hive Hi all, We've set up a environment for multiple users to use hive, seperated mysql database for storing metadata was created for each user, so those users' execution can be completely isolated. But sometimes, we need to share a table to some sort of users, how to achieve it? Do you have another alternative deployment if our approach can't. Thanks in advance! Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: http://coderplay.javaeye.com -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: http://coderplay.javaeye.com -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: http://coderplay.javaeye.com
