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

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

Sujata HS gravatar image

updated 2020-02-24 11:25:50 -0500

metadaddy 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 close merge delete