[
https://issues.apache.org/jira/browse/NIFI-13531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17987288#comment-17987288
]
Samkit Jain commented on NIFI-13531:
------------------------------------
PR submitted: https://github.com/apache/nifi/pull/10061
Requesting a committer to please move this ticket to "Patch Available" as I
don’t have transition permission.
> ExecuteSQLRecord with CSVRecordSetWriter : Value Separator not supported
> Expression Language
> --------------------------------------------------------------------------------------------
>
> Key: NIFI-13531
> URL: https://issues.apache.org/jira/browse/NIFI-13531
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.15.3, 1.25.0, 2.0.0-M4
> Reporter: Thierry PRATS
> Assignee: Samkit Jain
> Priority: Trivial
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
