Getting test result: core-site-xml has no configuration entered. My Hadoop cluster's namenode FQDN:cloud106.scisvlab.local. Also, why hop has It is my first project and pentaho docs are very contradicting.
Any MongoDB aggregation Query using the MongoDB Input node is broken if the query runs against the (latest) 3.6 version of MongoDB. The usage of cursors is now a requirement in aggregation pipelines and this is implemented in the latest 3.6 MongoDB Java drivers. Here's the current stacktrace if someone tries to use the included (old, 3.2.2)…(Show moreShow less)
Specifically - PDI 8.0 CE using PostgreSQL and driver version 42.2.2, I need to specify the option of `stringtype=unspecified`. This is used to avoid casting issues from varchar to uuid. Related background: ERROR: column "guid" is of type uuid but expression is of type character varying If I switch from JNDI to JDBC in my connection type…(Show moreShow less)
Hello, I'm not sure if this is the right place for this I am trying to connect to a Rest API through Pentaho Data Integration. Using API Tester I can connect and get a proper response body quite easily so I know it works, but I can't for the life of me get it to work in Pentaho. I keep getting a "Error finding field [Authorization] in incoming…(Show moreShow less)
Hi All, I experience the same problem, trying to retrieve JSON data via REST API for pm.com: Get All Projects · ProjectManager.com Developer Center I'm passing the field Authorization from the "Generate Rows" step: tried to name the parameter "header" or "headers", tried to pass the value with single quotes, but still, it doesn't…
How do you return a ResultSet from a SQL Server stored procedure with multiple parameters? I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter.
Hello! I want to take only a part of .txt, its possible? For example, i want just the three lines in the image: Remember that in .txt the lines will not always be in the same position. Someone can help? Thanks!
I'm trying to use spoon for some data transformations. The imput file I need to work on is a complex xml file with multiple nodes that have multiple child nodes. The first step of the process I want to do is to just map it into a 2d table. For example: <product> <id>1</id> <name>car</name> <attributes> <attribute>…(Show moreShow less)
If you have control of the XML, you should make a change to help standardize your data. <product> <id>1</id> <name>car</name> <attributes> <attribute> <id>1</id> <value> <language>eng</language> <name>speed</name> …
Hello! I'm trying to get a daily email with attachment, but the email attachment comes in mime type. Does anyone know if pentaho does not interpret the mime type attachment? In this case, the step does not return any attachments, even if there is one. --> This is how the attachment looks in webmail. --> his is how the attachment looks…(Show moreShow less)
Diego Mainou, Right, Now I'm trying to do the following: 1. I brought the body of the email (with the attached encoded). 2. How to get only the part of the attachment? (I'm doing it manually) 3. After just picking up the text from the attachment, use step text input -> Java Script 3. How to turn it into .csv? So far, I've managed to convert…