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 Screenshot from 2022-07-07 17-44-51.png](https://community.cloudera.com/t5/image/serverpage/image-id/34796i704305C64B1E9159/image-size/large?v=v2&px=999)