[
https://issues.apache.org/jira/browse/NIFI-7862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Gresock updated NIFI-7862:
------------------------------
Fix Version/s: 1.19.0
Resolution: Fixed
Status: Resolved (was: Patch Available)
> 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
> Fix For: 1.19.0
>
> Time Spent: 1h 50m
> 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)
