Thierry PRATS created NIFI-13530:
------------------------------------
Summary: ExecuteSQLRecord with CSVRecordSetWriter : Value
Separator not set when use Expression Language
Key: NIFI-13530
URL: https://issues.apache.org/jira/browse/NIFI-13530
Project: Apache NiFi
Issue Type: Bug
Components: Extensions
Affects Versions: 2.0.0-M4, 1.25.0, 1.15.3
Reporter: Thierry PRATS
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 :
{noformat}
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.{noformat}
It seems that the Expression Language is not supported with
{*}ExecuteSQLRecord{*}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)