How do I convert tables with boolean fields to json using Apache NIFI?
I am trying to extract a table from a Sybase database and convert it to a json file.
I'm using the QueryDatabaseTableRecord processor with the following properties:
Also, I have configured the JsonRecortSetWriter with the following properties:
When I run the process, I get the following error:
The problem is that values in the boolean field "defo" in the table are considered as integer rather than boolean. Here is a caption from the table I want to convert:
I've tried many solutions but nothing works.
Any idea please ?