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

["PJ Fanning (Jira)" <ji...@apache.org>]

PJ Fanning created DRILL-8149:
---------------------------------

             Summary: 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


[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.1#820001)