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

Posted to user@hive.apache.org by Hussain Jamali <hu...@amdocs.com> on 2014/08/22 17:59:56 UTC

how to alter location where database is point to

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

Re: how to alter location where database is point to

Posted by Bala Krishna Gangisetty <ba...@altiscale.com>.

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
>