Support Questions
Find answers, ask questions, and share your expertise

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.


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.