[DRILL-7514] Update Apache POI to Latest Version

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Labels: ready-to-commit
• Assignee: Charles Givre
• Reporter: Charles Givre
• Reviewer: Vova Vysotskyi
• Created: 07/Jan/20 03:28
• Updated: 21/Feb/20 15:55
• Resolved: 21/Feb/20 15:55

Description

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 latest version of POI addresses some of the memory issues and hopefully Drill will be able to query larger Excel files without running out of memory.

 

Issue Links

• links to: GitHub Pull Request #1991