dan-s1 commented on PR #9379:
URL: https://github.com/apache/nifi/pull/9379#issuecomment-2414917424
> > Also I noticed even with an explicit schema if we do not get the
formatted form, an exception can be thrown when reading with
`ExcelRecordReader`. The case in point I see is when the schema defines a
boolean and the column returns a boolean from a formula. Without the formatted
form, `1.0` is returned which will not be interpreted as a boolean in Java.
With the formatted form, `TRUE` is returned which can interpreted as a boolean
in Java.
>
> This sounds like a case where the cached formula result type is not
returning `BOOLEAN` and is instead returning `NUMERIC` or `STRING`.
Its actually returning a NUMERIC a double to be precise. From your latest
changes the corresponding field in the schema is producing
`{"name":"Boolean_Function","type":["double","null"]}`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
