exceptionfactory commented on PR #9379: URL: https://github.com/apache/nifi/pull/9379#issuecomment-2414619856
> > > 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`. > > Is there anything to do for this case or leave it as is? In this case, it sounds like an explicit schema should be configured with a `STRING` type instead of a `BOOLEAN`. The behavior of converting number `1.0` to a string `TRUE` seems a bit difficult to generalize unless there is some other fact we can use to handle the value as a boolean. -- 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]
