Impala with Pentaho 5.0.1 - Issue

[PM]

I have downloaded a Free 30-day Trial of Pentaho(Pentaho Business Analytics) and installed in my linux system. I have created one analyzer report in Pentaho User Console[Pentaho BI Server] using Impala as data source[retrieving records by joining two tables].

 

The report is worked just fine. After couples of hours when I tried to modify the report, I am getting following error: failed (java.sql.SQLException: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response), but I was able connect to Impala and query data from Impala shell. 

After 3 to 4 hours when I launch the report, I am getting following error. Error stack trace is mentioned below,

I could not find why connection being lost everytime. Is it any configuration I have to do it in Impala or Pentaho BI server.

It will be helpful if somebody shares some inputs.

Error stack trace: 

failed (java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe)

2013-12-19 13:07:19,089 ERROR [com.pentaho.analyzer.b.c] Ticket Number: 1387438639089

2013-12-19 13:07:19,090 ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler.

java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe

at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:213)

at com.pentaho.analyzer.content.controller.j.a(SourceFile:170)

at com.pentaho.analyzer.content.controller.b.b(SourceFile:189)

at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:123)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:229)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:156)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:58)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:37)

at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306)

at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)

at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)

at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)

at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)

at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:111)

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

at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:116)

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

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

at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:161)

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

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

at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83)

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

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

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

at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

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

at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

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

at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

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

at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)

at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:88)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

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

at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

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

at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265)

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

at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

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

at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)

at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)

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

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

at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72)

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

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

at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)

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

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

at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66)

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

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

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Unknown Source)

Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe

at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

at java.util.concurrent.FutureTask.get(Unknown Source)

at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:171)

... 71 more

Caused by: java.lang.RuntimeException: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe

at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:288)

at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:296)

at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:120)

at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:92)

at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:274)

at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:267)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

... 1 more

Caused by: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe

at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:187)

at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:246)

at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:449)

at com.sun.proxy.$Proxy138.executeQuery(Unknown Source)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

at mondrian.rolap.SqlStatement.execute(SqlStatement.java:201)

at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:335)

at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:395)

at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:560)

at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:250)

at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:190)

at mondrian.olap.fun.NonEmptyCrossJoinFunDef$1.evaluateList(NonEmptyCrossJoinFunDef.java:80)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.calc.impl.IterableListCalc.evaluateList(IterableListCalc.java:37)

at mondrian.rolap.sql.CrossJoinArgFactory.expandNonNative(CrossJoinArgFactory.java:910)

at mondrian.rolap.sql.CrossJoinArgFactory.checkCrossJoin(CrossJoinArgFactory.java:341)

at mondrian.rolap.RolapNativeCrossJoin.createEvaluator(RolapNativeCrossJoin.java:105)

at mondrian.rolap.RolapNativeRegistry.createEvaluator(RolapNativeRegistry.java:56)

at mondrian.rolap.RolapSchemaReader.getNativeSetEvaluator(RolapSchemaReader.java:681)

at mondrian.olap.DelegatingSchemaReader.getNativeSetEvaluator(DelegatingSchemaReader.java:269)

at mondrian.olap.fun.CrossJoinFunDef$CrossJoinIterCalc.evaluateIterable(CrossJoinFunDef.java:173)

at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)

at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)

at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)

at mondrian.rolap.RolapResult.<init>(RolapResult.java:288)

at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)

at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)

... 5 more