Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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

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": "{}"
}, 

]

}

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.