[NIFI-14076] Expression Language doesn't evaluate in the JoinEnrichment processor

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.20.0
• Fix Version/s: 2.0.0
• Environment: NiFi setup on Docker
• Assignee: Pierre Villard
• Reporter: Joby Joje
• Created: 10/Dec/24 15:30
• Updated: 11/Dec/24 14:13
• Resolved: 11/Dec/24 14:13

Description

Hey Team,

I am trying to use an Expression Language in the JoinEnrichment processor, to generate the date on the fly when running the SQL

SQL property on JoinEnrichment

SELECT original.*, '${now():format("yyyy-MM-dd HH:mm:ss", "Europe/Paris")}' AS Dateval FROM original WHERE record_id NOT IN (SELECT record_id FROM enrichment)

This gives me an output as follows without actually evaluating the expression language

[ { "record_id" : "DUMMY--2", "mode_completion" : "2", "Dateval" : "${now():format(\"yyyy-MM-dd HH:mm:ss\", \"Europe/Paris\")}" } ]

When I run the same on QueryRecord processor

SELECT *, '${now():format("yyyy-MM-dd HH:mm:ss", "Europe/Paris")}' AS Dateval FROM FLOWFILE

I get the expression language in the right format as expected

[ { "record_id" : "DUMMY--1", "mode_completion" : "2", "Dateval" : "2024-12-04 00:29:49" }, { "record_id" : "DUMMY--2", "mode_completion" : "2", "Dateval" : "2024-12-04 00:29:49" } ]

I also tried to add the expression language to an attribute using UpdateAttribute processor and use the attribute in the JoinEnrichment  still the same issue it just prints the attribute name as it is.

I am also sharing the sample flow.json for testing.

Issue Links

• duplicates: NIFI-11671 JoinEnrichment SQL strategy doesn't allow attributes in join statement