• Automate sequences for every day

    Program a transformation that takes place every day without me having to activate it or do anything.   I'm creating different files through a database query but I want everything to be done automatically.  ...
    Juan Rodriguez
    last modified by Juan Rodriguez
  • Pentaho kettle convert date to unix

    I'm trying to pacha a string format dated "2019-05-14 13:30:00" to a UNIX format. In javascript I got it but in the javascript kettle module I am not able to return the numeric value 1557833442 the line...
    Manuel b munoz
    last modified by Manuel b munoz
  • Pentaho Community edition vs EE

    Hi All,   I wanted to know comparison between Pentaho Community edition and Enterprise edition? How can we get support for community edition from Pentaho team?
    Bharti Das
    last modified by Bharti Das
  • Pentaho 5.x Support

    Hi All, We are using Pentaho 5.x. May I know how to get support for this product in case of any issues? What is the process to get support as we know that this is CE version and no longer supported. Can we get help...
    Bharti Das
    last modified by Bharti Das
  • Loading a fact table from operational database

    Hello there, I know there is a lot of stuff about loading a fact table here but I don't really find answers that fit my needs. I have created a data warehouse on PostgreSQL with dimension tables already populated and ...
    Victorien DELANGUE
    last modified by Victorien DELANGUE
  • Data Explorer not available in Spoon?

    What steps or config are required to enable Data Explorer in PDI / Spoon? i.e., to inspect data. I'm running PDI 8.2.
    last modified by C324K41S
  • Failure to find org.apache.xbean:xbean:jar:2.5 in https://nexus.pentaho.org/content/groups/omni/

    Hi, I have a problem with using the FastJsonInput Step, I got the following error , any clues plz ? : [ERROR] Failed to execute goal on project FastJsonInput: Could not resolve dependencies for project com.trail2...
    Safouan ES-SEBBAR
    last modified by Safouan ES-SEBBAR
  • Streaming data from 2 diff data structures

    Marketplace has an add-in called 'PDI Stream Schema Merge' which "Merges the schema among multiple streams. Leaves fields blank where they don't exist in the source schema."   I have tested this with a simple 2 ...
    Rene Desaulniers
    last modified by Rene Desaulniers
  • Kafka consumer  java.lang.OutOfMemoryError: GC overhead limit exceeded

    We are trying for to run a Kafka consumer transformation in Pentaho Server 8.1. The transformation subscribes to a single topic that sends  500 messages per second. But after running a few hours (18 hours), the t...
    last modified by RAKOTONDRASOA Andry
  • Selecting rows from a csv file based on values in another csv file

    Hi all,   I have two CSV files 1. A big list of social media posts which contain the email ID of the poster, and other data 2. A list of unique people with name, email etc   What I would like to do is se...
    Matthew Hardman
    created by Matthew Hardman
  • Need clarification on Pan and Kitchen

    Hi Team, I am able to run transformation job using AEL (Spark Engine) in PDI client. So my question is, How to run Pan and Kitchen using AEL (Spark Engine).?
    girish athanikar
    last modified by girish athanikar
  • Error (Access Denied)

    Hey everyone. I am getting an error in a job I set up a few months ago and I can't seem to solve it. Here is the video (it's attached to the post) for more information if that is more helpful for you; basically, the p...
    Nathan Mahler
    created by Nathan Mahler
  • Kafka Consumer semantic in PDI 8.1

    Hi all I'm interested in setting up different semantics when retrieving data from Kafka with PDI: at most once, at least once, exactly once. I read [PDI-17272] Implement explicit commit in Kafka Consumer - Pentaho Pl...
    Virgilio Pierini
    last modified by Virgilio Pierini
  • Spark AEL Engine

    Hi Team,   I need some clarification regarding spark AEL engine which I am using to execute .ktr(transformation) through Web-Spoon.   Basically only a .ktr(transformation) can be executed through spark. I ...
  • PMI plugin Python error

    I have recently downloaded the PMI plugin and struggling running the examples, specifically build-model.ktr. I keep on getting error on the Gradient Booster (Python) node. I have uninstalled and re-installed both Pyth...
    Marilyn Singh
    last modified by Marilyn Singh
  • How to abort streaming Kafka Consumer

    Pentaho Data Integration CE I'm using the Kafka Consumer step in PDI v8.2. Since this step runs continuously, documentation suggests using an Abort step to stop the process periodically. I'm looking for some suggestio...
    Brad Gatewood
    last modified by Brad Gatewood
  • Clarification on XSD Validator Step

    Hi Team, Issue with xsd validator step in PDI version 8.2. -> xsd validator step is not taking hdfs location as input for xsd,when we pass hdfs location as input it is automatically taking local path of tomcat ...
  • Variable passing in switch case

    I m new to pentaho,I m reading a text file and it has record which contain header as date and file name. FIle format is something as H22042019EMP asalsakslaks asasasasas   header is 22042019EMP and then de...
    Pradeep Jha
    last modified by Pradeep Jha
  • Unable to find table name field[null] in input row

    I am working on the below and running into the error - Unable to find table name field[null] in input row. Please assist   https://help.pentaho.com/Documentation/8.2/Setup/Evaluation/Tutorials/0C0/020
    archana garikapati
    last modified by archana garikapati
  • Is it possible to extract data from multiple table and load different tables in one transformation.

    Hi, Is it possible to extract data from multiple table and load different tables in one transformation. i.e Table A , Table B, Table C from Source A (Oracle DB) and load into Table X, Table Y & Table Z into Sourc...