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)