Hi Toivo, Thanks for your reply.
Yes, error message contain database name and table name(database.table) But names of the fields are same and I tried with option “Translate Field Names” also but facing same issue. GetFile-->Split-->InferAvroSchema-->convertCsvtoAvro-->ConvertAvroToJson-->ConvertJsonToSQL-->PutSQL-->LogAttribute Please suggest me. Thanks, Sravani From: Toivo Adams [mailto:toivo.ad...@gmail.com] Sent: Friday, January 20, 2017 7:23 PM To: users@nifi.apache.org Subject: Re: ConverJsonToSql issue Hi Sravani, Weird, error message should also contain database table name. It seems none of the database table column names match with JSON field names. If names are different, you can use "Translate Field Names" property to specify mappings. Regards, Toivo 2017-01-20 12:04 GMT+02:00 Gadiputi, Sravani <sravani.gadip...@capgemini.com<mailto:sravani.gadip...@capgemini.com>>: Hi Team, I am facing the issue with ConverJsonToSql processor in Nifi. I am trying to read the csv file and load the data in to Teradata table. My flow is look like below: GetFile-->Split-->convertCsvtoAvro-->ConvertAvroToJson--->ConvertJsonToSQL-->PutSQL-->LogAttribute When it comes to convertJsonToSql, it is not able to map the JSON fields with table field. Error: Failed to convert Slandered Flowfile record and None of the fields in the JSON map to the columns defined by the table. Any ideas/suggestions to resolve this? Thanks in Advance!! Regards, Sravani This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
