Hi Can you try disabling async logging in HS2 and see if that helps?
set hive.async.log.enabled=false; Thanks Prasanth On Thu, Jul 7, 2016 at 3:37 AM -0700, "Mich Talebzadeh" <mich.talebza...@gmail.com<mailto:mich.talebza...@gmail.com>> wrote: Well this works in Hive 2 hive --hiveconf hive.root.logger=DEBUG,console Logging initialized using configuration in file:/usr/lib/hive/conf/hive-log4j2.properties 16/07/07 11:36:22 [main]: INFO SessionState: Logging initialized using configuration in file:/usr/lib/hive/conf/hive-log4j2.properties 16/07/07 11:36:22 [main]: DEBUG conf.VariableSubstitution: Substitution is on: hive HTH Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw http://talebzadehmich.wordpress.com Disclaimer: Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 7 July 2016 at 09:46, Xionghua Hu <huasanye...@gmail.com<mailto:huasanye...@gmail.com>> wrote: Dear all, In Hive 1.2.1 , config the log verbose , the beeline client will show the verbose log like this: 16/07/07 13:29:33 INFO mapreduce.Job: The url to track the job: http://host:8088/proxy/application_1467708727273_0035/ 16/07/07 13:29:33 INFO exec.Task: Starting Job = job_1467708727273_0035, Tracking URL = http://host:8088/proxy/application_1467708727273_0035/ 16/07/07 13:29:33 INFO exec.Task: Kill Command = /hadoop/hadoop-2.7.2/bin/hadoop job -kill job_1467708727273_0035 16/07/07 13:30:07 INFO exec.Task: Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1 16/07/07 13:30:07 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 16/07/07 13:30:07 INFO exec.Task: 2016-07-07 13:30:07,905 Stage-1 map = 0%, reduce = 0% 16/07/07 13:30:17 INFO exec.Task: 2016-07-07 13:30:17,757 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 2.39 sec 16/07/07 13:30:28 the verbose config: <property> <name>hive.server2.logging.operation.enabled</name> <value>true</value> <description>When true, HS2 will save operation logs and make them available for clients</description> </property> <property> <name>hive.server2.logging.operation.log.location</name> <value>/hadooplog/apache-hive-1.2.1-bin/operation_logs</value> <description>Top level directory where operation logs are stored if logging functionality is enabled</description> </property> <property> <name>hive.server2.logging.operation.level</name> <value>VERBOSE</value> <description> Expects one of [none, execution, performance, verbose]. HS2 operation logging mode available to clients to be set at session level. For this to work, hive.server2.logging.operation.enabled should be set to true. NONE: Ignore any logging EXECUTION: Log completion of tasks PERFORMANCE: Execution + Performance logs VERBOSE: All logs </description> </property> However, when upgrade to hive 2.1.0, with the same verbose configure, the verbose log cannot show.(Also, hue 3.10.0 cannot display the verbose log) so , how to enable the verbose log in hive 2.1.0? Any advise is appreciated. Thanks in advance!
