[
https://issues.apache.org/jira/browse/DRILL-8417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706895#comment-17706895
]
ASF GitHub Bot commented on DRILL-8417:
---------------------------------------
cgivre opened a new pull request, #2783:
URL: https://github.com/apache/drill/pull/2783
# [DRILL-8417](https://issues.apache.org/jira/browse/DRILL-8417): Allow
Excel Reader to Ignore Formula Errors
## Description
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.
## Documentation
Updated README
* `ignoreErrors`: Defaults to `true`. When set to `true` Drill will return
`null` for any
formulas or any values that are unparseable.
## Testing
Added two unit tests.
> 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)
