We are evaluating HI for our organization.
I need help setting up Hive connector in HI. I have added the driver jar into System/Drivers and also added the required entry into System/Admin/databaseDrivers.properties. However, the list of drivers in UI does not show HIVE. I have added the rest of the required jar location e.g. hadoop-core,hive-shims etc into the CLASSPATH variable in catalina.sh. Request you to verify if these are correct steps?
Hello Atreyee,
You can go through the quick-fix guide on the link given below:
Note: This quick-fix guide is for Helical Insight Version : 1.0.1 Beta
Build : R20161309_4636
Hi Team,
I followed the link (http://www.helicalinsight.com/database-support/connect-hive-server-using-helical-insight-1-0-1-beta/) to configure hive datastore connection.
when using jdbc:hive://192.xxx.xx.xx:10000/default?connectionTimeout=10000 in sample_datasource.efwd file it give a drive not found error.
I changed it to hive2 (jdbc:hive2://192.xxx.xx.xx:10000/default?connectionTimeout=10000) after which it is giving me ClassNotFoundException: org.apache.hadoop.conf.Configuration error.
Please help to create dashboard on hive data
application log
2017-04-06 18:58:34 ERROR CacheFilter:93 - Exception occurred
org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.CacheFilter.doFilter(SourceFile:70)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.SessionTimeFilter.doFilter(SourceFile:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ResourceAuthenticationAndAuthorizationFilter.doFilter(SourceFile:99)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ValidationFilter.doFilter(SourceFile:96)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.security.SecurityFilter.doFilter(SourceFile:1119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at com.helical.efw.service.impl.RequestParameterAuthenticationFilter.doFilter(SourceFile:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ErrorInterceptorFilter.doFilter(SourceFile:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:393)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:187)
at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:163)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.b(SourceFile:1074)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.newConnection(SourceFile:32)
at com.helical.efw.drivers.JDBCDriver.getConnection(SourceFile:72)
at com.helical.efw.efwcomponents.adhoc.EfwdConnection.getConnection(SourceFile:36)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:61)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:26)
at com.helical.efw.efwcomponents.adhoc.ConnectionProviderFactory.getConnection(SourceFile:19)
at com.helical.efw.efwcomponents.DatabaseMetadataInformationProvider.executeComponent(SourceFile:27)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:1118)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:43)
at com.helical.efw.efwservices.MetadataService.doService(SourceFile:25)
at com.helical.efw.controller.EfwServicesController.service(SourceFile:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
… 85 more
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.conf.Configuration
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)
… 111 more
2017-04-06 18:58:34 ERROR ValidationFilter:122 - Exception occurred
org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.CacheFilter.doFilter(SourceFile:94)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.SessionTimeFilter.doFilter(SourceFile:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ResourceAuthenticationAndAuthorizationFilter.doFilter(SourceFile:99)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ValidationFilter.doFilter(SourceFile:96)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.security.SecurityFilter.doFilter(SourceFile:1119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at com.helical.efw.service.impl.RequestParameterAuthenticationFilter.doFilter(SourceFile:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ErrorInterceptorFilter.doFilter(SourceFile:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:393)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:187)
at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:163)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.b(SourceFile:1074)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.newConnection(SourceFile:32)
at com.helical.efw.drivers.JDBCDriver.getConnection(SourceFile:72)
at com.helical.efw.efwcomponents.adhoc.EfwdConnection.getConnection(SourceFile:36)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:61)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:26)
at com.helical.efw.efwcomponents.adhoc.ConnectionProviderFactory.getConnection(SourceFile:19)
at com.helical.efw.efwcomponents.DatabaseMetadataInformationProvider.executeComponent(SourceFile:27)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:1118)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:43)
at com.helical.efw.efwservices.MetadataService.doService(SourceFile:25)
at com.helical.efw.controller.EfwServicesController.service(SourceFile:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
… 78 more
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.conf.Configuration
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)
… 104 more
2017-04-06 18:58:34 ERROR ErrorInterceptorFilter:59 - An Exception has occurred. The cause is ClassNotFoundException: org.apache.hadoop.conf.Configuration
org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ValidationFilter.doFilter(SourceFile:125)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.security.SecurityFilter.doFilter(SourceFile:1119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at com.helical.efw.service.impl.RequestParameterAuthenticationFilter.doFilter(SourceFile:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.helical.efw.filters.ErrorInterceptorFilter.doFilter(SourceFile:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration
at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:393)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:187)
at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:163)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.b(SourceFile:1074)
at com.helical.efwd.jdbc.PlainJdbcConnectionProvider.newConnection(SourceFile:32)
at com.helical.efw.drivers.JDBCDriver.getConnection(SourceFile:72)
at com.helical.efw.efwcomponents.adhoc.EfwdConnection.getConnection(SourceFile:36)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:61)
at com.helical.efw.efwcomponents.adhoc.DatabaseConnectionFactory.getConnection(SourceFile:26)
at com.helical.efw.efwcomponents.adhoc.ConnectionProviderFactory.getConnection(SourceFile:19)
at com.helical.efw.efwcomponents.DatabaseMetadataInformationProvider.executeComponent(SourceFile:27)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:1118)
at com.helical.efw.efwservices.GenericService.executeService(SourceFile:43)
at com.helical.efw.efwservices.MetadataService.doService(SourceFile:25)
at com.helical.efw.controller.EfwServicesController.service(SourceFile:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
… 65 more
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.conf.Configuration
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)
… 91 more
Hi Abhinav,
Can you confirm the below
Did you restart Tomcat after following the instructions? Please restart Tomcat and let us know if it still not working.
Hi Team,
I had restarted tomcat post changes as per instructions.
Hi Abhinav,
Seeing the logs it looks like application is not able to find the driver.
Can you please share snapshot or list of jar files present in the folder
“WEB-INF/lib”
Also can you please confirm which version of Hive you are using?
Hive version is 1.0.1
list of jars:
activation-1.1.jar
aggregates.dtd
annotations-12.0.jar
ant-1.9.1.jar
ant-launcher-1.9.1.jar
antlr-2.7.6.jar
antlr-runtime-3.4.jar
aopalliance-1.0.jar
asm-3.1.jar
asm-attrs-1.5.3.jar
asm-commons-3.1.jar
asm-tree-3.1.jar
aspectjrt-1.7.2.jar
aspectjweaver-1.7.2.jar
avalon-framework-4.1.4.jar
avatica-1.8.0.jar
avatica-metrics-1.8.0.jar
avro-1.7.5.jar
batik-1.5-fop-0.20-5.jar
bcmail-jdk14-1.38.jar
bcmail-jdk14-138.jar
bcprov-jdk14-1.38.jar
bcprov-jdk14-138.jar
bcprov-jdk15-1.45.jar
bctsp-jdk14-1.38.jar
bonecp-0.8.0.RELEASE.jar
c3p0-0.9.1.1.jar
calcite-avatica-1.6.0.jar
calcite-core-1.8.0.jar
calcite-example-csv-1.8.0.jar
calcite-linq4j-1.8.0.jar
calcite-mongodb-1.8.2.jar
cas-client-core-3.3.3.jar
cas-server-core-4.0.1.jar
cas-server-support-ldap-4.0.1.jar
castor-1.2.jar
cglib-2.2.jar
commons-beanutils-1.8.3.jar
commons-cli-1.2.jar
commons-codec-1.9.jar
commons-collections-3.2.1.jar
commons-compiler-2.7.6.jar
commons-compress-1.4.1.jar
commons-dbcp-1.4.jar
commons-dbutils-1.6.jar
commons-digester-2.1.jar
commons-fileupload-1.2.jar
commons-httpclient-3.1.jar
commons-io-2.4.jar
commons-jexl-1.1.jar
commons-lang-2.6.jar
commons-lang3-3.2.jar
commons-logging-1.1.1.jar
commons-logging-api-1.1.jar
commons-math-1.0.jar
commons-pool-1.5.4.jar
commons-vfs-1.0.jar
cup-11a-1.0.jar
curator-client-2.6.0.jar
curator-framework-2.6.0.jar
datanucleus-api-jdo-3.2.6.jar
datanucleus-core-3.2.10.jar
datanucleus-rdbms-3.2.9.jar
datasourcesconfig.dtd
derby-10.10.1.1.jar
dom4j-1.6.1.jar
ehcache-1.2.3.jar
eigenbase-properties-1.1.2.jar
eigenbase-properties-1.1.5.jar
eigenbase-resgen-1.3.1.jar
eigenbase-xom-1.3.1.jar
ejb3-persistence-1.0.1.GA.jar
elj-2.1.jar
esapi-2.0GA.jar
ezmorph-1.0.6.jar
FastInfoset-1.2.12.jar
fop-0.20.5.jar
geronimo-annotation_1.0_spec-1.1.1.jar
geronimo-jaspic_1.0_spec-1.0.jar
geronimo-jta_1.1_spec-1.1.1.jar
groovy-all-2.4.4.jar
gson-2.2.4.jar
guava-18.0.jar
hamcrest-core-1.3.jar
hibernate-3.2.1.ga.jar
hibernate-annotations-3.3.1.GA.jar
hibernate-commons-annotations-3.3.0.ga.jar
hibernate-core-3.3.2.GA.jar
hibernate-entitymanager-3.6.7.Final.jar
hibernate-jpa-2.0-api-1.0.1.Final.jar
hibernate-validator-4.3.0.Final.jar
HikariCP-2.4.7.jar
hi-SNAPSHOT-small.jar
hive-common-0.14.0.jar
hive-jdbc-0.14.0.jar
hive-metastore-0.14.0.jar
hive-serde-0.14.0.jar
hive-service-0.14.0.jar
hive-shims-0.14.0.jar
hive-shims-0.20-0.14.0.jar
hive-shims-0.20S-0.14.0.jar
hive-shims-0.23-0.14.0.jar
hive-shims-common-0.14.0.jar
hive-shims-common-secure-0.14.0.jar
httpclient-4.2.5.jar
httpcore-4.2.5.jar
inspektr-audit-1.0.7.GA.jar
inspektr-common-1.0.7.GA.jar
istack-commons-runtime-2.16.jar
itext-2.1.7.jar
jackson-annotations-2.1.1.jar
jackson-annotations-2.1.4.jar
jackson-core-2.1.1.jar
jackson-core-2.1.4.jar
jackson-core-asl-1.9.13.jar
jackson-databind-2.1.1.jar
jackson-databind-2.1.4.jar
jackson-mapper-asl-1.9.13.jar
jakarta-regexp-1.4.jar
janino-2.7.6.jar
Jasper-EFW-Plug-In.jar
jasperreports-5.6.0.jar
jasperreports-htmlcomponent-5.0.1.jar
jaxb-api-2.2.7.jar
jaxb-core-2.2.7.jar
jaxb-impl-2.2.7.jar
jaxen-full-1.0.jar
jboss-logging-3.1.0.CR2.jar
jcip-annotations-1.0.jar
jcl-over-slf4j-1.7.5.jar
jcommon-1.0.15.jar
jdo-api-3.0.1.jar
jdtcore-3.1.0.jar
jersey-core-1.8.jar
jersey-server-1.8.jar
jetty-all-7.6.0.v20120127.jar
jfreechart-1.0.12.jar
jline-0.9.94.jar
joda-time-2.7.jar
jpam-1.1.jar
jpivot-1.8.jar
jsf-api-1.2_04-b07-FCS.jar
json-20090211.jar
json-lib-2.4-jdk15.jar
jsoup-1.7.2.jar
jsr173_api-1.0.jar
jsr305-1.3.9.jar
jstl-1.2.jar
jta-1.1.jar
jul-to-slf4j-1.6.1.jar
junit-4.11.jar
ldaptive-1.0.3.jar
libfb303-0.9.0.jar
libthrift-0.9.0.jar
log4j-1.2.17.jar
log4j-over-slf4j-1.6.1.jar
lucene-analyzers-common-4.5.1.jar
lucene-core-4.5.1.jar
lucene-queries-4.5.1.jar
lucene-queryparser-4.5.1.jar
lucene-sandbox-4.5.1.jar
mail-1.4.7.jar
mockito-all-1.9.5.jar
mondrian-3.5.0.jar
mondrian.dtd
mongo-java-driver-2.14.3.jar
mysql-connector-java-5.1.34.jar
not-yet-commons-ssl-0.3.9.jar
olap4j-1.0.1.539.jar
olap4j-xmla-1.0.1.539.jar
opencsv-1.8.jar
opennlp-tools-1.6.0.jar
opensaml-2.5.1-1.jar
openws-1.4.2-1.jar
paranamer-2.3.jar
pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
perf4j-0.9.16-log4jonly.jar
persistence-api-1.0.jar
person-directory-api-1.5.1.jar
person-directory-impl-1.5.1.jar
pivot4j-core-0.9.jar
poi-3.12.jar
protobuf-java-3.0.0-beta-1.jar
quartz-2.0.2.jar
rhino-1.7.7.1.jar
saaj-api.jar
saaj-ri-1.1.jar
saxpath.jar
servlet-api-2.5.jar
slf4j-api-1.7.7.jar
slf4j-log4j12-1.7.7.jar
snappy-java-1.0.5.jar
spring-aop-3.0.7.RELEASE.jar
spring-asm-3.0.7.RELEASE.jar
spring-beans-3.0.7.RELEASE.jar
spring-binding-2.3.2.RELEASE.jar
spring-context-3.0.7.RELEASE.jar
spring-context-support-3.0.7.RELEASE.jar
spring-core-3.0.7.RELEASE.jar
spring-expression-3.0.7.RELEASE.jar
spring-jdbc-3.0.7.RELEASE.jar
spring-js-2.3.2.RELEASE.jar
spring-js-resources-2.3.2.RELEASE.jar
spring-orm-3.0.7.RELEASE.jar
spring-security-acl-3.1.3.RELEASE.jar
spring-security-cas-3.1.3.RELEASE.jar
spring-security-config-3.1.3.RELEASE.jar
spring-security-core-3.1.3.RELEASE.jar
spring-security-taglibs-3.1.3.RELEASE.jar
spring-security-web-3.1.3.RELEASE.jar
spring-test-3.0.7.RELEASE.jar
spring-tx-3.0.7.RELEASE.jar
spring-web-3.0.7.RELEASE.jar
spring-webflow-2.3.2.RELEASE.jar
spring-webmvc-3.0.7.RELEASE.jar
standard-1.1.2.jar
stringtemplate-3.2.1.jar
tbutils-wcf-1.0.jar
tiles-api-2.1.4.jar
tiles-core-2.1.4.jar
tiles-jsp-2.1.4.jar
tiles-servlet-2.1.4.jar
tomcat-jdbc-7.0.63.jar
tomcat-juli-7.0.63.jar
validation-api-1.0.0.GA.jar
velocity-1.5.jar
wcf-1.1.jar
xalan-2.7.0.jar
xercesImpl-2.8.0.jar
xml-apis-1.3.03.jar
xml-resolver-1.2.jar
xmlsec-1.4.4.jar
xmltooling-1.3.2-1.jar
xom-1.2.5.jar
xz-1.0.jar
zip4j-1.3.2.jar
zookeeper-3.4.5.jar
Please download JAR files from below link, we had used them while testing Hive 0.13 and 0.14 with Helical Insight 1.0.1.0.
http://central.maven.org/maven2/org/apache/hadoop/hadoop-core/1.0.1/hadoop-core-1.0.1.jar
http://central.maven.org/maven2/org/apache/hadoop/hadoop-common/2.8.0/hadoop-common-2.8.0.jar
http://central.maven.org/maven2/org/apache/hive/hive-exec/0.8.1/hive-exec-0.8.1.jar
Also download Jar files.zip (425.6 KB) file, extract it.
all of these files (i.e. from the weblinks and zip provided) should be extracted and should be placed in the WEB-INF/lib followed by tomcat restart
Please save these jar files in the WEB-INF/lib folder and then restart tomcat. Let us know if this works.