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.

failed to convert jsontosql

failed to convert jsontosql

New Contributor

Hi,

I used jsontosql processor to convert json to sql. I am getting below error.

offset=10266, length=1129],offset=0,name=1963423193751,size=1129] to a SQL INSERT statement due to org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the fta.reporter_status table; routing to failure: org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the xxxxx table org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the xxxxx table

properties-jsontosql.jpg

1 REPLY 1
Highlighted

Re: failed to convert jsontosql

Super Guru
@subbu p

This error occurs when processor not able find atleast one column name in the target table matching with your json message columns(keys).

Make sure you are having same column names(case sensitive) matching to your target table in your json message and re run the process again.

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