Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - ower of hive table


+
hadoop hive 2013-02-20, 09:43
Copy link to this message
-
Re: ower of hive table
Abdelrahman Shettia 2013-02-21, 17:59
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 <[EMAIL PROTECTED]> 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
>