You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2023/04/19 08:40:00 UTC

[jira] [Closed] (DRILL-8417) Allow Excel Reader to Ignore Formula Errors

     [ 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)