Support Questions
Find answers, ask questions, and share your expertise

Invalid mysql JSON column data(Encoded) in Nifi CDC processor

Invalid mysql JSON column data(Encoded) in Nifi CDC processor

New Contributor

I have a NiFi setup, through NiFi CDC I am trying to pull data from binary logs (MySQL version 5.7) to store on AWS S3. But for JSON columns in MySQL, value is encoded and it seems processed data is not in correct format. Not sure, this issue is with NiFi or anywhere else. Actual value - {"name":"123"} Processed data with NiFi CDC - \u0000\u0001\u0000\u0013\u0000\u000B\u0000\u0004\u0000\f\u000F\u0000name\u0003123