Yellowfin connection to Hiveserver2 is failing : java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils

[#1]

We are trying to connect Yellowfin with Hiverserver2 and getting exception:

java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils

Environment Details:

Hadoop Version: HDP 2.6 (centos7, non-kerberized) ; Yellowfin Version: 7.3 (Ubuntu)

Below are the jar files:

root@Yellowfin73plus:/opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib# ll

total 133776

drwxr-x--- 2 root root 4096 Nov 9 14:13 ./

drwxr-x--- 3 root root 4096 Nov 9 13:32 ../

-rw-r----- 1 root root 54705 Jun 8 15:56 activation.jar

-rw-r----- 1 root root 105752 Jun 8 15:56 aqljdbc.jar

-rw-r----- 1 root root 15738 Jun 8 15:56 auth0.jar

-rw-r----- 1 root root 1599986 Jun 8 15:56 axis.jar

-rw-r----- 1 root root 3313563 Jun 8 15:56 batik-all.jar

-rw-r----- 1 root root 1815677 Jun 8 15:56 bcprov-jdk15-1.46.jar

-rw-r----- 1 root root 1961412 Jun 8 15:56 cachedb.jar

-rw-r----- 1 root root 284243 Jun 8 15:56 ccjdbc4.jar

-rw-r----- 1 root root 228136 Jun 8 15:56 columnar.jar

-rw-r----- 1 root root 168760 Jun 8 15:56 commons-beanutils-core.jar

-rw-r----- 1 root root 91699 Jun 8 15:56 commons-chain-1.2.jar

-rw-r--r-- 1 root root 58160 Nov 9 12:43 commons-codec-1.4.jar

-rw-r----- 1 root root 232718 Jun 8 15:56 commons-codec-1.6.jar

-rw-r----- 1 root root 588337 Jun 8 15:56 commons-collections-3.2.2.jar

-rw-r----- 1 root root 751238 Jun 8 15:56 commons-collections4-4.1.jar

-rw-r----- 1 root root 196768 Jun 8 15:56 commons-digester-2.1.jar

-rw-r----- 1 root root 71372 Jun 8 15:56 commons-discovery.jar

-rw-r----- 1 root root 70282 Jun 8 15:56 commons-fileupload-1.3.2.jar

-rw-r----- 1 root root 173587 Jun 8 15:56 commons-io-2.2.jar

-rw-r----- 1 root root 315805 Jun 8 15:56 commons-lang3-3.1.jar

-rw-r----- 1 root root 37946 Jun 8 15:56 commons-logging-1.0.4.jar

-rw-r--r-- 1 root root 62050 Nov 9 12:43 commons-logging-1.1.3.jar

-rw-r----- 1 root root 2038489 Jun 8 15:56 commons-math3-3.5.jar

-rw-r----- 1 root root 280983 Jun 8 15:56 commons-net-3.3.jar

-rw-r----- 1 root root 46796 Jun 8 15:56 commons-validator.jar

-rw-r----- 1 root root 415578 Jun 8 15:56 commons-vfs2-2.0.jar

-rw-r----- 1 root root 19051 Jun 8 15:56 com.noelios.restlet.ext.servlet_2.5.jar

-rw-r----- 1 root root 205159 Jun 8 15:56 com.noelios.restlet.jar

-rw-r----- 1 root root 372937 Jun 8 15:56 cssparser-0.9.18.jar

-rw-r----- 1 root root 3146632 Jun 8 15:56 db2jcc.jar

-rw-r----- 1 root root 927 Jun 8 15:56 db2jcc_license_cu.jar

-rw-r----- 1 root root 3224708 Jun 8 15:56 derby.jar

-rw-r----- 1 root root 4276937 Jun 8 15:56 docx4j-3.2.3-yf.jar

-rw-r----- 1 root root 105703 Jun 8 15:56 docx4j-ImportXHTML-3.2.3-yf.jar

-rw-r----- 1 root root 24432 Jun 8 15:56 el-api-1.0.jar

-rw-r----- 1 root root 1209490 Jun 8 15:56 flying-saucer-core-9.0.9-yf.jar

-rw-r----- 1 root root 59261 Jun 8 15:56 flying-saucer-docx-9.0.9-yf.jar

-rw-r----- 1 root root 149165 Jun 8 15:56 flying-saucer-pdf-9.0.9-yf.jar

-rw-r----- 1 root root 53920 Jun 8 15:56 getopt-1.0.9.jar

-rw-r----- 1 root root 19484 Jun 8 15:56 gif-plugin.jar

-rw-r----- 1 root root 21835 Jun 8 15:56 gmbal-api-only.jar

-rw-r----- 1 root root 5482237 Jun 8 15:56 groovy-all-1.7.5.jar

-rw-r----- 1 root root 190362 Jun 8 15:56 gson-2.2.4.jar

-rw-r--r-- 1 root root 2189117 Nov 9 12:43 guava-14.0.1.jar

-rw-r----- 1 root root 1068835 Jun 8 15:56 h2.jar

-rw-r----- 1 root root 36036 Jun 8 15:56 ha-api.jar

-rw-r--r-- 1 root root 3659983 Nov 9 12:43 hadoop-common-2.7.3.2.6.2.0-205.jar

-rw-r--r-- 1 root root 359936 Nov 9 12:43 hive-common-1.2.1000.2.6.2.0-205.jar

-rw-r--r-- 1 root root 111628 Nov 9 12:43 hive-jdbc-1.2.1000.2.6.2.0-205.jar

-rw-r--r-- 1 root root 1999980 Nov 9 12:43 hive-service-1.2.1000.2.6.2.0-205.jar

-rw-r----- 1 root root 1515894 Jun 8 15:56 hsqldb.jar

-rw-r--r-- 1 root root 719304 Nov 9 12:43 httpclient-4.4.jar

-rw-r--r-- 1 root root 321639 Nov 9 12:43 httpcore-4.4.jar

-rw-r----- 1 root root 26548 Jun 8 15:56 httpmime-4.2.1.jar

-rw-r----- 1 root root 100344 Jun 8 15:56 i4-adapter.jar

-rw-r----- 1 root root 96158 Jun 8 15:56 i4-content.jar

-rw-r----- 1 root root 18885108 Jun 8 15:56 i4-core.jar

-rw-r----- 1 root root 168079 Jun 8 15:56 i4-ip.jar

-rw-r----- 1 root root 3781324 Jun 8 15:56 i4-jsps.jar

-rw-r----- 1 root root 10126472 Jun 8 15:56 i4-mi.jar

-rw-r----- 1 root root 325533 Jun 8 15:56 iijdbc.jar

-rw-r----- 1 root root 1130013 Jun 8 15:56 iText-2.1.7.jar

-rw-r----- 1 root root 1673340 Jun 8 15:56 iTextAsianCmaps.jar

-rw-r----- 1 root root 328010 Jun 8 15:56 iTextAsian.jar

-rw-r----- 1 root root 145344 Jun 8 15:56 iText-rtf-2.1.0.jar

-rw-r----- 1 root root 46968 Jun 8 15:56 jackson-annotations-2.6.0.jar

-rw-r----- 1 root root 258833 Jun 8 15:56 jackson-core-2.6.1.jar

-rw-r----- 1 root root 1166488 Jun 8 15:56 jackson-databind-2.6.1.jar

-rw-r----- 1 root root 65368 Jun 8 15:56 jakarta-oro.jar

-rw-r----- 1 root root 29806 Jun 8 15:56 jakarta-regexp-1.2.jar

-rw-r----- 1 root root 4662562 Jun 8 15:56 jasperreports-5.5.0.jar

-rw-r----- 1 root root 238189 Jun 8 15:56 javacup.jar

-rw-r----- 1 root root 571048 Jun 8 15:56 javamail-1.5.2.jar

-rw-r----- 1 root root 22331 Jun 8 15:56 javax.annotation.jar

-rw-r----- 1 root root 100092 Jun 8 15:56 jaxb-api.jar

-rw-r----- 1 root root 1112601 Jun 8 15:56 jaxb-impl.jar

-rw-r----- 1 root root 2078317 Jun 8 15:56 jaxb-xjc.jar

-rw-r----- 1 root root 31999 Jun 8 15:56 jaxrpc.jar

-rw-r----- 1 root root 46291 Jun 8 15:56 jaxws-api.jar

-rw-r----- 1 root root 2296593 Jun 8 15:56 jaxws-rt.jar

-rw-r----- 1 root root 847127 Jun 8 15:56 jaybird-full-2.2.3.jar

-rw-r----- 1 root root 396172 Jun 8 15:56 jcifs-1.3.17.jar

-rw-r----- 1 root root 310890 Jun 8 15:56 jcommon.jar

-rw-r----- 1 root root 515561 Jun 8 15:56 jconn3.jar

-rw-r----- 1 root root 1439719 Jun 8 15:56 jconn4.jar

-rw-r----- 1 root root 12577 Jun 8 15:56 jdbf-1.2.jar

-rw-r----- 1 root root 12321 Jun 8 15:56 jfreechart-experimental.jar

-rw-r----- 1 root root 1425691 Jun 8 15:56 jfreechart.jar

-rw-r----- 1 root root 2473076 Jun 8 15:56 jgroups-3.6.11.Final.jar

-rw-r----- 1 root root 19428 Jun 8 15:56 jpscs.jar

-rw-r----- 1 root root 278297 Jun 8 15:56 jsch-0.1.53.jar

-rw-r----- 1 root root 43623 Jun 8 15:56 json.jar

-rw-r----- 1 root root 314991 Jun 8 15:56 jsoup-1.8.2.jar

-rw-r----- 1 root root 135369 Jun 8 15:56 jsqlparser.jar

-rw-r----- 1 root root 7989 Jun 8 15:56 jsr181-api.jar

-rw-r----- 1 root root 4250685 Jun 8 15:56 jt400.jar

-rw-r----- 1 root root 304581 Jun 8 15:56 jtds-1.2.8_svn.jar

-rw-r----- 1 root root 697509 Jun 8 15:56 jxl.jar

-rw-r----- 1 root root 439100 Jun 8 15:56 ldap.jar

-rw-r--r-- 1 root root 234201 Nov 9 12:43 libthrift-0.9.3.jar

-rw-r----- 1 root root 489898 Jun 8 15:56 log4j-1.2.17.jar

-rw-r----- 1 root root 42224 Jun 8 15:56 management-api.jar

-rw-r----- 1 root root 848401 Jun 8 15:56 mysql-connector-java-5.1.25-bin.jar

-rw-r----- 1 root root 2095867 Jun 8 15:56 ojdbc5.jar

-rw-r----- 1 root root 350434 Jun 8 15:56 olap4j-1.1.1-yf.jar

-rw-r----- 1 root root 218289 Jun 8 15:56 olap4j-xmla-1.1.1-yf.jar

-rw-r----- 1 root root 55550 Jun 8 15:56 OpenForecast.jar

-rw-r----- 1 root root 248637 Jun 8 15:56 org.restlet.jar

-rw-r----- 1 root root 2497380 Jun 8 15:56 poi-3.13-20150929.jar

-rw-r----- 1 root root 1142386 Jun 8 15:56 poi-ooxml-3.13-20150929.jar

-rw-r----- 1 root root 5641539 Jun 8 15:56 poi-ooxml-schemas-3.13-20150929.jar

-rw-r----- 1 root root 158444 Jun 8 15:56 policy.jar

-rw-r----- 1 root root 676535 Jun 8 15:56 postgresql-9.4.1212.jre7.jar

-rw-r----- 1 root root 165139 Jun 8 15:56 pvjdbc2.jar

-rw-r----- 1 root root 8073 Jun 8 15:56 pvjdbc2x.jar

-rw-r----- 1 root root 19357 Jun 8 15:56 saaj.jar

-rw-r----- 1 root root 14526 Jun 8 15:56 sac-1.3.jar

-rw-r----- 1 root root 45484 Jun 8 15:56 shapefilereader-1.0.jar

-rw-r--r-- 1 root root 32119 Nov 9 12:43 slf4j-api-1.7.10.jar

-rw-r----- 1 root root 26084 Jun 8 15:56 slf4j-api-1.7.5.jar

-rw-r----- 1 root root 3201083 Jun 8 15:56 sqlite-jdbc-3.7.2.jar

-rw-r----- 1 root root 585020 Jun 8 15:56 sqljdbc4.jar

-rw-r----- 1 root root 15705 Jun 8 15:56 stax-ex.jar

-rw-r----- 1 root root 64308 Jun 8 15:56 streambuffer.jar

-rw-r----- 1 root root 321348 Jun 8 15:56 struts-core-1.3.10.17fc.jar

-rw-r----- 1 root root 256597 Jun 8 15:56 struts-taglib-1.3.10.17fc.jar

-rw-r----- 1 root root 206430 Jun 8 15:56 taglibs-standard-impl-1.2.5.jar

-rw-r----- 1 root root 163271 Jun 8 15:56 taglibs-standard-jstlel-1.2.5.jar

-rw-r----- 1 root root 1442364 Jun 8 15:56 unboundid-ldapsdk-se.jar

-rw-r----- 1 root root 186700 Jun 8 15:56 wsdl4j-1.6.3.jar

-rw-r----- 1 root root 1367760 Jun 8 15:56 xercesImpl-2.11.0.jar

-rw-r----- 1 root root 85613 Jun 8 15:56 xml-apis-ext.jar

-rw-r----- 1 root root 2730866 Jun 8 15:56 xmlbeans-2.6.0.jar

-rw-r----- 1 root root 601866 Jun 8 15:56 xmlgraphics-commons-1.5.jar

-rw-r----- 1 root root 7188 Jun 8 15:56 xmlpull-1.1.3.1.jar

-rw-r----- 1 root root 24956 Jun 8 15:56 xpp3_min-1.1.4c.jar

-rw-r----- 1 root root 549133 Jun 8 15:56 xstream-1.4.9.jar

-rw-r----- 1 root root 17479 Jun 8 15:56 yfbirt431.jar

-rw-r----- 1 root root 891090 Jun 8 15:56 yuicompressor-2.4.7.jar

We used below link for reference:

https://www.yellowfinbi.com/resources/forum/yfforum-connecting-to-hiveserver2-thread-173126

Did some research and found that issue might be related to missing commons-lang.jar but commons-lang3-3.1.jar is already present under /opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib.

We tried with commons-lang-2.6.jar, commons-lang3-3.4.jar, commons-lang3.jar but none of them worked.

Are we missing any jars/configuration?

Please Suggest..

[#2]

@Shyam Shaw

It will be helpful if you can share the complete stack Trace of the ClassNotFoundException

java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils

.

The Complete Stack Trace will tell us which API is actually making the call for StringUtils (is it yfforum or Hive) and then based on that we will need to check the respective JAR loading order and version.

[#3]

Hi, @Jay Kumar SenSharma

Thanks for the quick response. Below is the complete stack trace:

YF:2017-11-10 10:07:05: INFO (Utils:parseURL) - Resolved authority: <hostname>:10000

java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:181) at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:156) at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) at com.hof.mi.jdbc.driver.SeparateClassLoaderJDBC.connect(SeparateClassLoaderJDBC.java:131) at com.hof.mi.jdbc.driver.HiveJDBC.connect(HiveJDBC.java:67) at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179) at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127) at com.hof.util.DBAction.A(DBAction.java:556) at com.hof.util.DBAction.<init>(DBAction.java:512) at com.hof.mi.process.MIAdminProcess.testConnection(MIAdminProcess.java:6192) at com.hof.sources.JDBCSourcePlatformImplementation.testConnection(JDBCSourcePlatformImplementation.java:196) at com.hof.mi.web.action.CreateSimpleSourceAjaxAction.runAction(CreateSimpleSourceAjaxAction.java:177) at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)

YF:2017-11-10 10:07:05:ERROR (DBAction:A) - Error occurred when connecting to the database: java.sql.SQLException: Could not connect: java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils java.sql.SQLException: Could not connect: java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils at com.hof.mi.jdbc.driver.SeparateClassLoaderJDBC.connect(SeparateClassLoaderJDBC.java:141) at com.hof.mi.jdbc.driver.HiveJDBC.connect(HiveJDBC.java:67) at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179) at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127) at com.hof.util.DBAction.A(DBAction.java:556) at com.hof.util.DBAction.<init>(DBAction.java:512) at com.hof.mi.process.MIAdminProcess.testConnection(MIAdminProcess.java:6192) at com.hof.sources.JDBCSourcePlatformImplementation.testConnection(JDBCSourcePlatformImplementation.java:196) at com.hof.mi.web.action.CreateSimpleSourceAjaxAction.runAction(CreateSimpleSourceAjaxAction.java:177) at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)

java.sql.SQLException: Could not connect: java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils at com.hof.mi.jdbc.driver.SeparateClassLoaderJDBC.connect(SeparateClassLoaderJDBC.java:141) at com.hof.mi.jdbc.driver.HiveJDBC.connect(HiveJDBC.java:67) at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179) at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127) at com.hof.util.DBAction.A(DBAction.java:556) at com.hof.util.DBAction.<init>(DBAction.java:512) at com.hof.mi.process.MIAdminProcess.testConnection(MIAdminProcess.java:6192) at com.hof.sources.JDBCSourcePlatformImplementation.testConnection(JDBCSourcePlatformImplementation.java:196) at com.hof.mi.web.action.CreateSimpleSourceAjaxAction.runAction(CreateSimpleSourceAjaxAction.java:177) at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)

[#4]

@Shyam Shaw

The problem looks like a Separate Classloader that is being used by "com.hof.mi.jdbc.driver.SeparateClassLoaderJDBC"

java.sql.SQLException: Could not connect: java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils 
    at com.hof.mi.jdbc.driver.SeparateClassLoaderJDBC.connect(SeparateClassLoaderJDBC.java:141)
    at com.hof.mi.jdbc.driver.HiveJDBC.connect(HiveJDBC.java:67) at 

.

Need to see how this class is creating a Separate Classloader to know how we can make the Missing "StringUtils" class to be part of that classloader.

.

[#5]

Hi, @Jay Kumar SenSharma

I was able to fix the issue. Now we are able to connect to Hiveserver2.

-> Used hive-jdbc-1.2.1000.2.6.2.0-205-standalone.jar instead hive-jdbc-1.2.1000.2.6.2.0-205.jar

-> Selected Database, Generic JDBC instead Apache Hive2 as Apache Hive2 was using com.hof.mi.jdbc.driver.HiveJDBC as default driver and it was not allowing me to change driver to org.apache.hive.jdbc.HiveDriver

-> Connection String : jdbc:hive2://<Hiveserver2 hostname>:10000/default

-> Username/Password : blank

-> Test Connection (It worked this time), Create View & Analyze.

[#6]

Hi, @Jay Kumar SenSharma

Surprisingly, now I am able to connect to Hiveserver2 using Database Type as Apache Hive2 also. I believe it is picking up the correct driver from /opt/yellowfin/appserver/webapps/ROOT/WEB-INF/lib directory.

[#7]

Hi @Shyam Shaw

I also stuck at "java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils".

I tried use your workaround by copying the standalone version of the jar, but (probably because I use HDInsight) the version's between my hive jars are different:
hive-jdbc-2.1.0.2.6.2.25-1-standalone.jar vs hive-jdbc-1.2.1000.2.6.2.25-1.jar

and I can't find the 1.2.1000 version of the standalone driver...

When I use the 2.1.0* one I get this... org.apache.hive.org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})

which based on what I know is a drivers version mismatch...