Stop job from automatically converting a string to an integer

[Anonymous]

I am building a job and want to query a database. I am reading a delimited file containing IDs and timestamps. The schema for the database (PostgreSQL 9.6) and the delimited file are set to varchar/string for the IDs and timestamps for the dates.

When I try to query the database using the ID from the delimited file, I get the following error message:

org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

How can I prevent the job from automatically converting the string to an integer since the strings will only contain integer values but changing the type in the database itself is not possible.

[TRF]

Share your component settings

[Anonymous]

Sorry, here they are. Contains the job export with metadata for the database and delimited file as well as the sql for creating the database and the delimited file itself.

export.zip