Search code examples
postgresqlnullapache-nifi

Null in Apache nifi

I use the processor putSql to write in a Postgres database. I don't know how to insert Null value in a bigInt field. I used :

${my_var:replaceEmpty(null)}

but it doesn't work :

enter image description here

Is there a simple way to do it ? Thanks

Edit : (NULLIF('${my_var}'::text, '')::integer) works fine in putSQL

Solution

  • (NULLIF('${my_var}'::text, '')::integer)

    It works fine in putSQL