Uanble to create connection to Hadoop-Hive from JasperReport Server

shreecs · December 30, 2013

Hi,

I'm using JasperReport Server 5.5 enterprise evaluation edition on windows 64bit machine. When i select "Hadoop-Hive Data Source" in JasperReport server it says connection failed.When i checked the log it says ERROR DataSourceAction,http-apr-8080-exec-7:455 - exception testing custom data source
net.sf.jasperreports.engine.JRException: java.net.ConnectException: Connection refused .

Is it because of any hadoop or hive jars?

I'm using Apache Hadoop 1.1.1 and Apache Hive o.9.0 .Here in jasperReport server latest hive jar is used instead of hive0.9.0. Is it due to incompatibility of the hive jdbc jar?

Please suggest the solution.

Thanks in advance

ShreeCS

marianol · December 30, 2013

This may well be a driver issue (jar versions) as you suggested but the hive 0.10 jar should work fine. I assume that the problem may be with the thrift protocol. You can try adding libthrift-0.9.0.jar and hive-serde-0.11.0.jar to Jasper's /WEB-INF/libs and restarting the server.

shreecs · December 31, 2013

Hi Marianol,

As you suggested i have added the libthrift-0.9.0.jar and hive-serde-0.11.0.jar to Jasper's /WEB-INF/libs and restarted the server but still the same problem exists.Not able to connect to Hadoop-Hive data source.What would be the problem?

shreecs · December 31, 2013

Hi,

Below is the jasperserver log created when i was trying to connect to Hadoop-Hive data source:

2013-12-31 12:03:38,415 ERROR HiveDataSourceService,http-apr-8080-exec-5:83 - net.sf.jasperreports.engine.JRException: java.net.ConnectException: Connection refused: connect

2013-12-31 12:03:38,419 ERROR DataSourceAction,http-apr-8080-exec-5:455 - exception testing custom data source

net.sf.jasperreports.engine.JRException: java.net.ConnectException: Connection refused: connect

at com.jaspersoft.hadoop.hive.jasperserver.HiveDataSourceService.createConnection(HiveDataSourceService.java:84)

at com.jaspersoft.hadoop.hive.jasperserver.HiveDataSourceService.testConnection(HiveDataSourceService.java:107)

at com.jaspersoft.jasperserver.war.action.DataSourceAction.testCustomDataSource(DataSourceAction.java:451)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)

at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)

at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)

at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)

at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101)

at org.springframework.webflow.engine.State.enter(State.java:194)

at org.springframework.webflow.engine.Transition.execute(Transition.java:227)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393)

at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)

at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)

at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388)

at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)

at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232)

at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)

at org.springframework.webflow.engine.Flow.resume(Flow.java:545)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261)

at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy154.resumeExecution(Unknown Source)

at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)

at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:137)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)

at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)