You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Bing Li <sa...@gmail.com> on 2012/12/06 09:44:31 UTC

How to set an empty value to hive.querylog.location to disable the creation of hive history file

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

Re: How to set an empty value to hive.querylog.location to disable the creation of hive history file

Posted by Bing Li <sa...@gmail.com>.
I filed it as HIVE-3779
https://issues.apache.org/jira/browse/HIVE-3779

Thanks,
- Bing

2012/12/6 Hezhiqiang (Ransom) <ra...@huawei.com>

>  It’s not supported now. ****
>
> I think you a rise it in JIRA.****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Bing Li [mailto:sarah.libing@gmail.com]
> *Sent:* Thursday, December 06, 2012 5:06 PM
> *To:* user@hive.apache.org
> *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 <pi...@gmail.com>****
>
> 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 <sa...@gmail.com> 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****
>
> ** **
>
> ** **
>

Re: How to set an empty value to hive.querylog.location to disable the creation of hive history file

Posted by Bing Li <sa...@gmail.com>.
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) <ra...@huawei.com>

>  It’s not supported now. ****
>
> I think you a rise it in JIRA.****
>
> ** **
>
> Regards****
>
> Ransom****
>
> ** **
>
> *From:* Bing Li [mailto:sarah.libing@gmail.com]
> *Sent:* Thursday, December 06, 2012 5:06 PM
> *To:* user@hive.apache.org
> *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 <pi...@gmail.com>****
>
> 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 <sa...@gmail.com> 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****
>
> ** **
>
> ** **
>

RE: How to set an empty value to hive.querylog.location to disable the creation of hive history file

Posted by "Hezhiqiang (Ransom)" <ra...@huawei.com>.
It’s not supported now.
I think you a rise it in JIRA.

Regards
Ransom

From: Bing Li [mailto:sarah.libing@gmail.com]
Sent: Thursday, December 06, 2012 5:06 PM
To: user@hive.apache.org
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 <pi...@gmail.com>>
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 <sa...@gmail.com>> 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



Re: How to set an empty value to hive.querylog.location to disable the creation of hive history file

Posted by Bing Li <sa...@gmail.com>.
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 <pi...@gmail.com>

> 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 <sa...@gmail.com> 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
>>
>
>

Re: How to set an empty value to hive.querylog.location to disable the creation of hive history file

Posted by Jithendranath Joijoide <pi...@gmail.com>.
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 <sa...@gmail.com> 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
>