hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "r7raul1984@163.com" <r7raul1...@163.com>
Subject Re: Re: Beeline connect to hiveserver2 didn't print log.
Date Wed, 27 May 2015 05:14:59 GMT
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 | 
+------+--+

r7raul1984@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, r7raul1984@163.com <r7raul1984@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?



r7raul1984@163.com



-- 
Hope It Helps,
Chinna
Mime
View raw message