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

Posted to dev@drill.apache.org by GitBox <gi...@apache.org> on 2019/08/07 15:13:40 UTC

[GitHub] [drill] oleg-zinovev edited a comment on issue #1749: DRILL-7177: Format Plugin for Excel Files

oleg-zinovev edited a comment on issue #1749: DRILL-7177: Format Plugin for Excel Files
URL: https://github.com/apache/drill/pull/1749#issuecomment-519141613
 
 
   Since I have same plugin for internal use (https://github.com/idvp-project/drill-storage-excel):
   1) XSSFWorkbook has a awful memory usage. http://apache-poi.1045710.n5.nabble.com/HSSF-and-XSSF-memory-usage-some-numbers-td4312784.html. Reading a 10-15 mb Xlsx file can easily lead to OutOfMemory. 
   2) Excel does not guarantee that the column value type remains static. IMHO, it is better to read everything as VARCHAR.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services