CODEWITHSUNDEEP
postgresqlpentahopentaho-spoonpentaho-data-integration
Andrey
Andrey

Reputation: 1759

Pentaho select UUID type fild as UUID and Insert into other table as UUID

I am new to Pentaho, my research end up with nothing I have a table that has filed with type UUID I need to copy it to another table where the field has the same UUID. Table input. has this SQL enter image description here

I am casting field to UUI filed specifically. however when I check input fields on the output table it shows as string, how do I cast it to uuid.

enter image description here

Also the same for the output table, it was created with datatype UUID for that field

enter image description here

output table shows datatype as the string

enter image description here

On the run, it throws an error clearly showing that it cannot convert it to UUID

2022/02/11 10:42:45 - Table output.0 - Caused by: org.postgresql.util.PSQLException: ERROR: column "qr_uuid" is of type uuid but expression is of type character varying

I am using Postgres 13 and Pentaho 9

Upvotes: 2

Views: 1246

Answers (1)

Ana GH
Ana GH

Reputation: 1710

I have found an old thread dealing with the same problem, and there are some hints for the answer. You'll need to edit the database connection for postgres, and in the Options menu add Parameter stringtype with Value unspecified:

How insert UUID values in PostgreSQL table via Kettle?

Upvotes: 5

Related Questions