Try doing:
alter database *<database> *set dbproperties ('hive.warehouse.dir' = '
*newlocation');*
--Bala G.
On Fri, Aug 22, 2014 at 8:59 AM, Hussain Jamali <[email protected]>
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
>
