Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.7.0
-
Patch
Description
Since Phoenix doesn't support the SQL statement INSERT you have to use a process like: ConvertAttributesToJSON->ConvertJSONToSQL in Insert mode->ReplaceText to replace "INSERT" with "UPSERT" -> PutSQL (See: https://community.hortonworks.com/questions/40561/nifi-phoenix-processor.html)
With this patch you can choose to use UPSERT directly.