You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Karl Amundsson (JIRA)" <ji...@apache.org> on 2018/05/04 11:13:00 UTC

[jira] [Created] (NIFI-5151) Patch Nifi with Upsert functions for PutDatabaseRecord processor

Karl Amundsson created NIFI-5151:
------------------------------------

             Summary: Patch Nifi with Upsert functions for PutDatabaseRecord processor
                 Key: NIFI-5151
                 URL: https://issues.apache.org/jira/browse/NIFI-5151
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
    Affects Versions: 1.7.0
            Reporter: Karl Amundsson


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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)