copy $HIVE_HOME/conf/hive-log4j2.properties.template to $HIVE_HOME/conf/hive-log4j2.properties
Change the values in that file to WARN etc. For example property.hive.log.level = INFO HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <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 18 August 2016 at 06:26, karthi keyan <karthi93.san...@gmail.com> wrote: > Mich > > I enabled it by adding the log4j2 in the Hive classpath and i can able to > get the hive.log file configured in the log4j2(property.hive.log.dir) but i > didn't find any logs in that file. > > started Hiveserver2,log file was created but cant find anything in it. > > I can see the logs in Console. > > Does i need to work with logging level ? > > Best, > Karthik > > On Wed, Aug 17, 2016 at 6:44 PM, Mich Talebzadeh < > mich.talebza...@gmail.com> wrote: > >> Have you set this up conf/hive-log4j2.properties? >> >> SLF4J: Class path contains multiple SLF4J bindings. >> SLF4J: Found binding in [jar:file:/usr/lib/hive/lib/hi >> ve-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: Found binding in [jar:file:/usr/lib/hive/lib/lo >> g4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: Found binding in [jar:file:/home/hduser/hadoop- >> 2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/s >> lf4j/impl/StaticLoggerBinder.class] >> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >> explanation. >> SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4 >> jLoggerFactory] >> Logging initialized using configuration in file:/usr/lib/hive/conf/hive-l >> og4j2.properties >> hive> >> >> >> >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * >> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <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 17 August 2016 at 13:57, karthi keyan <karthi93.san...@gmail.com> >> wrote: >> >>> I didnt get any log while connecting the Hiveserver with beeline and >>> getting exception as >>> >>> ERROR StatusLogger No log4j2 configuration file found. Using default >>> configurati >>> on: logging only errors to the console. >>> >>> could any one help me resolve this or guide me enable the logs in HIVE >>> 2.0.0. >>> >>> Best, >>> Karthik >>> >> >> >