ower of hive table

[hadoop hive <ha...@gmail.com>]

hi folks,

I have a quick question, suppose I create a table in hive by a user and
after sometime I want to change the owner of the table.

1- how can I change the owner of the table.
2- does I also need to change the directory owner
3- or what is the feasible way to do that.

thanks
hadoophive

Re: ower of hive table

[Abdelrahman Shettia <as...@hortonworks.com>]

Hi All ,

The ownership of hive table is controlled by the ownership of its hdfs dir.
The table dir on hdfs ownership can be changed by running the following
command.

hadoop fs -chown $user:$grp -R $table_dir

$table_dir:  can be obtained by running in hive shell .
> desc extended 'table_name' ;

Hope this help.

Thanks
-Abdelrahman


On Wed, Feb 20, 2013 at 1:43 AM, hadoop hive <ha...@gmail.com> wrote:

> hi folks,
>
> I have a quick question, suppose I create a table in hive by a user and
> after sometime I want to change the owner of the table.
>
> 1- how can I change the owner of the table.
> 2- does I also need to change the directory owner
> 3- or what is the feasible way to do that.
>
> thanks
> hadoophive
>