848 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-2
votes
1
answer
72
views
How do I clear the cache in Pentaho Data Integration? [closed]
How do you clear the cache for Pentaho in a Linux environment? Is there a particular file I need to delete somewhere?
0
votes
1
answer
175
views
Pentaho Unable to get database metadata from this database connection
We are using Pentaho 9.3.
Pentaho will work fine, but occasionally we will get an error message "Error connection to database [database_name]. Unable to get database metadata from this database ...
1
vote
0
answers
50
views
Pentaho PDI 9.3 Can't connect after upgrade aws aurora mysql
After updating the database to a new version of Aurora MySQL on AWS, one of the steps no longer executes, and the log displays the following message:
Connection failed. Verify all connection ...
-1
votes
1
answer
73
views
Pentaho Kettle Database Join Alias problem
I am using kettle version 9.4 and migrating some jobs from 5.0,
i have an issue with step Database Join, in which i write a simple query that retrieves a column as alias, example:
select u.user_id as ...
0
votes
1
answer
121
views
Is Execute SQL script a preferable way to run PL/SQL?
I'm practicing Pentaho Spoon and I have 2 queries that use PL/SQL. The first query joins multiple tables in my Oracle database to calculate a value, then insert the value into a table in the database. ...
0
votes
1
answer
76
views
Setting a variable in Penatho DI that changes if a file is processed
I am working on a Pentaho job that takes processes and deletes files from an email account and then places the data in a database. The job then loops back to check if there are additional files.
The ...
0
votes
1
answer
74
views
How can I import data from several sources to a single output file with Pentaho?
I have a transformation process that gets data from several data sources and joins them into a single CSV output.
This process is a raw job that removes the previous information and loads the data ...
-1
votes
1
answer
37
views
How to separate lines with a repeated identifier from lines with a non-repeated identifier?
I would like to generate two outputs in Pentaho. One output with lines where the CPF is unique and another output as lines where the CPF is repeated. Initially I used the "Data grid" and &...
1
vote
1
answer
97
views
Pentaho: How to dynamically modify rows?
I have a table with population counts over the last 25 years approximately. Of different towns and cities. I also have a table with additional data about most of each of those cities, so I performed a ...
1
vote
2
answers
139
views
Read csv and get table data and write as text file output
I have a csv file which has the below mentioned data of Table names in a sql server instance in ubuntu.
Tables
TableName1
TableName2
TableName3
.
.
.
I want to read this csv file and I want to get ...
1
vote
0
answers
130
views
How to read an excel file with dynamic column name in Pentaho data integration?
I am new in Pentaho data Integration and I have a request to ingest and excel file with dynamic columns names. The columns names will be added or be deleted every month. We will need to load the data ...
0
votes
0
answers
510
views
Pentaho Data Integration (PDI) Jobs Failing After Upgrading to OpenJDK 11 on CentOS VM
I recently upgraded my Java version from 8 to 11 (openjdk 11.0.22 2024年01月16日 LTS
) on a CentOS virtual machine where I run Pentaho Data Integration (PDI) jobs. According to documentation, PDI 9.3 ...
0
votes
1
answer
178
views
How to write a blob file to local filesystem using PDI?
I have a transformation where I read in a raw application/octet-stream into a stream field using a RESTClient step, which is working correctly. Now, I would like to write the (*.jpg) file to the ...
0
votes
0
answers
67
views
Json is sending Überlegung character convert in pentaho different format
Json is sending Überlegung character convert in pentaho different format.
Json is sending the value ä
but Pentoho is converting and storing character like this ä
I want to store the data like this ä
0
votes
0
answers
147
views
Amazon S3 multi part upload error using Pentaho 9.3
I am trying to upload multiple GZip files to Amazon S3 using Pentaho 9.3. I have also set the part size to maximum in the kettle property but am still facing the S3 multi-part error. Reference for ...