[
https://issues.apache.org/jira/browse/DRILL-7177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902152#comment-16902152
]
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. So we used
com.monitorjbl:xlsx-streamer project. (No support for a formula evaluation)
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:
us...@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)
