[NIFI-5151] Patch Nifi with Upsert functions for PutDatabaseRecord processor

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.0
• Fix Version/s: 2.0.0-M1, 1.22.0
• Component/s: Extensions
• Labels: Processor
• Flags: Patch
• Assignee: Lehel Boér
• Reporter: Karl Amundsson
• Created: 04/May/18 11:12
• Updated: 22/May/23 11:27
• Resolved: 18/May/23 20:02

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.

Issue Links

• is related to: NIFI-6934 Support Postgres 9.5+ Upsert in the standard PutDatabaseRecord processor
• links to: #7263