You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Aaron Leon (JIRA)" <ji...@apache.org> on 2019/02/14 21:38:00 UTC
[jira] [Comment Edited] (NIFI-5151) Patch Nifi with Upsert
functions for PutDatabaseRecord processor
[ https://issues.apache.org/jira/browse/NIFI-5151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16768734#comment-16768734 ]
Aaron Leon edited comment on NIFI-5151 at 2/14/19 9:37 PM:
-----------------------------------------------------------
Can this patch be revisited for the 1.9.0 RC? This would add a ton of value in Hadoop environments, since there is no other way to interface with Phoenix to write records other than workarounds or directly preparing UPSERT statements for PutSQL.
was (Author: aaronleon):
Can this patch be revisited for the 1.9.0 RC?
> 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
> Priority: Major
> Labels: Processor
> Attachments: 0001-NIFI-5151-Adding-support-for-UPSERT-in-PutDatabaseRe.patch, 0001-NIFI-5151-Using-DatabaseAdapter-to-generate-INSERT-S.patch
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> 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)