[
https://issues.apache.org/jira/browse/NIFI-7862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635523#comment-17635523
]
ASF subversion and git services commented on NIFI-7862:
-------------------------------------------------------
Commit 214bd2f00c78b5b7b35b46ac82defa3692752ce2 in nifi's branch
refs/heads/main from Matt Burgess
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=214bd2f00c ]
NIFI-7862: Add UpdateDatabaseTable processor for auto table structure updates
Signed-off-by: Joe Gresock <[email protected]>
This closes #5523.
> Add UpdateDatabaseTable processor to optionally create the target table
> and/or columns if they don't exist
> ----------------------------------------------------------------------------------------------------------
>
> Key: NIFI-7862
> URL: https://issues.apache.org/jira/browse/NIFI-7862
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Reporter: Matt Burgess
> Assignee: Matt Burgess
> Priority: Major
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> As part of NIFI-6934, the "Database Type" property was added, allowing for
> DB-specific SQL/DML to be generated. That property could be used with a new
> true/false property "Create Table" that would create the target table if it
> didn't already exist. mapping the NiFi Record datatypes to DB-specific column
> types and generating/executing a DB-specific CREATE TABLE statement. If
> "Create Table" is set to true and an error occurs while attempting to create
> the table, the flowfile should be routed to failure or rolled back (depending
> on the setting of the "Rollback on Failure" property).
> Also it could support some schema migration (adding columns, e.g.) with an
> additional value in the "Unmatched Field Behavior" property for "Create
> Column on Unmatched Fields". The use case here is for feature parity with
> UpdateHiveTable (see NIFI-7989)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
