You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Bala Krishna Gangisetty <ba...@altiscale.com> on 2014/08/22 23:12:22 UTC

Re: how to alter location where database is point to

Try doing:

alter database *<database> *set dbproperties ('hive.warehouse.dir' = '
*newlocation');*

--Bala G.


On Fri, Aug 22, 2014 at 8:59 AM, Hussain Jamali <hu...@amdocs.com>
wrote:

>  Hi All,
>
> Can somebody help me with alter command to change the hive database
> location in hive 11
>
>
>
> I have tried below commands  both are failing
>
>
>
> alter database <database> set location '<location>';
>
> alter database <database>  location '<location>';
>
>
>
>
>
> Thanks in advance
>
> Hussain Jamali
>
>
>
>
>
>
>  This message and the information contained herein is proprietary and
> confidential and subject to the Amdocs policy statement, you may review at
> http://www.amdocs.com/email_disclaimer.asp
>