Matt Burgess created NIFI-11209:
-----------------------------------
Summary: UpdateHive3Table and UpdateDatabaseTable erase newly
created columns in output FlowFile
Key: NIFI-11209
URL: https://issues.apache.org/jira/browse/NIFI-11209
Project: Apache NiFi
Issue Type: Bug
Components: Extensions
Reporter: Matt Burgess
When using UpdateHive3Table or PutDatabaseTable with the Update Field Names
property set to "true", the output will include only those fields that already
had existing columns in the target table. This means if an incoming FlowFile
has a "new" field, the column will be created and populated in the target
database, but the output FlowFile will no longer have the "new" fields in the
outgoing records.
This is because the original database columns are used to populate the outgoing
record schema when the Update Field Names property is set to true. Instead the
database columns should be refreshed after any DDL is executed in order to get
the updated set of database column names.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
