You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Matouk IFTISSEN <ma...@ysance.com> on 2014/02/21 14:59:53 UTC
Re: How To Change Location of Hive Log File
Hello,
For Hive add this in hive-site.xml in all hive's node
<property>
<name>hive.querylog.location</name>
<value>/local_path</value>
<description>logs de requetes hive pour la redirection de logs
hive</description>
</property>
For Hadoop (job mapred) add this in 'hadoop-env.sh' in all hadoop's node
export HADOOP_LOG_DIR=/local_path
Hope this help you ;)
Matouk
2014-02-21 13:06 GMT+01:00 Arafat, Moiz <mo...@teamaol.com>:
> Hi Hive Users ,
>
> I have used below 2 variables to override the location of log files.
> Default location is /tmp
>
> - hiveconf hive.log.dir
> - hiveconf hive.querylog.location=
>
> It works fine, but when I have a map-join in the sql , it will still go
> to /tmp instead of the value i provided. Please help.
>
> Thanks,
>
> Moiz
>
--
*Matouk IFTISSEN | Consultant BI & Big Data [image: http://www.ysance.com] *
24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/>
Fax : +33 1 73 72 97 26
*Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook
<https://www.facebook.com/pages/Ysance/131036788697> | Google+
<https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts>
| LinkedIn
<http://www.linkedin.com/company/ysance> | Newsletter
<http://www.ysance.com/nous-contacter.html>*
*Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel
<http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*
RE: How To Change Location of Hive Log File
Posted by "Arafat, Moiz" <mo...@teamaol.com>.
Thanks Matouk.
Updating the hive-log4j.properties and hive-exec-log4j.properties and changing the location of hive.log.dir does work.
But my question is if I am calling hive as below, Why it does not work in case of MAPJOIN . I see that in case of Mapjoin it creates a different file which goes to /tmp but remaining files go to the updated location "/data/hive_log/log/". this new file is only created in case of map joins not in other cases .
hive -hiveconf hive.log.dir=/data/hive_log/log/ -hiveconf hive.querylog.location=/data/hive_log/log/
is it because in case of MapJoins , hive reads the hive-log4j.properties again ?
Please advise .
Thanks,
Moiz
________________________________
From: Matouk IFTISSEN [matouk.iftissen@ysance.com]
Sent: Friday, February 21, 2014 8:59 AM
To: user@hive.apache.org
Subject: Re: How To Change Location of Hive Log File
Hello,
For Hive add this in hive-site.xml in all hive's node
<property>
<name>hive.querylog.location</name>
<value>/local_path</value>
<description>logs de requetes hive pour la redirection de logs hive</description>
</property>
For Hadoop (job mapred) add this in 'hadoop-env.sh’ in all hadoop's node
export HADOOP_LOG_DIR=/local_path
Hope this help you ;)
Matouk
2014-02-21 13:06 GMT+01:00 Arafat, Moiz <mo...@teamaol.com>>:
Hi Hive Users ,
I have used below 2 variables to override the location of log files. Default location is /tmp
* hiveconf hive.log.dir
* hiveconf hive.querylog.location=
It works fine, but when I have a map-join in the sql , it will still go to /tmp instead of the value i provided. Please help.
Thanks,
Moiz
--
Matouk IFTISSEN | Consultant BI & Big Data
[http://www.ysance.com]
24 rue du sentier - 75002 Paris - www.ysance.com<http://www.ysance.com/><http://www.ysance.com/>
Fax : +33 1 73 72 97 26
Ysance sur :Twitter<http://twitter.com/ysance> | Facebook<https://www.facebook.com/pages/Ysance/131036788697> | Google+<https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts> | LinkedIn<http://www.linkedin.com/company/ysance> | Newsletter<http://www.ysance.com/nous-contacter.html>
Nos autres sites : ys4you<http://wwww.ys4you.com/> | labdecisionnel<http://www.labdecisionnel.com/> | decrypt<http://decrypt.ysance.com/>