Forgot to add, if you want full filesystem level security on HDFS then you will need to enable kerberos based security.
On Tue, Mar 26, 2013 at 7:41 AM, Nitin Pawar <nitinpawar...@gmail.com>wrote: > Sanjay, > > can you try adding 'LOCATION' clause to your create statement. > By default the hive warehouse directory is writable by all the user. To > create it by the individual users you need to provide by the location > clause. > > > On Tue, Mar 26, 2013 at 7:31 AM, Sanjay Subramanian < > sanjay.subraman...@wizecommerce.com> wrote: > >> Steps to recreate the use case: >> >> - Log in as *sasubramanian* to Linux Box >> - Execute hive -e "CREATE TABLE name (id INT, name STRING);" >> - Go to HDFS /user/hive/warehouse/ >> >> Name Type Size Replication Block Size Modification Time >> Permission Owner Group >> name dir 2013-03-25 18:57 rwxr-xr-x >> *hive* supergroup >> >> I want the table top be created as Owner = sasubramanian >> How can I do that ? >> >> Thanks >> sanjay >> >> CONFIDENTIALITY NOTICE >> ====================== >> This email message and any attachments are for the exclusive use of the >> intended recipient(s) and may contain confidential and privileged >> information. Any unauthorized review, use, disclosure or distribution is >> prohibited. If you are not the intended recipient, please contact the >> sender by reply email and destroy all copies of the original message along >> with any attachments, from your computer system. If you are the intended >> recipient, please be advised that the content of this message is subject to >> access, review and disclosure by the sender's Email System Administrator. >> > > > > -- > Nitin Pawar > -- Nitin Pawar