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 220.127.116.11.0.0.0-453
I tried "Translate Field Names" property of ConvertJSONtoSQL set to false but i still got the same error.
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.