Hi hadoop, hive gurus,

    I have a requirement to change the path of the scratch folder of Hive.  Hence I have added following property in Hive-Site.xml and changed its value as required.

<property>
  <name>hive.exec.scratchdir</name>
  <value/tmp/example</value>
  <description>Scratch space for Hive jobs</description>
</property>

But still it is not reflecting as required. Do I need to restart Hive server to read the updated value in the file.

Also is there any other way other than restarting Hive server?

Any pointers will be helpful.

Thanks And Regards
Uddipan Mukherjee
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any damage
you may sustain as a result of any virus in this e-mail. You should carry out your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

by restarting the hive server your problem should be solved.

Not sure if we have any other ways of starting the hive server other than .

1. bin/hive --service hiveserver

2. HIVE_PORT=xxxx ./hive --service hiveserver

Regards,
Nagarjuna

On Tue, Oct 9, 2012 at 8:10 PM, Uddipan Mukherjee <
[EMAIL PROTECTED]> wrote:

>  Hi hadoop, hive gurus,****
>
> ** **
>
>     I have a requirement to change the path of the scratch folder of Hive.
>  Hence I have added following property in Hive-Site.xml and changed its
> value as required.****
>
> ** **
>
> <property>
>   <name>hive.exec.scratchdir</name>
>   <value/tmp/example</value>
>   <description>Scratch space for Hive jobs</description>
> </property>****
>
> ** **
>
> But still it is not reflecting as required. Do I need to restart Hive
> server to read the updated value in the file.****
>
> ** **
>
> Also is there any other way other than restarting Hive server?****
>
> ** **
>
> Any pointers will be helpful.****
>
> ** **
>
> Thanks And Regards****
>
> Uddipan Mukherjee****
>
> ** **
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further, you are not
> to copy, disclose, or distribute this e-mail or its contents to any other person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
> every reasonable precaution to minimize this risk, but is not liable for any damage
> you may sustain as a result of any virus in this e-mail. You should carry out your
> own virus checks before opening the e-mail or attachment. Infosys reserves the
> right to monitor and review the content of all messages sent to or from this e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
>