[jira] [Updated] (DRILL-8149) format-excel plugin needs to support POI IOUtils byte array overrides to support big files

["James Turton (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-8149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Turton updated DRILL-8149:
--------------------------------
    Fix Version/s: 2.0.0

> format-excel plugin needs to support POI IOUtils byte array overrides to support big files
> ------------------------------------------------------------------------------------------
>
>                 Key: DRILL-8149
>                 URL: https://issues.apache.org/jira/browse/DRILL-8149
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Execution - Data Types
>    Affects Versions: 1.19.0
>            Reporter: PJ Fanning
>            Priority: Major
>             Fix For: 2.0.0
>
>
> [https://poi.apache.org/components/configuration.html] - see [org.apache.poi.util.IOUtils.setByteArrayMaxOverride(int maxOverride)|https://poi.apache.org/apidocs/5.0/org/apache/poi/util/IOUtils.html#setByteArrayMaxOverride-int-]
> Core POI code tries to set limits on resource allocations. excel-streaming-reader may not be as heavily affected by these settings because it only used parts of the core POI codebase.
> POI 5.2.1 (due in next few weeks) fixes a few issues but there is some evidence that core POI users are hitting issues when loading large files and having to set  the byte array max override setting.
> I can do some testing of the format-excel plugin to see if it can hit these issues with large files.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)