You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Philipp Korniets (Jira)" <ji...@apache.org> on 2023/06/09 15:45:00 UTC

[jira] [Updated] (NIFI-11671) JoinEnrichment SQL strategy doesn't allow attributes in join statement

     [ https://issues.apache.org/jira/browse/NIFI-11671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Philipp Korniets updated NIFI-11671:
------------------------------------
    Description: 
We use ForkEnrichement - JoinEnrichment pattern and want to include filtering in join SQL. Filter value is coming from FlowFile attribute

{code:sql}
${test}  = 'NewValue'

SELECT original.*, enrichment.*,'${test}'
FROM original 
LEFT OUTER JOIN enrichment 
ON original.Underlying = enrichment.Underlying
WHERE enrichment.MyField = '${test}'
{code}

However this doesnt work because JoinEnrichment doesnt use evaluateAttributeExpressions


  was:
We use ForkEnrichement - JoinEnrichment pattern and want to include filtering in join SQL

{code:sql}
${test}  = 'NewValue'

SELECT original.*, enrichment.*,'${test}'
FROM original 
LEFT OUTER JOIN enrichment 
ON original.Underlying = enrichment.Underlying
WHERE enrichment.MyField = '${test}'
{code}

However this doesnt work because JoinEnrichment doesnt use evaluateAttributeExpressions



> JoinEnrichment SQL strategy doesn't allow attributes in join statement
> ----------------------------------------------------------------------
>
>                 Key: NIFI-11671
>                 URL: https://issues.apache.org/jira/browse/NIFI-11671
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Core Framework
>    Affects Versions: 1.18.0, 1.20.0
>            Reporter: Philipp Korniets
>            Priority: Major
>
> We use ForkEnrichement - JoinEnrichment pattern and want to include filtering in join SQL. Filter value is coming from FlowFile attribute
> {code:sql}
> ${test}  = 'NewValue'
> SELECT original.*, enrichment.*,'${test}'
> FROM original 
> LEFT OUTER JOIN enrichment 
> ON original.Underlying = enrichment.Underlying
> WHERE enrichment.MyField = '${test}'
> {code}
> However this doesnt work because JoinEnrichment doesnt use evaluateAttributeExpressions



--
This message was sent by Atlassian Jira
(v8.20.10#820010)