• formatting the data

     need to tag my data to the codes. how can i tag the issuer codes to the rows.  issuer code output is in    I need the data in the below format . Issuer codes are not always the same. they can kee...
  • Kafka consumer using a registry schema?

    Are there any examples how you can use the "kafka consumer" to decode a binary AVRO message send to a kafka topic? I can access connect to the topic, get the messages, but how do I convert the binary message data...
    Ramon Ankersmit
    created by Ramon Ankersmit
  • 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
  • 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 ...
    girish athanikar
    last modified by girish athanikar
  • DI Server , what features are specific to it?

    When we say Pentaho DI server (other than Carte server) what are the specific features we are talking about? what is the best practice for setting it up in a separate server (node) other than the PBA portion?
    Arul Mani
    last modified by Arul Mani
  • Where I can get detailed demonstration videos on each Step? Do Pentaho provide tutorial kind of videos which describes each functionality in steps so that one can get aware of all the things quickly and start working on the project. If any one have answer

    Where I can get detailed demonstration videos on each Step? Do Pentaho provide tutorial kind of videos which describes each functionality in steps so that one can get aware of all the things quickly and start working ...
    Rajan Kshirsagar
    last modified by Rajan Kshirsagar
  • Python executor missing libraries

    Hello there,    I want to use a Python executor script to run a cleaning algorithm in my ETL process. I already installed anaconda and all the libraries I need on my virtual machine running Linux but Pentah...
    Victorien DELANGUE
    last modified by Victorien DELANGUE
  • How to transform the text file into xml file in kTR

    How to transform the below text file into xml file in kTR  <?xml version="1.0" encoding="UTF-8"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:auth.072.001.01"> <hello> <greeting> he...
    archana garikapati
    last modified by archana garikapati
  • When I click on "Explore" database, it gives me below error. Mysql connectors are up to date.   Unable to retrieve database information because of an error  Error getting views from schema [null] You have an error in your SQL syntax; check the manual that

    I am using MYSQL 8.0 version. When I click on "Explore" database in pentaho, it gives me below error.   1. Mysql connectors are up to date.    2.Single table "Select" query runs proper and shows data ...
    Rajan Kshirsagar
    last modified by Rajan Kshirsagar
  • Dynamic Carte cluster setup in Nomad/K8s

    Hi all, I would like to setup a dynamic Carte cluster in a container scheduler system. For this, I managed to create my own Docker image similar to the one described in Diethard Steiner On Business Intelligence. I am...
    Steffen Mueller
    last modified by Steffen Mueller
  • Spoon can connect to hive, but kitchen/pan cannot

    kitchen connect to hive have problem; Context: prd-ce-8.1.0.0-365, connecting to a HDP hive instance, linux, file repository.   if I delete file data-integration/system/karaf/caches run ./kitchen.sh -file=/ho...
    gua xi
    last modified by gua xi
  • Sort component doesnt sort properly on the data

    i am using the sort component to sort my data - 1, 3,4,7,2,6,5,8,10,9. It does in the below order. please suggest    1 10 2 3 4 5 6 7 8 9
    archana garikapati
    last modified by archana garikapati
  • BigQuery plugin disappeared

    Hi guys, I was giving a try at Matt's kettle beam plugin following Diethard superb blog post: http://diethardsteiner.github.io/pdi/streaming/2018/12/01/Kettle-Beam.html but something strange happened. Probl...
    Virgilio Pierini
    last modified by Virgilio Pierini
  • 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
  • 4K display PDI scaling issues

    Hi,   I'm using PDI on windows 10 with a 4k screen. Everything is ok when opening workflows but when I try to inspect data and open visualization, everything become very small. It seems that DPI scaling doesn't ...
    Stefano Mancino
    created by Stefano Mancino
  • Kettle Beam on Dialogflow

    Hi, has anybody experienced this error when trying to run a transformation on beam/dialogflow?   java.lang.RuntimeException: Failed to create a workflow job: (b7b4bb91eba42106): The workflow could not be create...
  • Hi

    Hi, can anyone share the free e cookbook or free tutorial site to explore pentaho 7.1.. Thanks.
    Kiran Pemmasani
    last modified by Kiran Pemmasani
  • CSV Input Step issue

    Hello. I'm using Spoon on windows. When I use the CSV input step in any Spoon transformation, the file it uses will be locked and I can't delete it or move it until I close Spoon. I'll get an error "The action cannot ...
    Ken Aguilar
    last modified by Ken Aguilar
  • vertica

    Hi    We are trying to setup a enterprise data warehouse and have business need to copy data from hundreds of tables(selective)  from OLTP application into staging area for data warehouse. is there an ...
    C247B0UH
    last modified by C247B0UH
  • How can I use the 'curl' command to get the right response of carte server of PDI?

    When I startup a carte server like this : ./carte.sh pwd/carte-config-master-8080.xml then I can only get response with the following link curl -u cluster:cluster http://localhost:8080 ...
    Ze He
    last modified by Ze He