You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2025/10/24 21:37:00 UTC
[jira] [Commented] (NIFI-13531) ExecuteSQLRecord with CSVRecordSetWriter : Value Separator not supported Expression Language
[ https://issues.apache.org/jira/browse/NIFI-13531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18032874#comment-18032874 ]
ASF subversion and git services commented on NIFI-13531:
--------------------------------------------------------
Commit 3755a647880426b4e73f9be7fba152eef59b249a in nifi's branch refs/heads/main from Filip Maretić
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=3755a64788 ]
NIFI-13531 Fixed ExecuteSQLRecord to honor FlowFile attributes for configured RecordWriter (#9909)
Signed-off-by: David Handermann <ex...@apache.org>
> 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 Ksolves Nifi Expertise
> Priority: Trivial
> Time Spent: 1h 10m
> 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)