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.iftis...@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 <moiz.ara...@teamaol.com<mailto:moiz.ara...@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/>
