Convert Json to Avro in Nifi

Question

Hi,I want to convert json data to avro.I have used GenerateFlowFile and put dummy json value [{"firstname":"prathik","age":21},{"firstname":"arun","age":22}].I have then used ConvertRecord processor and set JsonTreeReader and AvroRecordSetWriter with AvroSchemaRegistry which has the following schema:{"name": "person","namespace": "nifi","type": "record","fields": [{"name": "firstname", "type": "string" },{ "name": "age", "type": "int" }]}But i am getting this as my output : &#14;prathik*&#8;arun,where &#14; is a red dotI am new to Apache Nifi.

SagarKanani · Accepted Answer

Where are you viewing the data ? Is it in Nifi? Avro is in binary format so its not readable in any editor. If you are viewing in Nifi, then you should check if the you embedded the schema or not. If the schema is embedded then something in the flow is wrong. If not, i suppose it can look the way it shows you.

A quick test could be to dump it in HDFS and create an external hive table to check if the data looks correct.

Hope this helps. If the comment helps you to find a solution or move forward, please accept it as a solution for other community members.

Bender · Answer

Hello @P_Rat98 ,

thank you for raising the question about the red dot. Please see this thread that might answer your inquiry.

In short: it is a "non-breaking space character to the file that displays as a red dot".

Please let us know if it helped by pressing the "Accept as Solution" button. Should you need further information, please do not hesitate to reach out to the Community.

Best regards:

Ferenc

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.