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

Switch to Threaded View
Hive >> mail # user >> ower of hive table


Copy link to this message
-
Re: ower of hive table
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
>