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

ConvertJSONToSQL Problem

ConvertJSONToSQL Problem

I developed a nifi flow GetTwitter through ConvertJsonToSql and into PutHiveQL, but am getting an error the json key names match the table's column names.

hive table don't have all properties in json document.

hive table have same columns names.

NiFi - Version

I tried "Translate Field Names" property of ConvertJSONtoSQL set to false but i still got the same error.


Re: ConvertJSONToSQL Problem

Super Guru

I suspect you are having the same problem as described in this HCC question. I confirmed this to be a bug in ConvertJSONToSQL, I have written up NIFI-4071, please see the Jira for details.

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