[jira] [Commented] (DRILL-7177) Format Plugin for Excel Files

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-7177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902145#comment-16902145 ] 

ASF GitHub Bot commented on DRILL-7177:
---------------------------------------

oleg-zinovev commented 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 lines.
 
----------------------------------------------------------------
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


> Format Plugin for Excel Files
> -----------------------------
>
>                 Key: DRILL-7177
>                 URL: https://issues.apache.org/jira/browse/DRILL-7177
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.17.0
>            Reporter: Charles Givre
>            Assignee: Charles Givre
>            Priority: Major
>              Labels: doc-impacting
>             Fix For: 1.17.0
>
>
> This pull request adds the functionality which enables Drill to query Microsoft Excel files. 



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)