Support Questions

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

How to get the right value like 0 or 1 format from CaptureChangeMySQL processor flowfile output for BIT(1) data type.

avatar
Contributor

Hi All,

I am using NiFi CaptureChangeMySQL processor to read the mysql binarylogs file data.   CaptureChangeMySQL processor flowfile output has "{}" value for BIT(1) data type.

How to get the right value like 0 or 1 format from CaptureChangeMySQL processor flowfile output.

 

{
"id": 29,
"name": "is_deleted",
"column_type": -7,
"last_value": "{}",
"value": "{}"
},

 

Screenshot from 2022-07-07 17-44-51.png

0 REPLIES 0