Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-3902

CaptureChangeMySQL returns null column values if no DistributedMapCacheClient is selected

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: None
    • Component/s: Extensions
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mattyb149 Matt Burgess
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: