How insert UUID values in PostgreSQL table via Kettle?

Question

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)

Answer 1

(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