Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

Solved Go to solution

Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

Expert Contributor

Our cluster was recently upgraded to CDH 5.5 and all the outputs generated by hive query has now a warning message shown below

WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.
WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.

But when I use Beeline I don't see them. Is there a way I can get rid of the warning without switching to Beeline at least for now?

Hive version is 1.1.0

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

Expert Contributor

To Conclude, it is not possible to remove the warning message from the Hive query output until migrating to Beeline. I found a very simple and well known workaround to this problem which almost all of us use it in shell scripting. I used the grep tool to remove the warning message from my output. Below is how I modified my script to fix the problem.

hive -S -d ns=$hiveDB -d tab=$t -d dunsCol=$c1 -d phase="$ph1" -d error=$c2 -d ts=$eColumnArray -d reporting_window=$rDate -f $dir'select_count.hsql' | grep -v "^WARN" > $gOutPut 2> /dev/null
4 REPLIES 4

Re: Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

@Alex Raj

This is another bug fixed in hive 1.3 and later.

https://issues.apache.org/jira/browse/HIVE-12179

Re: Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

Expert Contributor

I am adding the below jar but don't get any warnings. So the above Jira you mentioned is only for the Spark jars.

add jar hdfs:///data/95-utilities/hive-contrib-1.1.0-cdh5.5.2.jar;

Re: Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

@Alex Raj

yes, that was a general Jira related to spark therefore same applicable to other jar also which includes in hive classpath. Also I noticed you are using cdh? if your distro is CDH then sorry I have no idea about their distro jars.

Re: Warning message in Hive output after upgrading to hive version 1.1.0 from 0.13.0.

Expert Contributor

To Conclude, it is not possible to remove the warning message from the Hive query output until migrating to Beeline. I found a very simple and well known workaround to this problem which almost all of us use it in shell scripting. I used the grep tool to remove the warning message from my output. Below is how I modified my script to fix the problem.

hive -S -d ns=$hiveDB -d tab=$t -d dunsCol=$c1 -d phase="$ph1" -d error=$c2 -d ts=$eColumnArray -d reporting_window=$rDate -f $dir'select_count.hsql' | grep -v "^WARN" > $gOutPut 2> /dev/null
Don't have an account?
Coming from Hortonworks? Activate your account here