Not able to insert BIT data type values via streamsets in Postgresql [closed]

asked 2020-02-24 09:05:40 -0500

Sujata HS gravatar image


I was trying to insert data into postgresql via streamsets. I have used JDBC producer stage as destionation. Value I am assigning is "1", But its not allowing me to insert into BIT Datatype column

"Query failed due to type mismatch LONG for column activeflag"

I tried with below values in expression evaluator & filed converter.

flag = ${1} flag = '1' flag = "1"

Note : I have also give field mapping at JDBC producer stage to consider "DB Column type"

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by metadaddy
close date 2020-02-24 11:25:29.635114