You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Ferdinand (Jira)" <ji...@apache.org> on 2020/07/29 13:20:00 UTC
[jira] [Created] (NIFI-7686) Support multiple key columns in
database lookup services
Ferdinand created NIFI-7686:
-------------------------------
Summary: Support multiple key columns in database lookup services
Key: NIFI-7686
URL: https://issues.apache.org/jira/browse/NIFI-7686
Project: Apache NiFi
Issue Type: Wish
Components: Core Framework
Reporter: Ferdinand
{{SimpleDatabaseLookupService }}and{{ DatabaseRecordLookupService}} require to configure a _"Lookup Key Column"_. However, sometimes the database schema might require you to lookup a record or attribute identified by a composite primary key, i.e. using multiple keys. Wouldn't it be convenient to be able to specify any amount of lookup key columns and {{AND}}-concatenate the respective values in the [query's {{WHERE}}-clause?|https://github.com/apache/nifi/blob/716ba992f5b4641c20465638d62d1e3ffe91d118/nifi-nar-bundles/nifi-standard-services/nifi-lookup-services-bundle/nifi-lookup-services/src/main/java/org/apache/nifi/lookup/db/SimpleDatabaseLookupService.java#L139]?]
Instead of a single string, {{LOOKUP_KEY_COLUMN}} (and the lookups processors' respective fields) may accept a comma-separated list of column names / identifiers.
What are your thoughts on this?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)