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

ExecuteSQLRecord with CSVRecordSetWriter : Value Separator not set when use Expression Language

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Trivial
    • Resolution: Duplicate
    • 1.15.3, 1.25.0, 2.0.0-M4
    • None
    • Extensions
    • None

    Description

      In a CSVRecordSetWriter Controller Service, the parameter "Value Separator" is set using Expression Language like ${delimiter} (where delimiter is defined as "|").

      When I use this Controller Service with ConvertRecord, everything works, my csv file is "|" separator.

      However, when I use the same Controller Service with ExecuteSQLRecord, the Value Separator is set to the default value "," and there is this message in the nifi-app.log :

      WARN [Timer-Driven Process Thread-5] org.apache.nifi.csv.CSVUtils 'Value Separator' property evaluated to an invalid value: "". It must be a single character. The property value will be ignored.

      It seems that the Expression Language is not supported with ExecuteSQLRecord.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              thierry.prats Thierry PRATS
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: