Hi, all
Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html, if I
set "hive.querylog.location" to an empty string, it won't create structured
log.

I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
<property>
  <name>hive.querylog.location</name>
  <value></value>
</property>

BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history
file in /tmp/<user.name> which is the default directory of this property.

Do you know how to set an EMPTY value in hive-site.xml?
Thanks,
- Bing

How about setting it to /dev/null . Not sure if that would help in your
case. Just an hack.

Regards.

On Thu, Dec 6, 2012 at 2:14 PM, Bing Li <[EMAIL PROTECTED]> wrote:

> Hi, all
> Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html, if
> I set "hive.querylog.location" to an empty string, it won't create
> structured log.
>
> I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
> <property>
>   <name>hive.querylog.location</name>
>   <value></value>
> </property>
>
> BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history
> file in /tmp/<user.name> which is the default directory of this property.
>
> Do you know how to set an EMPTY value in hive-site.xml?
>
>
> Thanks,
> - Bing
>

it will exit with error like

FAILED: Failed to open Query Log: /dev/null/hive_job_log_xxx.txt

and pointed that the path is not a directory.
2012/12/6 Jithendranath Joijoide <[EMAIL PROTECTED]>

> How about setting it to /dev/null . Not sure if that would help in your
> case. Just an hack.
>
> Regards.
>
>
> On Thu, Dec 6, 2012 at 2:14 PM, Bing Li <[EMAIL PROTECTED]> wrote:
>
>> Hi, all
>> Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html,
>> if I set "hive.querylog.location" to an empty string, it won't create
>> structured log.
>>
>> I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
>> <property>
>>   <name>hive.querylog.location</name>
>>   <value></value>
>> </property>
>>
>> BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history
>> file in /tmp/<user.name> which is the default directory of this property.
>>
>> Do you know how to set an EMPTY value in hive-site.xml?
>>
>>
>> Thanks,
>> - Bing
>>
>
>

It’s not supported now.
I think you a rise it in JIRA.

Regards
Ransom

From: Bing Li [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2012 5:06 PM
To: [EMAIL PROTECTED]
Subject: Re: How to set an empty value to hive.querylog.location to disable the creation of hive history file

it will exit with error like

FAILED: Failed to open Query Log: /dev/null/hive_job_log_xxx.txt

and pointed that the path is not a directory.

2012/12/6 Jithendranath Joijoide <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
How about setting it to /dev/null . Not sure if that would help in your case. Just an hack.

Regards.

On Thu, Dec 6, 2012 at 2:14 PM, Bing Li <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Hi, all
Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html, if I set "hive.querylog.location" to an empty string, it won't create structured log.

I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
<property>
  <name>hive.querylog.location</name>
  <value></value>
</property>

BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history file in /tmp/<user.name<http://user.name>> which is the default directory of this property.

Do you know how to set an EMPTY value in hive-site.xml?
Thanks,
- Bing

do you mean NOT support disable the creation of hive history files OR NOT
support using an empty string to achieve this?

If Hive doesn't support disable the creation of query logs, do you know the
reason?

Thanks,
- Bing

2012/12/6 Hezhiqiang (Ransom) <[EMAIL PROTECTED]>

>  It’s not supported now. ****
>
> I think you a rise it in JIRA.****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Bing Li [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, December 06, 2012 5:06 PM
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: How to set an empty value to hive.querylog.location to
> disable the creation of hive history file****
>
> ** **
>
> it will exit with error like
>
> FAILED: Failed to open Query Log: /dev/null/hive_job_log_xxx.txt
>
> and pointed that the path is not a directory.
>
>
>
> ****
>
> 2012/12/6 Jithendranath Joijoide <[EMAIL PROTECTED]>****
>
> How about setting it to /dev/null . Not sure if that would help in your
> case. Just an hack.****
>
> ** **
>
> Regards.****
>
> ** **
>
> On Thu, Dec 6, 2012 at 2:14 PM, Bing Li <[EMAIL PROTECTED]> wrote:***
> *
>
> Hi, all
> Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html, if
> I set "hive.querylog.location" to an empty string, it won't create
> structured log.
>
> I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
> <property>
>   <name>hive.querylog.location</name>
>   <value></value>
> </property>
>
> BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history
> file in /tmp/<user.name> which is the default directory of this property.
>
> Do you know how to set an EMPTY value in hive-site.xml?
>
>
> Thanks,
> - Bing****
>
> ** **
>
> ** **
>

I filed it as HIVE-3779
https://issues.apache.org/jira/browse/HIVE-3779

Thanks,
- Bing

2012/12/6 Hezhiqiang (Ransom) <[EMAIL PROTECTED]>

>  It’s not supported now. ****
>
> I think you a rise it in JIRA.****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Bing Li [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, December 06, 2012 5:06 PM
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: How to set an empty value to hive.querylog.location to
> disable the creation of hive history file****
>
> ** **
>
> it will exit with error like
>
> FAILED: Failed to open Query Log: /dev/null/hive_job_log_xxx.txt
>
> and pointed that the path is not a directory.
>
>
>
> ****
>
> 2012/12/6 Jithendranath Joijoide <[EMAIL PROTECTED]>****
>
> How about setting it to /dev/null . Not sure if that would help in your
> case. Just an hack.****
>
> ** **
>
> Regards.****
>
> ** **
>
> On Thu, Dec 6, 2012 at 2:14 PM, Bing Li <[EMAIL PROTECTED]> wrote:***
> *
>
> Hi, all
> Refer to https://cwiki.apache.org/Hive/adminmanual-configuration.html, if
> I set "hive.querylog.location" to an empty string, it won't create
> structured log.
>
> I filed hive-site.xml in HIVE_HOME/conf and add the following setting,
> <property>
>   <name>hive.querylog.location</name>
>   <value></value>
> </property>
>
> BUT it didn't work, when launch HIVE_HOME/bin/hive, it created a history
> file in /tmp/<user.name> which is the default directory of this property.
>
> Do you know how to set an EMPTY value in hive-site.xml?
>
>
> Thanks,
> - Bing****
>
> ** **
>
> ** **
>