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

Posted to issues@drill.apache.org by "Charles Givre (Jira)" <ji...@apache.org> on 2020/01/07 03:29:00 UTC

[jira] [Created] (DRILL-7514) Modify Excel Format Plugin to use Streaming Reader

Charles Givre created DRILL-7514:
------------------------------------

             Summary: Modify Excel Format Plugin to use Streaming Reader 
                 Key: DRILL-7514
                 URL: https://issues.apache.org/jira/browse/DRILL-7514
             Project: Apache Drill
          Issue Type: Improvement
    Affects Versions: 1.17.0
            Reporter: Charles Givre
            Assignee: Charles Givre
             Fix For: 1.18.0


Drill's Excel Format Plugin uses Apache POI to parse Excel files. While this reader is effective in that it parses formulae and data types, it uses memory inefficiently and will struggle to read very large Excel files.  

The Excel Streaming Reader [1] in an extension for the POI which would enable Drill to parse Excel files much more efficiently and greatly improve the reader's performance.  

[[1]: https://github.com/monitorjbl/excel-streaming-reader|https://github.com/monitorjbl/excel-streaming-reader]

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)