[
https://issues.apache.org/jira/browse/NIFI-3902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Villard resolved NIFI-3902.
----------------------------------
Resolution: Feedback Received
Apache NiFi 1.x is no longer maintained and no new release is planned on the
1.x release line. Marking as resolved as part of a cleanup operation. Please
open a new one with an updated description if this is still relevant for NiFi
2.x.
> CaptureChangeMySQL returns null column values if no DistributedMapCacheClient
> is selected
> -----------------------------------------------------------------------------------------
>
> Key: NIFI-3902
> URL: https://issues.apache.org/jira/browse/NIFI-3902
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.2.0
> Reporter: Matt Burgess
> Priority: Major
>
> The "Distributed Map Cache Client" property of the CaptureChangeMySQL
> processor is not required, if it is not set then no column name or type
> information will be available when generating output flow files from binary
> log events. However if no type information is present and the column value is
> not a number or a byte array, the value of that column will be null in the
> outgoing flow file.
> It may not be possible to accurately represent the value if the type is not
> known, but the value could be set to the String representation of the
> object's value. At best it would correctly represent the value; at worst it
> would indicate that the value is indeed not null but otherwise indeterminate.
> The workaround (and best practice) is to use a DistributedMapCacheClient in
> the CaptureChangeMySQL processor in order to retrieve the column name and
> information for the CDC events.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
