[ https://issues.apache.org/jira/browse/NIFI-7862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matt Burgess updated NIFI-7862: ------------------------------- Status: Patch Available (was: In Progress) > 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: 10m > 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.1#820001)