My Kettle Transformation looks simple. "Table Input --> Table output". In table input block: simple SQL statement which works fine on server.
When i'm trying to insert UUID value to PostgreSQL table via Kettle i have error:
ERROR: column "UUID_Col1" is of type uuid but expression is of type character varying
I found this solution. But then i faced another problem. Looks like parmeter "stringtype=unspecified" work only for first column. After setting parameter error:
ERROR: column "UUID_Col2" is of type uuid but expression is of type character varying
Table looks like:
"Date" TIMESTAMP WITHOUT TIME ZONE
,"CharNum" VARCHAR(10)
,"UUID_Col1" UUID
,"ЦентрПрибыли" VARCHAR(80)
,"UUID_Col2" UUID
,"UUID_Col3" UUID
,"VarcharCol1" VARCHAR(100)
,"VarcharCol2" VARCHAR(100)
(old thread but putting this here just because it is a top google result for this problema)
using this solution http://forums.pentaho.com/showthread.php?133546-ERROR-column-quot-guid-quot-is-of-type-uuid-but-expression-is-of-type-character-varying fixed the issue for me (pentaho 7.1, postgresql 9.6). on the connection window, options, and set stringtype=unspecified
screenshot
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With