Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Don't have an account?
Coming from Hortonworks? Activate your account here