Member since
05-11-2017
6
Posts
0
Kudos Received
0
Solutions
05-17-2017
06:12 AM
No i am not trying to do any logging. Also I was trying to execute beeline --silent=true in hive but it didnt work. Any though ?
... View more
05-17-2017
04:39 AM
@Sindhu thanks for the update. But is this like when we try exporting the result to some log file ?
... View more
05-16-2017
05:16 AM
Yeah - its windows and Hadoop 2.7.1 to add on -- Beeline version 2.1.1 by Apache Hive
... View more
05-15-2017
02:50 PM
Greg - Thanks for your quick reply. I did try this command, but it don't work still. hive --hiveconf hive.root.logger=INFO,console Any other way ?
... View more
05-15-2017
08:35 AM
Hi - I have configured and running HIVE in windows. Everything works well, but when I query any command in hive window. I am prompted with many INFO & WARN message. Even If I run SHOW DATABASE; I get many info as below. 17/05/15 14:04:06 INFO metastore.ObjectStore: Initialized ObjectStore
17/05/15 14:04:06 INFO sqlstd.SQLStdHiveAccessController: Created SQLStdHiveAccessController for session context : HiveAuthzSessio
ntext [sessionString=adc50d5a-a598-4454-8769-0b74bd7ad69c, clientType=HIVESERVER2]
17/05/15 14:04:06 INFO exec.DDLTask: results : 2
17/05/15 14:04:06 INFO ql.Driver: Completed executing command(queryId=svarun_20170515140405_dbd1b920-39ad-45fd-93c0-7a1bf4ac96f8);
me taken: 0.066 seconds
OK
17/05/15 14:04:06 INFO ql.Driver: OK
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c Thread-8
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to Thread-8.java:62)
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c main
17/05/15 14:04:06 INFO Configuration.deprecation: mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inp
ir at com.sun.proxy.$Proxy23.ExecuteStatement(Unknown Source)
17/05/15 14:04:06 INFO mapred.FileInputFormat: Total input paths to process : 1va:308)
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to main88)
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to main
default at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:886)
my_db at org.apache.hive.beeline.cli.HiveCli.runWithArgs(HiveCli.java:35)
2 rows selected (0.596 seconds)ine.cli.HiveCli.main(HiveCli.java:29)
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Updating thread name to adc50d5a-a598-4454-8769-0b74bd7ad69c main
17/05/15 14:04:06 INFO conf.HiveConf: Using the default value passed in for log id: adc50d5a-a598-4454-8769-0b74bd7ad69c
17/05/15 14:04:06 INFO session.SessionState: Resetting thread name to mainn_20170515140231_01575edd-1876-49f0-aa2b-76b9c567a1d1); Can any one help out on how to hide or off this? Thanks
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
05-11-2017
08:58 AM
Can you help me with more detail on this. How should I ? When I connect to hive or run any command in hive I am having plenty of of INFO & WARN message and my hive result is lost in these junk INFO. How should I get rid of this?
... View more