[jira] [Updated] (NIFI-15981) ClickHouse - LookupRecord fails when trying to return Array(String)

["Peter Turcsanyi (Jira)" <ji...@apache.org>]

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

Peter Turcsanyi updated NIFI-15981:
-----------------------------------
    Fix Version/s: 2.10.0
       Resolution: Fixed
           Status: Resolved  (was: Patch Available)

> ClickHouse - LookupRecord fails when trying to return Array(String)
> -------------------------------------------------------------------
>
>                 Key: NIFI-15981
>                 URL: https://issues.apache.org/jira/browse/NIFI-15981
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Jordan Sammut
>            Assignee: Pierre Villard
>            Priority: Critical
>             Fix For: 2.10.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> I have the following view in ClickHouse (Cloud):
> {code:java}
> CREATE OR REPLACE VIEW marts.dim_client
> AS SELECT
>        client_name,
>        max(updated_at) AS updated_at,
>        argMaxIfMerge(is_enabled) AS is_enabled,
>        nullIf(argMaxIfMerge(license), '<Empty>') AS license,
>        nullIf(argMaxIfMerge(client_group), '<Empty>') AS client_group,
>        nullIf(argMaxIfMerge(platform), '<Empty>') AS platform,
>        nullIf(argMaxIfMerge(reporting_currency), '<Empty>') AS reporting_currency,
>        ['Test'] AS enabled_products
>    FROM marts._dim_client
>    GROUP BY client_name; {code}
> When setting up a lookup service to make use of this and include the enabled_products, the LookupRecord returns this error:
> {code:java}
> LookupRecord[id=33edff77-c78b-367d-aafe-ebc375757016] Could not determine schema to use for enriched FlowFiles: java.lang.NullPointerException: Cannot invoke "org.apache.nifi.serialization.record.RecordSchema.getField(String)" because "readerSchema" is null {code}
> The reader utilized is set to infer the schema, and it should be able to from the result returned. When removing the field from the returned fields, the Lookup works well



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