I chang beeline-log4j.properties to log4j.rootLogger=INFO, console. When I use (beeline -u jdbc:hive2:// ) and (set hive.execution.engine=mr) , the query log display
scan complete in 5ms Connecting to jdbc:hive2:// 15/05/27 13:06:40 [main]: WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/bi_etl/soft/hadoop-2.3.0-cdh5.0.2-hive-1.1.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/bi_etl/soft/zhaoheng-hive-1.1.0/lib/hive-jdbc-1.1.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 15/05/27 13:06:40 [main]: INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 15/05/27 13:06:40 [main]: INFO metastore.ObjectStore: ObjectStore, initialize called 15/05/27 13:06:41 [main]: INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 15/05/27 13:06:41 [main]: INFO DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored But when I change engine to Tez,the query log disappear 0: jdbc:hive2://> set hive.execution.engine=tez; 15/05/27 13:08:00 [main]: INFO operation.Operation: Putting temp output to file /tmp/bi_etl/7478ed27-0ef8-4b79-a281-89afb45f6d415706719640468050121.pipeout No rows affected (0.006 seconds) 0: jdbc:hive2://> select count(*) from p_city; +------+--+ | _c0 | +------+--+ | 531 | +------+--+ another problem,when I use beeline -u jdbc:hive2://10.4.11.4:10000,the query log disappear jdbc:hive2://10.4.11.4:10000> select count(*) from p_city; +------+--+ | _c0 | +------+--+ | 531 | +------+--+ r7raul1...@163.com From: Chinna Rao Lalam Date: 2015-05-27 12:35 To: user Subject: Re: Beeline connect to hiveserver2 didn't print log. By default beeline logs will come to console with log level WARN only. If you need some changes update the beeline-log4j.properties. On Wed, May 27, 2015 at 8:58 AM, r7raul1...@163.com <r7raul1...@163.com> wrote: I use hive1.1.0 beeline remote connect to hiveserver2. When I submit query , only query result return. No log return. Where can I find the execution log? r7raul1...@163.com -- Hope It Helps, Chinna
