Support Questions

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

BIT(0) dataType captureChangeMySql processor flowfile out issue -> "value": "{}"

avatar
Contributor

I am reading the mysql mysql-bin.log file using captureChangeMySql processor. processor is ready the binarylog file and I see the processor flowfile content out claim data, it is giving BIT datatype value as "{}". Anyone can help here to get the right value in flowfile output for Bit datatype.

Please find the captureChangeMySql processor configuration screenshot for reference. 

{
"type": "update",
"timestamp": 1657194900000,
"binlog_filename": "mysql-bin.000020",
"binlog_position": 37029,
"database": "nrpsubscriptiondb2306",
"table_name": "user_subscription",
"table_id": 137,
"columns": [

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

]

}

Screenshot from 2022-07-08 19-55-20.png

1 REPLY 1

avatar
Contributor

@araujo Can you please suggest how I can fix above issue.

 

CaptureChangeMySql processor is giving  value "{}" for BIT datatype.

Processor out payload:

{
"type": "update",
"timestamp": 1657194900000,
"binlog_filename": "mysql-bin.000020",
"binlog_position": 37029,
"database": "nrpsubscriptiondb2306",
"table_name": "user_subscription",
"table_id": 137,
"columns": [

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

]

}