Stack Overflow
Stack Overflow

Questions tagged [pentaho-spoon]

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Documentation: http://wiki.pentaho.com/display/EAI/Spoon%2BUser%2BGuide

828 questions
0
votes
1 answer

can't Edit and create new transformation in pentaho data integration

I am new to Pentaho and facing an issue when editing or creating new transformation in spoon. Below are the details of problem. java.lang.NullPointerException at…
faisal
  • 21
  • 1
  • 5
0
votes
0 answers

querying Virtuoso RDF from Pentaho (Kettle)

I'm trying querying a Virtuoso (RDF-store) graph from Pentaho. I do it with pentaho-step "Execute SQL script" (with this pentaho step I do insertions in the same RDF-graph) in this way, I get launch execution but I get a columns of 0's in the…
Sergio
  • 81
  • 9
0
votes
1 answer

How should I control the duplication of calculation version using Pentaho?

I have a table result_slalom where data is populated via ETL Jobs of Pentaho. When ETL runs for the first time it creates version-1. Now, if data is changed after new calculations it becomes version-2. I need to make changes only in the…
Pranjal Kaushik
  • 13
  • 1
  • 10
0
votes
1 answer

Insert Update/Merge/Dimension Lookup/ Update using Pentaho

There is a table 'TICKETS' in PostgreSQL.I perform an ETL job using Pentaho to populate this table. There is also a GUI on which a user makes changes and the result is reflected in this table. The fields in the table are : "OID" Char(36) <------…
Pranjal Kaushik
  • 13
  • 1
  • 10
0
votes
2 answers

Pentaho DI Connection driver issues

I'm having issues adding a MSSQL SERVER connection to Pentaho Data Intergration. I tried the following: I have downloaded the latest jdbc drivers (sqljdbc42) and moved them to the lib folder I have created a new user in SQL SERVER and gave it all…
Claire
  • 475
  • 1
  • 8
  • 21
0
votes
1 answer

How to get all results from results set in pentaho kettle step Input table?

I have simple transformation consisting of 2 steps. 1 step (Input table) makes query to DB and 2 step (Java class) processes results. 2 step takes much time (it is normal in my case) but after 1 hours I get error of closed results set Server has…
palandlom
  • 529
  • 6
  • 17
0
votes
1 answer

Regular expression to include files in multiple folders

I have multiple folders (4000+) with files included in every folder. What is the Regular expression to select the files in all the folders in Pentaho "Get a file with SFTP" step.
Allen BMC
  • 27
  • 1
  • 1
  • 5
0
votes
2 answers

Pentaho "Return value id can't be found in the input row"

I have a pentaho transformation, which is used to read a text file, to check some conditions( from which you can have errors, such as the number should be a positive number). From this errors I'm creating an excel file and I need for my job the…
Silvia Petrova
  • 59
  • 1
  • 7
0
votes
2 answers

Pentaho Generating report and scheduling mail job with attachment

I am very new in Pentaho. can anyone guide me how to create report in PDF file and sending over mail as attachment on schedule basis using PDI .Any tutorial or demo will help
Dhrumil Shah
  • 2,128
  • 5
  • 23
  • 37
0
votes
1 answer

Unable to write checkpoint information to logging table

All my jobs running in the repository is failing with the below error 2017/09/22 06:18:52 - job_load - Unable to write checkpoint information to logging table 2017/09/22 06:18:52 - job_load - 2017/09/22 06:18:52 - job_load - Couldn't execute SQL:…
Srini V
  • 11,045
  • 14
  • 66
  • 89
0
votes
1 answer

Spark Submit giving error in Pentaho Spoon

I am new to Pentaho.I am using MAPR distribution,When i am submitting a spark job,i am getting the below error.Please help me on this.I have done the necessary configuration for the integration of spark and pentaho.Please find the attached…
Khumar
  • 316
  • 3
  • 22
0
votes
0 answers

Job is not failing in pentaho which i read it through VFS when the file is not available in S3

i have a job in pentaho which read the data from S3 through virtual file system. So the extracted data from source is not regular as its a adhoc basis. Ideally i had to write a loop condition from today's date to the date which matches in S3. When…
praveen kumar mallajosyula
  • 11
  • 3
0
votes
1 answer

why this if else statement not working - kettle javascript

I am using this java script in my kettle spoon ETL workflow. But always only the if statement is working, else if is not working, whats wrong with this? var type1 = ''; var type2 = ''; var category1 = [1, 2, 3, 4, 5, 6, 7, 8, 50, 53]; var category2…
ds_user
  • 2,139
  • 4
  • 36
  • 71
0
votes
3 answers

Make a DB INSERT based on Text File Input metadata

I'm developing an ETL and must do some routines for monitoring it. At the begining, I must make in INSERT on DB to create a record informing the filename and starting process datetime. This query will return the record's PK and it must be stored.…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
2 answers

Continue stream based on result of a DB query

I'm developing an ETL. The first step is a Text File Input, that adds to the stream some metadata from "Additional output fields", including filename and last modified. I must make a query to DB verifying if that filename with that last modified…
Hikari
  • 3,797
  • 12
  • 47
  • 77
1 2 3
…
55 56