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

Need Assistance setting proxy settings for Java (JVM Launcher)

I am a beginner in Java programming and I did a lot of research but still need assistance. I am trying to add proxy settings to my JVM Launcher but I do not know how to do this. I have read responses to other questions stating it can be done in the…
user10471443
  • 27
  • 8
0
votes
1 answer

MySQL -Pentaho Error getting views from schema [null]

when trying to run Insert/Update or LookUp functions in Pentaho to get my SQL tables it shows me this error, anyone knows, how can I fix it? Error getting views from schema [null] You have an error in your SQL syntax; check the manual that…
Carlos Franco
  • 1
  • 1
0
votes
1 answer

Use java 8 features (newer janino version) in pentaho data integration

Pentaho Data Integration 8.0.x is using Janino 2.5.16, released in 2010 for compiling the User Defined Java Class step. There is a JIRA in pentaho for updating this to use a newer Janino version which would bring new java 8 related features in…
KCK
  • 2,015
  • 2
  • 17
  • 35
0
votes
1 answer

Pentaho Reporting Ouput component using PDI is giving an error

I'm trying to generate a pdf file using PDI by passing the parameter to prpt using pentaho reporting output component. However when I try to run the transformation it giving an error as below. Please help me out in this. 2018/09/25 13:48:01 -…
Ram
  • 25
  • 2
  • 8
0
votes
1 answer

Pentaho v8.1 + Hadoop v2.7.4 : problem connecting to Hadoop from Pentaho PDI

I am having difficulties trying to get Pentaho PDI to access Hadoop. I did some research and found that Pentaho uses Adapters called Shims, I see these as connectors to Hadoop, the way that JDBC drivers are in Java world for database…
Palu
  • 668
  • 3
  • 11
  • 26
0
votes
0 answers

Divided column by 10^n

I would like to create new column in my transformation From JSON I receive let's say two colums (instrument, price) but the price is in integer value (for example: 1.24124 -> 124124). From the table input I get instrument and decimal places, so I…
ltrd
  • 326
  • 1
  • 8
0
votes
2 answers

Unable to read the data from Excel file input

I was unable to read the Excel file from my pentaho ETL server repository. I get this error: unable to recognize OLE stream What does that error mean?
aditya goud
  • 15
  • 6
0
votes
0 answers

Creating table with DISTSTYLE ALL in Pentaho Data Integration throws error on compatibility over DISTKEY

Amazon Invalid operation: DISTSTYLE EVEN/ALL/NONE is not compatible with a DISTKEY; ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Error initializing step ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from…
Sachin Chauhan
  • 356
  • 1
  • 11
0
votes
2 answers

Execute pentaho job completely for first row before starting job for second row

My root job which has two steps, Transformation Executor(to copy rows to results) & a Job Executor(Executing for each input row) what I want is, that my sub-job should execute completely for first incoming row before it start execution for second…
Pawan Laad
  • 3
  • 1
0
votes
1 answer

Losing decimal places in database lookup step

I have a database lookup step that is retrieving 3 fields from a SQL Server table. One of the fields is a decimal (8,6). When retrieved, the field values appear to be integers, losing all decimal places. I have spent several hours trying to resolve…
Nithyanandam G
  • 61
  • 1
  • 2
  • 6
0
votes
1 answer

Outgoing fields not showing in pentaho plugin

I have created a step plugin for pentaho which gives some output fields. It gets 2 Input fields from previous steps add some metadata and output fields . Although output is being sent to next step but when i do right click and click on output fields…
prab2112
  • 1,024
  • 10
  • 36
0
votes
1 answer

Pentaho - Formatting date in Mondrian

I am getting date like 20150910 numeric from backend. I am creating new level in Dimension (in Mondrian-template) Is there any way to format the date to 2015-09-10 ? Can i achieve this using formatString ? Any pointers will be highly appreciated .…
lesnar
  • 2,400
  • 7
  • 41
  • 72
0
votes
3 answers

Pentaho running script from outside spoon directory

I have a shell script that should run the pentaho transforamtion job but it fails with the following error: /data/data-integration/spoon.sh: 1: /data/data-integration/spoon.sh: ldconfig: not found Here's the shell script which sits…
Adrian Chrostowski
  • 424
  • 9
  • 30
0
votes
1 answer

Transform PDI response to determined structure

I'm new to PDI I'm working recovering information from an API and I need to transform the information that comes to a certain structure and I'm not clear how to do it with the concatenation or with another transformation. This is my answer to work…
Manolait
  • 353
  • 2
  • 11
0
votes
0 answers

Issues with cast/convert datetime/timestamp to date

I have troubles when I try to cast or convert DateTime/timestamp to date. The source is a SQL Server and the SQL I use is CONVERT(date,[the_column]) AS [the_column] or the other SQL is CAST([the_column] AS DATE) AS [the_column]. No matter which one…
Veronika Florova
  • 15
  • 4
1 2 3
…
55 56