Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How do I convert tables with boolean fields to json using Apache NIFI?

avatar
New Contributor

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:
querytable_config.PNG


Also, I have configured the JsonRecortSetWriter with the following properties:
jsonwriter_config.PNG


When I run the process, I get the following error:
nifi_error.png

 

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:
t_ville_cap.PNG

 

I've tried many solutions but nothing works.
Any idea please ?

0 REPLIES 0