You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "r7raul1984@163.com" <r7...@163.com> on 2015/05/27 05:28:22 UTC
Beeline connect to hiveserver2 didn't print log.
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
Re: Re: Beeline connect to hiveserver2 didn't print log.
Posted by "r7raul1984@163.com" <r7...@163.com>.
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 <r7...@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
Re: Beeline connect to hiveserver2 didn't print log.
Posted by Chinna Rao Lalam <la...@gmail.com>.
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 <r7...@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