[
https://issues.apache.org/jira/browse/DRILL-8417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton closed DRILL-8417.
-------------------------------
Resolution: Fixed
> Allow Excel Reader to Ignore Formula Errors
> -------------------------------------------
>
> Key: DRILL-8417
> URL: https://issues.apache.org/jira/browse/DRILL-8417
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Excel
> Affects Versions: 1.21.0
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 1.21.1
>
>
> If Drill encounters an Excel formula which is invalid somehow, such as a
> DIV/0, Drill is unable to proceed and throws a number format exception.
> This PR adds a config parameter called ignoreErrors which allows Drill to
> skip such records and returns null for that cell. Drill will also output a
> log warning. When set to false, original behavior is retained.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
