Pentaho Business Analytics 4.8 and PDI 4.4 are ready


Yesterday, appart from election day pentaho announced the release of the new version of its Business Analytics suite. The new version is 4.8 includes great additions like Mobile, Instaview and many other feature enhancements in the Pentaho Business Analytics Suite 4.8.

Pentaho 48 Overview

Image

Mobile

Instaview

Image

Download Pentaho Data Integration 4.4

A new deployment of Kettle was also released, hurry up it is time to get it and try it, the download it from here: www.pentaho.com/download (Enterprise Edition) and coming soon on Sourceforce (PDI Community Edition).

Image

New PDI features

Pentaho Instaview

Pentaho Instaview is the fastest way to start using Pentaho Data Integration to analyze and visualize data. Instaview uses templates to manage the complexities of data access and preparation. You can focus on selecting and filtering the data you want to explore, rather than spending time creating source connections and identifying measure and dimension fields. Once the data has been selected, Instaview automatically generates transformation and metadata models, executes them, and launches Pentaho Analyzer. This allows you to explore your data in the Analyzer desktop user interface.
As your data requirements become more advanced, you have the ability to create your own templates and use the full power of Pentaho Data Integration (PDI).
Watch this video and see the Getting Started with Pentaho Data Integration Instaview Guide to understand and learn more about Pentaho Instaview or

PDI Operations Mart

The PDI Operations Mart enables administrators to collect and query PDI log data into one centralized data mart for easy reporting and analysis. The operations mart has predefined samples for Pentaho Analyzer, Interactive Reporting, and Dashboards. You can create individualized reports to meet your specific needs.

Sample inquiries include

  • How many jobs or transformations have been successful compared to how many failed in a given period?
  • How many jobs or transformations are currently running?
  • What are the longest running jobs or transformations in a given period?
  • What is the highest failure rate of job or transformations in a given period?
  • How many rows have been processed in a particular time period? This enables you to see a trend of rows or time in time series for selected transformations.

The operations mart provides setup procedures for MySQL, Oracle, and PostgresSQL databases. Install instructions for the PDI Operations Mart are available in the Pentaho InfoCenter.

Concat Fields Step

The Concat Fields step is used to join multiple fields into one target field. The fields can be delimited by a separator and the enclosure logic is completely compatible with the Text File Output step.

This step is very useful for joining fields as key/value pairs for the Hadoop MapReduce Output step.

EDI to XML Step

The EDI to XML step converts EDI message text, which conforms to the ISO 9735 standard, to generic XML. The XML text is more accessible and enables selective data extraction using XPath and the Get Data From XML step.

SAS Input Step

The SAS Input step reads files in sas7bdat format created by SAS software. This step allows PDI developers to import files in sas7bdat format.

 

Advertisements

3 thoughts on “Pentaho Business Analytics 4.8 and PDI 4.4 are ready

  1. Hi !! thanks for you posts! are very usefull! I’m working with Pentaho Business Analytics platform but i’m limited by the free trial version of 30 days. How can i get a full version? Thanks!

  2. 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.(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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s